Expand my Community achievements bar.

Fetching dropdown fields values using jcr:sql2 query

Avatar

Community Advisor

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

 

 

 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Community Advisor

Please try this query.

 

SELECT * FROM [nt:base]
WHERE ISDESCENDANTNODE([/conf/global/settings/dam/adminui-extension/metadataschema])
AND [jcr:primaryType] = 'nt:unstructured'
AND [sling:resourceType] = 'dam/gui/components/admin/schemafield'