Articles count is not showing in feed query

Keve

New Member
In FeedQuery the 'Last 24 hours' articles count is not showing. I'm using classic menu
 

appyet

Support Team Member
Staff member
your custom feed query is invalid: PubDate > [NOW] - 43200000 AND IsDeleted = 0 Group by PubDate having COUNT(PubDate) >= 1
it should be PubDate > [NOW] - 43200000 AND IsDeleted = 0
Group by is not supported, it gives follow error:
java.sql.SQLException: Problems executing Android query:
SELECT COUNT(*) FROM `FeedItem` WHERE (`IsRead` = 0 AND PubDate > 1592566348640 - 43200000 AND IsDeleted = 0 Group by PubDate having COUNT(PubDate) >= 1 )
 
Top