Question on Data Select CCE Widget in 8.5

jponnu

Hi,

We have two Data Select CCE Widget for Country and City. For Country I have used below DB Query in miscellaneous tab and its working as expected.

<properties>
  <sql>
    <datasource>vignette.jdbc.VgnNonTxDataSource</datasource>
    <select>SELECT ID,CON_NAME FROM EVNT_CONT ORDER BY CON_NAME</select>
  </sql>
</properties>

We need to load the city Based on Country ID which is selected in Country Data Select CCE widget. How to pass the Country ID which is selected in Country Widget to City Widget?

Please help to update below data to achieve.

<properties>
  <sql>
    <datasource>vignette.jdbc.VgnNonTxDataSource</datasource>
    <select>

SELECT EVNT_CITY.ID, EVNT_CITY.NAME FROM EVNT_CITY

join EVNT_CONT on EVNT_CITY.ID= EVNT_CONT.CITYID

where EVNT_CONT.ID = <Country Data Select CCE Widget Value> 

</select>
  </sql>
</properties>

 Thanks,

Jay

Mario_DAnna

Try

 

 

<properties>
  <sql>
    <datasource>vignette.jdbc.VgnNonTxDataSource</datasource>
    <select>

SELECT EVNT_CITY.ID, EVNT_CITY.NAME FROM EVNT_CITY

join EVNT_CONT on EVNT_CITY.ID= EVNT_CONT.CITYID

where EVNT_CONT.ID = ‘${COUNTRY}’

</select>
  </sql>
</properties>

 

Please remark that I have assumed two things:

<![if !supportLists]>1.      <![endif]>The name of the attribute containing the country is COUNTRY

<![if !supportLists]>2.      <![endif]>The PK of the country table is a string. If it is not use
=${COUNTRY}

 

From: eLink Entry: Discussion Group - Web Experience Management [mailto:v7webcontentmanagement@elinkkc.opentext.com]
Sent: giovedì 26 novembre 2015 10:19
To: eLink Recipient
Subject: Question on Data Select CCE Widget in 8.5

 

Question on Data Select CCE Widget in 8.5

Posted by Ponnusamy, Jayaram On 11/26/2015 04:13 AM

 

Hi, We have two Data Select CCE Widget for Country and City. For Country I have used below DB Query in miscellaneous tab and its working as expected. <properties>   <sql>     <datasource>vignette.jdbc.VgnNonTxDataSource</datasource>     <select>SELECT ID,CON_NAME FROM EVNT_CONT ORDER BY CON_NAME</select>   </sql> </properties> We need to load the city Based on Country ID which is selected in Country Data Select CCE widget. How to pass the Country ID which is selected in Country Widget to City Widget? Please help to update below data to achieve. <properties>   <sql>     <datasource>vignette.jdbc.VgnNonTxDataSource</datasource>     <select> SELECT EVNT_CITY.ID, EVNT_CITY.NAME FROM EVNT_CITY join EVNT_CONT on EVNT_CITY.ID= EVNT_CONT.CITYID where EVNT_CONT.ID = <Country Data Select CCE Widget Value>  </select>   </sql> </properties>  Thanks, Jay

---

[To post a comment, use the normal reply function]
Forum:	Discussion Group - Web Experience Management
Content Server:	Knowledge Center