带有多条件javascript的DynamoDB FilterExpression

Question

我有一个带有分区键和排序键的表，还有另外两列。我无法在使用javaScript AWS SDK的DynamoDB中使用FilterExpression获得多个条件下的项。有人能提供正确的代码来检索FilterExpression中有多个条件的数据吗？我的代码如下：

var params = {
    TableName: 'Department',
    KeyConditionExpression: '#company = :companyId'
    , ExpressionAttributeNames: {
        '#company': 'CompanyID',
        '#dType': 'DepartmentType',
        '#cTime': 'CreatedTime'
    }
    , ExpressionAttributeValues: {
        ':companyId': 'Test',
        ':deptType': dType,
        ':daysPrior': 1250456879634
    },FilterExpression: '#dType = :deptType AND #ts > :daysPrior' 
};

Answer 1

查询中的格式存在错别字(createdtime之后）要保持其干净，请使用双引号或单引号，但不能同时使用双引号或单引号。我使用了双引号，就像aws示例代码一样。

var params = {
    TableName: "Department",
    KeyConditionExpression: "#company = :companyId", 
    ExpressionAttributeNames: {
        "#company": "CompanyID",
        "#dType": "DepartmentType",
        "#cTime": "CreatedTime" //here
    },
    ExpressionAttributeValues: {
        ":companyId": "Test",
        ":deptType": dType,
        ":daysPrior": 1250456879634
    },
    FilterExpression: "#dType = :deptType AND #ts > :daysPrior" 
};