node.js - 如何在查询运行时将属性与 dynamodb 表 -> 项目 -> 属性中的小写值进行比较

Question

我想像我们在 mysql 中那样搜索属性中的文本字符串 LOWER(fieldName) = LIKE% strtolower(search_text)% 。我做了一些研究，但没有找到任何解决方案。

{
    "TableName": "DEV_postTbl",
    "ProjectionExpression": "postId, postType, postStatus",
    "ScanIndexForward": false,
    "Limit": 6,
    "KeyConditionExpression": "postStatus =:postStatusPublished",
    "IndexName": "postStatus-createdOn-index",
    "FilterExpression": " (  contains( postTitle, :searchText)  OR  contains(postDescription, :searchText) OR contains(postLocation.addressLine, :searchText) ) ",
    "ExpressionAttributeValues": {
        ":searchText": "hello",
        ":postStatusPublished": "published"
    }
}

这是我的代码..但是这个搜索只搜索“hello”而不是“Hello”，“heLLO”这样

Answer 1

DynamoDB is case sensitive. If your data is case insensitive, one solution is to lower case or upper case the data before storing it in DynamoDB. Then you can get around this by querying for all lower case or all upper case.

示例:

使用小写项目存储 postTitle。

当您搜索时只需小写 :searchTex (str.toLowerCase()) 然后查询。