Query dynamDB table for messaging app

Question

I'm trying to create a messaging feature for my app using DynamoDB.
However, I can only see the messages that I send. 
I can't seem to query the messages that are sent to me.

In the appsync console, When I run this query I get a result:

```
query MyQuery {
  messagesByFriendIDAndUserID(friendID: "b99e4488-4061-704f-af2a-69560ee0f184", userID: {eq: "39ae94c8-4041-7016-157d-53ab46b8c1bd"}) {
    nextToken
    startedAt
    items {
      id
      friendID
      userID
      content
    }
  }
}
```

However when I switch the friendID and userID like this, I don't get a result, even though there is relevant data in the messages table.

```
query MyQuery {
  messagesByFriendIDAndUserID(friendID: "39ae94c8-4041-7016-157d-53ab46b8c1bd", userID: {eq: "b99e4488-4061-704f-af2a-69560ee0f184"}) {
    nextToken
    startedAt
    items {
      id
      friendID
      userID
      content
    }
  }
}
```
Does anyone know why this would be the case?

Dheeraj Kumar · Answer

It would difficult to provide exact answer when schema of the table is not know but I can see that you have swapped the **values** in the query but did not swap the **keys**, so there might be a possibility that the value you provided with respect to the key does not exist in the table. Please check the schema of the table and try to rewrite your query.

Luke · Answer

Thanks. I solved this by adding private read access to the message table. If the friendID was the logged in cognito user ID, it wouldn't fetch the results.

Query dynamDB table for messaging app

Relevant content