Querying with multiple local Secondary Index Dynamodb : <p>I have 2 LSI in my table with a primary partition Key with primary sort key</p>

<p>Org-ID - primary partition Key</p>

<p>ClientID- primary sort Key</p>

<p>Gender - LSI</p>

<p>Section - LSI</p>

<p>I have no issue with querying a table with one LSI, but how to mention <strong>2 LSI</strong> in a table schema.</p>

<pre><code> var params = {
 TableName:"MyTable",
 IndexNames: ['ClientID-Gender-index','ClientID-Section-index'], 

KeyConditionExpression : '#Key1 = :Value1 and #Key2=:Value2 and #Key3=:Value3', 

ExpressionAttributeNames:{
"#Key1":"Org-ID",
"#Key2":"Gender",
"#Key3":"Section"
},

ExpressionAttributeValues : {
':Value1' :"Microsoft",
':Value2':"Male",
':Value3':"Cloud Computing"
}};
</code></pre>

<p>Can anyone fix the issue in <strong>IndexName</strong>(line 3) or KeyConditionExpression(line 4), I'm not sure about it.</p>

<p>Issue</p>

<p>Condition can be of length 1 or 2 only</p>
