Solved
link betwen reference table and others tables
Hi everyone,
I want to replace the userEnum in my data schema by the reference table. The reference table content all values.
Here'is my the reference table
<element desc="Reference table" hybrid="false" label="Reference table" labelSingular="Reference table"
name="referenceTable">
<key clustered="true" internal="true">
<keyfield xpath="@countryCode"/>
<keyfield xpath="@referenceTableName"/>
<keyfield xpath="@ReferenceColumnName"/>
<keyfield xpath="@value"/>
</key>
<attribute desc="Client Country code" label="Country code"
name="countryCode" type="byte"/>
<attribute desc="Reference table name" label="Reference table name" length="50"
name="referenceTableName" type="string"/>
<attribute desc="Reference column name" label="Reference column name" length="50"
name="ReferenceColumnName" type="string"/>
<attribute desc="value" label="value" length="50" name="value" type="string"/>
<attribute desc="Label" label="Label" name="label" type="string"/>
<sysFilter>
<condition enabledIf="HasNamedRight('rightAllData')=false" expr="[currentOperator/@countryCode]=[@countryCode] and @1682211_deleted=false"/>
</sysFilter>
</element>
</srcSchema>
And create the link with the another table but i'm not how i can use the dstFilterExpr in my link;
Below the link between all data schema with reference table
<element displayAsField="true" label="Reference table" name="referenceTable" target="cus:referenceTable" type="link" noDbIndex="true" noDbIndex="true"
dstFilterExpr="@ReferenceColumnName = 'type'" dstFilterExpr="@referenceTableName = 'reward'">
<join xpath-dst="@countryCode" xpath-src="@countryCode"/>
<join xpath-dst="@value" xpath-src="@sType" />
</element>
The dstFilterExpr="@ReferenceColumnName = 'type'" dstFilterExpr="@referenceTableName = 'reward'" is the value in my reference table.
Someone can help me plz ?
MDIA