我有一个名为User的表格。它有一个哈希键为用户ID,一个范围键为组织ID。
如何返回所有组织ID为“3”的用户?
(顺便说一下,这是一个Lambda函数)
这段代码给了我一个错误:
console.log('Loading event');
var AWS = require('aws-sdk');
var dynamodb = new AWS.DynamoDB({apiVersion: '2012-08-10'});
exports.handler = function(event, context) {
dynamodb.listTables(function(err, data) {
});
var params = {
"TableName": "PoliceUser",
"Key":
{"User Id" : {"S":event.objectId}, "Organization Id" : {"S": event.organizationId}
},
"ProjectionExpression": "#firstName, #lastName, #longitude, #latitude, #organizationName",
"ExpressionAttributeNames" : {"#firstName": "First Name", "#lastName": "Last Name", "#longitude": "Longitude", "#latitude": "Latitude", "#organizationName": "Organization"},
"ConsistentRead" : true
}
dynamodb.BatchGetItem(params, function(err, data)
{
if (err) {
context.fail('error','Error updating item: '+err);
console.log(err);
}
else
{
// console.log('great success: '+JSON.stringify(data, null, ' '));
console.log(data);
context.succeed( data);
}
// successful response
});
};