title: How to use “IN” statement in FilterExpression using array - dynamodb
body: <p>Checked AWS document but did not find any working example.</p>
  
  <p>Here is my attempt</p>
  
  <pre><code>var params = {
              TableName: "User",
              IndexName:"a-b-index",
              KeyConditionExpression: "Country = :country and #s = :status",
              FilterExpression: "Id IN (:e)",
              ExpressionAttributeValues: {
                ":country ": "USA",
                ":status": 1,
                ":e": "1"
  
              },
              ExpressionAttributeNames: {"#s": "Status"}
            };
  
            //get users
            dynamodb.query(params, function (err, data) {
              if (err)
                //error
              else {
                //success
  
              }
            });
  </code></pre>
  
  <p>Got records but it is fetching record which have id <code>1</code> but i want to use array like this</p>
  
  <pre><code> var params = {
          TableName: "User",
          IndexName:"a-b-index",
          KeyConditionExpression: "Country = :country and #s = :status",
          FilterExpression: "Id IN (:e)",
          ExpressionAttributeValues: {
            ":country ": "USA",
            ":status": 1,
            ":e": ["1","2","3"]
  
          },
          ExpressionAttributeNames: {"#s": "Status"}
        };
  
        //get users
        dynamodb.query(params, function (err, data) {
          if (err)
            //error
          else {
            //success
  
          }
         });
  </code></pre>
  
  <p>How can make above code as working.want to get records. syntax is correct and query run without error but i am not getting records</p>