peterlu
7 years agoChampion
API v2 featured posts bug
Hi Lithium,
I have tried to add
WHERE board.id = 'Blog' AND depth = 0 and conversation.featured = true Order By conversation.featured ASC
It throws me an error message
conversation.featured sort can only be combined with depth = 0 and conversation.featured = true in the WHERE clause
It is saying that I cannot add board.id = 'Blog' in where clause
I think this is a LITHIUM API core bug.
We only want features posts from 1 particular board, but not the whole community
Lithium Doc says
conversation.featured | Sort by order defined for Featured Threads as defined in Community Admin > Content > Featured Threads > Ordering. | 17.9 |
SELECT topic.subject, kudos FROM messages WHERE conversation.featured = true AND depth=0 Order By conversation.featured ASC |
Peter