使用带有数字数组变量的IN运算符的Dynamo DB过滤器表达式 [英] Dynamo DB filter expression using IN operator with numeric array variable

问题描述

我正在尝试使用以下有效负载执行查询

I am trying to execute a query with the following payload

payload = {
        TableName : "fleet_list",
        IndexName : "vehicle_type-department-index",
        KeyConditionExpression : "vehicle_type = :v",
        FilterExpression : "(id IN (:list))",
        ExpressionAttributeValues : {
            ":v" : "Car",
            ":list" : [1947, 4397].join()
        }
    }

但是查询不起作用.但是如果:list:1947，它确实可以工作.任何帮助将不胜感激

However the query does not work. it does work however if :list : 1947 . Any help will be appreciated

推荐答案

尝试以下操作:

• 将 FilterExpression:"{id IN(:list))"，更改为 FilterExpression:"{id IN(:id1，:id2))"，./li>
• 将:list":[1947，4397] .join()更改为:id1":1947，:id2":4397 .

• Change FilterExpression : "(id IN (:list))", to FilterExpression : "(id IN (:id1, :id2))",.
• Change ":list" : [1947, 4397].join() to ":id1": 1947, ":id2": 4397.

这篇关于使用带有数字数组变量的IN运算符的Dynamo DB过滤器表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！