Feed query only rss site

Discussion in 'Feed Module Discussion' started by mantovani massimiliano, Feb 9, 2015.

  1. mantovani massimiliano

    Joined:
    Feb 9, 2015
    Messages:
    2
    Likes Received:
    0
    Hi all,
    I have some RSS news in app (site, FB. TW and Youtube) and I want create an RSS query module for see only the unread news of site.
    In query I have write "IsRead=0 AND IsDeleted = 0" but in this case all unreaded news is showed (FB, Twitter and youtube included).

    It's possible showing only the RSS site news?

    Tanks
     
    #1
  2. appyet

    appyet Support Team Member
    Staff Member

    Joined:
    Feb 2, 2015
    Messages:
    1,071
    Likes Received:
    379
    Table Definition:
    CREATE TABLE Module (
    ModuleId INTEGER PRIMARY KEY AUTOINCREMENT ,
    Guid VARCHAR,
    Type VARCHAR ,
    Name VARCHAR ,
    GroupName VARCHAR ,
    StatusLabel VARCHAR ,
    Icon VARCHAR ,
    SortOrder INTEGER
    );

    CREATE TABLE Feed (
    FeedId INTEGER PRIMARY KEY AUTOINCREMENT ,
    Guid VARCHAR,
    ModuleId INTEGER ,
    Encoding VARCHAR ,
    FavIcon VARCHAR ,
    ImageLink VARCHAR,
    FeedType VARCHAR ,
    Link VARCHAR NOT NULL ,
    PubDate BIGINT ,
    Title VARCHAR ,
    TotalCount INTEGER DEFAULT 0 ,
    UnreadCount INTEGER DEFAULT 0 ,
    WebLink VARCHAR,
    StreamHash VARCHAR,
    SyncDate BIGINT,
    IsAutoMobilize SMALLINT,
    MobilizeProvider VARCHAR,
    IsDownloadNewEnclosure SMALLINT,
    CacheGuid VARCHAR,
    HTTPLastModified VARCHAR,
    HTTPETag VARCHAR
    );

    CREATE TABLE FeedItem (
    FeedItemId INTEGER PRIMARY KEY AUTOINCREMENT ,
    FeedId INTEGER ,
    Author VARCHAR ,
    CommentsLink VARCHAR ,
    Description VARCHAR ,
    EnclosureCurrentPosition INTEGER ,
    EnclosureDuration INTEGER ,
    EnclosureLength INTEGER ,
    EnclosureLink VARCHAR ,
    EnclosureType VARCHAR ,
    Title VARCHAR ,
    Thumbnail VARCHAR ,
    Snippet VARCHAR ,
    PubDate BIGINT NOT NULL ,
    UniqueKey VARCHAR ,
    Link VARCHAR ,
    IsStar SMALLINT ,
    IsRead SMALLINT ,
    IsDeleted SMALLINT ,
    IsQueued SMALLINT,
    QueueOrder INTEGER,
    ArticleStatus SMALLINT,
    EnclosureStatus SMALLINT,
    Article VARCHAR,
    CacheGuid VARCHAR,
    CreatedDate INTEGER
    );


    Following is example:

    Assuming Feed Guid = cafd5d05542d43a09ade192c2bf5d752

    FeedQuery: FeedId IN (SELECT FeedId FROM Feed WHERE GUID = 'cafd5d05542d43a09ade192c2bf5d752')

    In your example, would looks like: IsRead=0 AND IsDeleted = 0 AND FeedId IN (SELECT FeedId FROM Feed WHERE GUID = 'cafd5d05542d43a09ade192c2bf5d752')

    replace above guid with your module guid
     
    #2
    joseph raphael likes this.
  3. mouradh

    mouradh New Member

    Joined:
    Feb 9, 2015
    Messages:
    10
    Likes Received:
    3
    Hello,
    at the right of the line of the site's "Feed module" click on Details, then on Feed's Tab and click on "Update"
    [​IMG]
    and at the next screen copy the Feed GUID (not module GUID)
    [​IMG]

    You can go back to your Feed Query Module and paste this:

    IsRead=0 AND IsDeleted = 0 AND FeedId IN (SELECT FeedId FROM Feed WHERE GUID IN ('f57bb826bc0044e38336cf132b5d7486')) AND EnclosureLink is null

    replace f57bb826bc0044e38336cf132b5d7486 by the Feed GUID of your "Rss site news" 's Feed GUID

    if you want to add much more, just add ,'another Feed GUID' like:
    [​IMG]
     
    #3
    Keve and appyet like this.
  4. mantovani massimiliano

    Joined:
    Feb 9, 2015
    Messages:
    2
    Likes Received:
    0
    Thanks, but do not works!!! :(:(:mad:
     
    #4
    Last edited: Feb 11, 2015
  5. mouradh

    mouradh New Member

    Joined:
    Feb 9, 2015
    Messages:
    10
    Likes Received:
    3
    What happen when you launch your App?

    Wich ' did you use? For AZERTY Keyboard you need to push Key 4, without shift, above the Key R

    could you paste the Feed QUERY or a screenshot?
     
    #5
  6. Phyo Wai Soe

    Phyo Wai Soe New Member

    Joined:
    Feb 14, 2016
    Messages:
    2
    Likes Received:
    0
    How to add facebook Rss.the post in this team doesn't working. Help me with screen shot.
     
    #6
  7. robertjbarreto

    robertjbarreto New Member

    Joined:
    May 20, 2016
    Messages:
    1
    Likes Received:
    0
    Hi Phyo, https://fbrss.com/
     
    #7
  8. saeed ali

    saeed ali New Member

    Joined:
    Feb 11, 2016
    Messages:
    1
    Likes Received:
    0
    Like

    ارسال شده از SM-G355Hs با استفاده از نوق نیوز
     
    #8
  9. Galftuga

    Galftuga New Member

    Joined:
    Jul 22, 2017
    Messages:
    3
    Likes Received:
    0
    Don't work this link, and need make apps with option, like, comment and share
     
    #9
  10. Demostenes Valera

    Demostenes Valera New Member

    Joined:
    Jan 2, 2018
    Messages:
    2
    Likes Received:
    0
    i want to change the source where the query gets from... what site as a source does it take from?
     
    #10
  11. Galftuga

    Galftuga New Member

    Joined:
    Jul 22, 2017
    Messages:
    3
    Likes Received:
    0
    Facebook
     
    #11
  12. Demostenes Valera

    Demostenes Valera New Member

    Joined:
    Jan 2, 2018
    Messages:
    2
    Likes Received:
    0
    Fanpage...on facebook. Yes
     
    #12
  13. Pukos

    Pukos New Member

    Joined:
    Feb 4, 2017
    Messages:
    3
    Likes Received:
    0
    Is not clear where to put the query to build tables. I had to create a feed query module for it?
     
    #13

Share This Page