How to query multiple data from aws dynamo db?

Question

im using aws dynamo db to fetch all datas from a userkyc table where kyc_status should be "A" and "D". Below code i can only use either "A" or "D". How do i fetch all data for both conditions. Help will be appreciated!

  var params = {
            TableName: "user_kyc",
            ProjectionExpression: "email, uid, kyc_status",
            KeyConditionExpression: "#kyc_status = :kyc_status",
            ExpressionAttributeNames: {
                "#kyc_status": "kyc_status",
            },
            ExpressionAttributeValues: {
                ":kyc_status": "A"
               

            },
            FilterExpression: "#kyc_status = :kyc_status"
        };

Raul Barreto · Accepted Answer · 2020-08-12 12:45:50Z

2

You could change your params to something like:

var params = {
   TableName: "user_kyc",
   ProjectionExpression: "email, uid, kyc_status",
   KeyConditionExpression: "#kyc_status = :kyc_status1 or #kyc_status = :kyc_status2",
   ExpressionAttributeNames: {
     "#kyc_status": "kyc_status",
   },
   ExpressionAttributeValues: {
     ":kyc_status1": "A",
     ":kyc_status2": "D"
   }
};

Here I added another variable, now there is :kyc_status1 and :kyc_status2, and used this now variable in KeyConditionExpression to do a or expression.

answered Aug 12, 2020 at 12:45

Raul Barreto

1,1246 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to query multiple data from aws dynamo db?

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