Skip to main content
D
dharsanag39
July 19, 2022
Question

Query the value in nested CDT 1:M

  • July 19, 2022
  • 2 replies
  • 0 views

Hi All

I have a requirement to query a value in nested CDT which is in 1:M relationship

Is it possible ?

2 replies

harshitb6843
harshitb6843
July 19, 2022

Nesting the CDTs inside one another is not recommended, especially when you are mapping them with tables.
But in your case, I am assuming that you have already gone far with this approach so did you try to create a query on the parent CDT and see if it is returning the expected result? 

D
dharsanag39Author
July 19, 2022

IF i query with dot notation, i get this error

Expression evaluation error at function a!queryEntity: Cannot filter by field [partsInformation.partNumber] because it is a complex, multiple, or child of a multiple data type.

Terms & ConditionsAccessibility statement