Forum Discussion

allensmith81's avatar
allensmith81
Boss
7 years ago

Using user_context.read as a constraint on messages collection

Hi all,

 

We are wanting to use a Liql Query like 'Select * from messages where user_context.read = false and board.id='boardid''

 

Essentially what we want to do is be able to list only unread messages for the user in a give board but I cant find a way to do that, any suggestions?

11 Replies

Sort By
Show More
  • allensmith81's avatar
    allensmith81
    Boss
    7 months ago

    So this user_context.read, which is returned when you make a call to the API, it doesn't have a value stored some where but is calculated on the fly? is that the problem?

    I am beginning to think a) wait for aurora and b) if I was going to do this I would be better to do it in and endpoint so the performance hit was on the server side.