Fetch dropdown values with dropdown name using jcr query

Avatar

Avatar
Validate 1
Level 2
nitinjl
Level 2

Likes

6 likes

Total Posts

62 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Level 2
nitinjl
Level 2

Likes

6 likes

Total Posts

62 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 1
Give Back 5
View profile
nitinjl
Level 2

10-08-2020

Hi, 

I have a requirement to fetch all the dropdown fields along with associated values from metadata schema in below format

Dropdown Name                     Option text                  Option Value
Citi
                                               New York                     ny

                                                Boston                       boston

Gender 
                                              Male                               M
                                              Female                          F

I am able to get list of available dropdown fields using below query, but facing difficulty in building nested query to get associated text and values. 


SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/conf/global/settings/dam/adminui-extension/metadataschema/sampleschema]) AND resourceType= 'dam/gui/coral/components/admin/schemaforms/formbuilder/formfields/v2/metadataselect'

 

 

nitinjl_0-1596823284845.png

Can you please share your thoughts/suggestion to solve this ?

 

Thanks, 

Nj

 

 

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Give Back
Level 2
RMGJID
Level 2

Likes

11 likes

Total Posts

26 posts

Correct reply

4 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 5
Boost 3
View profile

Avatar
Give Back
Level 2
RMGJID
Level 2

Likes

11 likes

Total Posts

26 posts

Correct reply

4 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 5
Boost 3
View profile
RMGJID
Level 2

12-08-2020

Please post this question in the "Adobe Experience Manager' Community. This is AEP community