I'm trying to query all queued notifications of my table 'notifications' table in DynamoDB.
Global Secondary Indexes: Name: idTo-time-index
Hash Key: idTo (Number)
Range Key: time (Number)
Why I'm getting all results and not only the ones with status=='queued'
?
$params = array(
'TableName' => 'notifications',
'IndexName' => 'idTo-time-index',
'KeyConditions' => array(
"idTo" => array(
"AttributeValueList" => array(
array('N' => 1)
),
"ComparisonOperator" => "EQ"
)
),
'ScanIndexForward' => false,
'QueryFilter' => array(
"status" => array(
"AttributeValueList" => array(
array('S' => (string)"queued")
),
"ComparisonOperator" => "EQ"
)
),
);
$response = $dynoClient->query($params);