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
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 ?