Fetch dropdown values with dropdown name using jcr query | Community
Skip to main content
Nitin_laad
Community Advisor
Community Advisor
August 10, 2020

Fetch dropdown values with dropdown name using jcr query

  • August 10, 2020
  • 1 reply
  • 820 views

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'

 

 

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

 

Thanks, 

Nj

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Level 3
August 12, 2020

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