PQuery behavior for same parameters
I'm noticing interesting behavior for a specific query in my app for different users.
The query fetches a list of
The
Within the query, I use the
Then I return this list to my webapp. However, in the case that two different users fetch messages by the same
While this is a rare edge case for our app, I'm trying to understand why this happens. Do I need to disambiguate the queries by providing a different additional parameter for each user?
The query fetches a list of
messagesmessages for a given user by conversation ID. e.g. fetchMessagesByConvoId(convoId: number)fetchMessagesByConvoId(convoId: number)The
messagesmessages table is indexed by conversationIdconversationId.Within the query, I use the
authauth object to fetch the user that called the query and use userIduserId to filter messages by calling something like query(messages).indexby(convoId).filter(ownerUserId == userId)query(messages).indexby(convoId).filter(ownerUserId == userId).Then I return this list to my webapp. However, in the case that two different users fetch messages by the same
convoIdconvoId, only the last user to call the query is returned the list of messages (the other user's list of messages becomes empty). While this is a rare edge case for our app, I'm trying to understand why this happens. Do I need to disambiguate the queries by providing a different additional parameter for each user?
