How to have distinct keyword in the rulebase construct when using table source="sql" or table source="datasource" to select distinct values from the source?
Article ID: KB0091455
Updated On:
| Products | Versions |
|---|---|
| TIBCO Collaborative Information Manager | - |
| Not Applicable | - |
Description
Resolution:
Use the distinct keyword as <table source="sql" distinct="true"> as follows:
<action>
<select order="1" novalue="default" distinct="true">
<table source="sql">
<literal>Category_Lookup/CategoryLevel2</literal>
<where>
<sql>
<eq>
<literal>Category_Lookup/CategoryLevel1</literal>
<var>ProductCategory1</var>
</eq>
</sql>
</where>
</table>
</select>
</action>
Use the distinct keyword as <table source="sql" distinct="true"> as follows:
<action>
<select order="1" novalue="default" distinct="true">
<table source="sql">
<literal>Category_Lookup/CategoryLevel2</literal>
<where>
<sql>
<eq>
<literal>Category_Lookup/CategoryLevel1</literal>
<var>ProductCategory1</var>
</eq>
</sql>
</where>
</table>
</select>
</action>
Issue/Introduction
How to have distinct keyword in the rulebase construct when using table source="sql" or table source="datasource" to select distinct values from the source?
Feedback
Yes
No
Powered by
