Query Entity: retrieving certain field of nested collection

yaminw over 7 years ago

Suppose I have a CDT x, and x has a nested CTD y, I want to have a query entity for retrieving CDT x data, and I need only a few fields in CTD y instead of all fields in CDT y, how can I achieve this within query entity against CDT x ? Thanks

Discussion posts and replies are publicly visible

Parents

0 narasimhaadityac
A Score Level 2
over 7 years ago

Hi Yamin, we can write the query entity and provide the queryColumn with x.y attribute like below here dept is the element name in XSD X which refers to nested CDT Y. deptName is the element of CDT - Y.

a!queryColumn(
field: "dept.deptName"
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 narasimhaadityac
A Score Level 2
over 7 years ago

Hi Yamin, we can write the query entity and provide the queryColumn with x.y attribute like below here dept is the element name in XSD X which refers to nested CDT Y. deptName is the element of CDT - Y.

a!queryColumn(
field: "dept.deptName"
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data