search inside a list in dynamodb using nodejs

Question

I'm working on a project and we are using Dynamodb as database and i have a document with this structure :

{
   "shop_id": "hh-delightme",
   "shoppers": [
      {
        "email": "[email protected]",
        "name": "hatim haffane"
       },
       {
         "email": "[email protected]",
         "name": "bxdsf sdf sd f"
       }
     ]
  },{
   "shop_id": "it-delightme",
   "shoppers": [
       {
         "email": "[email protected]",
         "name": "hatim haffane"
        },
        {
         "email": "[email protected]",
         "name": "bxdsf sdf sd f"
        }
      ]
    }

i have two indexs the shop-id-index and email-index , so what i want to do is to get the shoper with the email "[email protected]" in the shop_id "hh-delightme"

i tried this code but without success

var params = {
            TableName:"shopper",
            KeyConditionExpression:"shop_id = :shop_id AND email = :email",
            ExpressionAttributeValues: {
                ":shop_id":store,
                ":email":email
            }

        };

        docClient.query(params, function(err, data) {}

can any one help me to get this done , thanks

Mark Hayward · Accepted Answer · 2017-09-14 19:43:03Z

2

I believe you cannot query two indexes at the same time. You can either change your query to a scan - but this will be slower as it will scan the whole table for each query - or you can query just one of your indexes. I'd query the index that you think will return the lowest number of results, probably email, and then filter the results in your nodejs code by shop_id.

answered Sep 14, 2017 at 19:43

Mark Hayward

4441 gold badge5 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

search inside a list in dynamodb using nodejs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related