Hi,
I am struggling with trimming out my values from a contentselect function. I want to get a list certain region values e.g (Global or Local) region values. My contentselect for Global is failing to give me values back, it look as follows.
<CMS_FUNCTION name="contentSelect" resultname="list_global">
<CMS_PARAM name="schema" value="SasolDotComSchema" />
<CMS_PARAM name="region" value="Global" />
<QUERY entityType="table_name">
<FILTERPARAM parameter="region" datatype="java.lang.String" value="Global"/>
<AND>
<EQ attribute="region" datatype="java.lang.String" value="Global"/>
</AND>
</QUERY>
</CMS_FUNCTION>
For more further information this is how my region part on the form looks like and I want to pull out data on either Global or Local but for now if I can get the Global information from a contentSelect, I can get the Local one:
<CMS_INPUT_CHECKBOX
name="tt_banner_region"
allowEmpty="no"
gridHeight="1"
gridWidth="2"
hFill="yes"
preset="copy"
useLanguages="no">
<ENTRIES>
<ENTRY value="Global">
<LANGINFOS>
<LANGINFO lang="*" label="Global"/>
</LANGINFOS>
</ENTRY>
<ENTRY value="South Africa">
<LANGINFOS>
<LANGINFO lang="*" label="Local"/>
</LANGINFOS>
</ENTRY>
</ENTRIES>
<LANGINFOS>
<LANGINFO lang="*" label="Region" description="Region"/>
</LANGINFOS>
</CMS_INPUT_CHECKBOX>
Regards,
Jack T. Mmelesi
