IN condition in a query to Dynamo DB

Question

Hello, how to do instead of Id = :first OR Id = :second condition with the use of IN ?

 public List<Data> getByIds(List<Long> ids) { Table table = dynamoDB.getTable(getTableName()); ScanSpec scanSpec = new ScanSpec() .withFilterExpression("Id = :first OR Id = :second") .withValueMap(new ValueMap() .withNumber(":first", ids.get(0)) .withNumber(":second", ids.get(1)) ); ItemCollection<ScanOutcome> scanOutcome = table.scan(scanSpec); return convertItemToData(scanOutcome.iterator()); }

Bohdan korinnyi bohdan korinnyi 552 2 silver marks 14 bronze marks · Accepted Answer · 2017-01-10T17:10:55

As an option, you can do so

 { //... Condition condition = new Condition() .withComparisonOperator(ComparisonOperator.IN.toString()) .withAttributeValueList(buildAttributeValueList(userId)); ScanRequest scanRequest = new ScanRequest() .withTableName(getTableName()) .withScanFilter(ImmutableMap.of("userId", condition)); ScanResult scanResult = amazonDynamoDBClient.scan(scanRequest);

IN condition in a query to Dynamo DB

1 answer 1

More articles: