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.
Will it affect response time?