How to Scan multiple attributes in DynamoDB with java?

Question

I have this scan expression which returns a list of blogs matching the query (By title). How can I scan multiple attributes in the table and also ignore the case of the query?

      public List<BlogDetailsEntity> searchBlogs(String query) {
    try {
      DynamoDBScanExpression scanExpression = new DynamoDBScanExpression();
      scanExpression.addFilterCondition("title", new Condition()
              .withComparisonOperator(ComparisonOperator.CONTAINS)
              .withAttributeValueList(new AttributeValue().withS(query)));
     scanExpression.addFilterCondition("shortDescription", new Condition()
              .withComparisonOperator(ComparisonOperator.CONTAINS)
              .withAttributeValueList(new AttributeValue().withS(query)));
      return dynamoDBMapper.scan(BlogDetailsEntity.class, scanExpression);
    } catch (Exception ex) {
      log.error("failed to get blogs > " + query);
    }
    return null;
  }

If you need general purpose search, you should consider an actual search engine, such as Elasticsearch. — jarmod, Mar 14 '21 at 22:54

score 0 · Answer 1 · answered Mar 14 '21 at 20:18

0

Multiple attributes: you can have multiple filter conditions on a single scan.
Ignore casing: As of 2017, this was not available. The suggested work-around is to add a field to the objects with the value in lowercase and filter on that.

answered Mar 14 '21 at 20:18

sigma1510

1,165
1
11
26

I added another filter condition but it only filters based on the first condition (See updated code) – Clancinio Mar 15 '21 at 18:55
Interesting. Can you show an example of your DynamoDB objects? – sigma1510 Mar 15 '21 at 21:00

How to Scan multiple attributes in DynamoDB with java?

1 Answers1