Feed query only rss site

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
 

appyet

Support Team Member
Staff member
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
 

mouradh

New Member
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"

and at the next screen copy the Feed GUID (not module GUID)

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:
 

mouradh

New Member
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?
 

Pukos

New Member
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
Is not clear where to put the query to build tables. I had to create a feed query module for it?
 

leonardo

New Member
[QUOTE = "mouradh, post: 240, membro: 70"] Olá,
À direita da linha do "Módulo de feed" do site, clique em Detalhes, depois na guia "Feed" e clique em "Atualizar"

e na próxima tela copie o GUID de alimentação (não o GUID do módulo)

Você pode voltar para o Módulo de consulta de feed e colá-lo:

IsRead = 0 AND IsDeleted = 0 E FeedId IN (SELECT FeedId FROM Feed WHERE GUID IN (' f57bb826bc0044e38336cf132b5d7486 ')) E O EnclosureLink é nulo

Substitua f57bb826bc0044e38336cf132b5d7486 pelo GUID de alimentação do GUID de alimentação "notícias do site Rss"

Se você quiser adicionar muito mais, basta adicionar "outro GUID de feed" como:
[/CITAR]
 

leonardo

New Member
Ola amigo eu criei um App desse para meu Blog só que quando o app inicia ele salva os postes Offline mas eu queria que o módulo feed Blog quando alguém clica-se na lista fosse direto pro site.
Tem como você me ajudar?
 

Toufik

Member
more explication plz @appyet
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
more explication plz
 

fareszr

New Member
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

hi i couldn't get it to work even with the feed guid method
same result it shows no articles available
 
Top