Searching a DynamoDB String Set Attribute by Array of Strings

Question

I am struggling to find the correct syntax to search a String Set/List target attribute (tags) by an array of strings. The idea would be that if the SS attribute contains all of the passed strings, it passes the filter. The passed strings do not need to match all of the strings within the target attribute. The more strings you pass, the more accurate your results.

// Compile tags into a list
let tagSqlValues = {};
let tagSqlStatement = query.tags.map((tag: string, index: number) => {
  let tagParam = `:tag${index}`;
  tagSqlValues[tagParam] = tag;
  return `${tagParam} in tags`;
}).join(" and ");

// Console Logs
// tagSqlStatement = :tag0 in tags and :tag1 in tags (also tried tags contains :tag0 and tags contains :tag1)
// tagSqlValues = {":tag0":"Modern",":tag1":" Spring"}

let params = {
    TableName: "Art",
    FilterExpression: tagSqlStatement,
    ExpressionAttributeValues: tagSqlValues,
};
let results = await this.DDB_CLIENT.scan(params).promise();

// Console Logs
// "Invalid FilterExpression: Syntax error; token: \"tags\", near: \"in tags and\""
// "Invalid FilterExpression: Syntax error; token: \"contains\", near: \"tags contains :tag0\""

I've tried several variations with IN and CONTAINS without luck. Is this possible with DynamoDB?

Danielle · Accepted Answer · 2021-06-25 20:25:52Z

1

It looks like my CONTAINS syntax was wrong. I did a little digging and found this answer by Zanon. With a minor modification to include the and join, it seems like the filter is working as expected!

// Compile tags into a list
let tagSqlValues = {};
let tagSqlStatement = query.tags.map((tag: string, index: number) => {
  let tagParam = `:tag${index}`;
  tagSqlValues[tagParam] = tag;
  return `contains(tags, ${tagParam})`;
}).join(" and ");

edited Jun 25, 2021 at 20:25

answered Jun 19, 2021 at 21:27

Danielle

4925 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Searching a DynamoDB String Set Attribute by Array of Strings

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related