How to query nested property on dynamo DB

Question

I have data structure in the following way. I want to retrieve all records which are having subjectName PHYSICS PAPER-I and marksGained 40.

Is it possible to query to such records? are there any other libraries we can use on to achieve this?

{
  "CID": "A1",
  "COL_ID": "HARISHFYSX",
  "district": "ADILABAD",
  "grandresult": "C",
  "grandtotal": "232",
  "stdntname": "JAMES",
  "subjects": [
    {
      "marksGained": "38",
      "outcome": "P",
      "passType": "*",
      "subjectName": "ENGLISH PAPER -I"
    },
    {
      "marksGained": "56",
      "outcome": "P",
      "passType": "*",
      "subjectName": "TELUGU PAPER-I"
    },
    {
      "marksGained": "42",
      "outcome": "P",
      "passType": "*",
      "subjectName": "BOTANY PAPER-I"
    },
    {
      "marksGained": "22",
      "outcome": "P",
      "passType": "*",
      "subjectName": "ZOOLOGY PAPER-I"
    },
    {
      "marksGained": "40",
      "outcome": "P",
      "passType": "*",
      "subjectName": "PHYSICS PAPER-I"
    },
    {
      "marksGained": "34",
      "outcome": "P",
      "passType": null,
      "subjectName": "CHEMISTRY PAPER-I"
    }
  ],
  "ticket": "1534343434",
  "UID": "A1_1534343434"
}

Kannaiyan · Accepted Answer · 2022-06-28 16:57:43Z

3

Updated:

AWS Started supporting queries for nested object with expressions.

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Expressions.Attributes.html

Outdated: Keeping it for reference.

You cannot query on a nested object, it will be a scan. Following forum discussed in detail,

https://forums.aws.amazon.com/thread.jspa?threadID=164470

Hope it helps.

edited Jun 28, 2022 at 16:57

answered Sep 20, 2017 at 2:18

Kannaiyan

13.1k4 gold badges52 silver badges91 bronze badges

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

1 Comment

mikemaccana Over a year ago

This answers the letter of the question - no it's not possible using the 'query' - but not the spirit of the question - how do to find items whose nested keys match a particular value. Also the link is dead.

Collectives™ on Stack Overflow

How to query nested property on dynamo DB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related