Hi,
We are using Data Select CCE Widget to displaying data in the Dropdown menu by using below SELECT Query in the CI form.
We have both English and Arabic Translation, How to write query to load the data based on Locale value.
for Example, if Content Language is English then
<properties>
<sql>
<datasource>vignette.jdbc.VgnNonTxDataSource</datasource>
<select>SELECT OPTION_KEY, OPTION_VALUE FROM DROPDOWN_METADATA,DROPDOWNS WHERE DROPDOWN_METADATA.PARENT_KEY=DROPDOWNS.ID AND DROPDOWNS.CONTEXT like '%Departments En%'</select>
</sql>
</properties>
If Content Translation Language is Arabic then
<properties>
<sql>
<datasource>vignette.jdbc.VgnNonTxDataSource</datasource>
<select>SELECT OPTION_KEY, OPTION_VALUE FROM DROPDOWN_METADATA,DROPDOWNS WHERE DROPDOWN_METADATA.PARENT_KEY=DROPDOWNS.ID AND DROPDOWNS.CONTEXT like '%Departments Ar%'</select>
</sql>
</properties>
Appriciate if different approach will help to achieve.
Thanks
Jay
