Adding a where clause to AWS DynamoDB
<p>I am trying to create a getItem request in AWS Lambda to access DynamoDB like so:</p>

<pre><code>dynamodb.getItem({
    TableName: "DataTable",
    Key: {
        user: {
            S: user
        },
        deleted: {
            BOOL: false
        }
    }
}, function(err, data) {
    if (err) return fn(err);
    else {
        if ('Item' in data) {
            fn(null, user);
        } else {
            fn(null, null); // User not found
        }
    }
});
</code></pre>

<p>It worked fine when I passed the user in as that was the primary key on the table.  I added a deleted boolean to create a soft delete on users. But one I added that in the schema errors started to happen as deleted isn't part of the primary key.  I want a way to add it as a where clause coming from the relational DB world. How is this done? Thanks. :o)</p>