date - 亚马逊 DynamoDB : How to search for range of dates?

Question

我有一个 DynamoDB，那里的一些项目有一个日期字段。日期字段是格式为 {YYYY-MM-DD} 的字符串。我应该写什么，数据库将检索日期字段在开始日期和结束日期之间的所有项目？

这是我的代码:

function searchFile(from_date, until_date) {
    AWS.config = new AWS.Config({accessKeyId: '***', secretAccessKey: '***', region: '***'});
    var dynamodb = new AWS.DynamoDB({apiVersion: '2012-08-10'});
    var params = {
        "TableName" : '***',
        FilterExpression: "Date_ = :date",
        ExpressionAttributeValues: {
          // What should I write here?
        },
    }
    dynamodb.scan(params, function(err,data) {
        if (err) {
            console.log(err);
        }
        console.log(data);
    })
}

Answer 1

DynamoDB 将日期存储为字符串。您可以使用 BETWEEN 运算符来获取日期范围。

createdate - 是属性名

FilterExpression: "createdate BETWEEN :date1 and :date2",
    ExpressionAttributeValues: {
         ":date1": "2010-05-05",
         ":date2": "2011-10-04",
    }

Date S (string type). The Date values are stored as ISO-8601 formatted strings.

BETWEEN : Greater than or equal to the first value, and less than or equal to the second value.