How to query data from dynamoDB table with multiple filter layers?


I'm using AWS appsync API with lambda resolver. My question is how to add 2 separate filter when querying data from DynamoDB using direct lambda resolver?

My app is a news app. It has a feed. I want to show content in that feed like mixture of News of native country + News with 100K+ views. My problem is if I add and operator, condition will be like: native country news AND news with 100k+ views it will filter out only native country new with 100K+ views. But I want to show both native country news as well as global news with 100k+ views. Secondly if I use OR operator then if one condition become true it will fetch that type of content but I want in every 15 post there should be 10 native country news and 5 global news.

My question is I want that both conditions should be satisfied separately? if we use AND operator it will limit one condition.

1 Answer
Accepted Answer

You are in a situation where you need to separate query, as your limit based on the condition so a single dynamodb query can have a single limit parameter

It s an application solution

Simply run two parallel tasks retrieving 2 query and mix them up

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions