2

can dynamodb query data for list contains object that match some attribute?

my data format:

  [{
     pk,
     sk,
     gsi1pk: 'USER',
     gsi1sk,
     list:[
         {
           id,
           type, // admin, moderator, user
           name,
         }
     ]
  }]

can we do something like this to find data with list contains type is 'admin'?

   await Ddb.query( {
    IndexName: 'GSI1',
    KeyConditionExpression: 'gsi1pk = :gsi1pk',
    FilterExpression: 'contains(list, :list)'
    ExpressionAttributeValues: {
      ':gsi1pk': 'USER',
      ':list': { type: 'admin'}
    },
  });

this does not work now :(

0 Answers0