Is it possible to access related records of a record ("a") in catalog A from catalog X where the PRODUCTID of the record ("a") is provided in X via softlink?
Article ID: KB0087964
Updated On:
| Products | Versions |
|---|---|
| TIBCO Collaborative Information Manager | - |
| Not Applicable | - |
Description
Resolution:
Is it possible to access related records of a record ("a") in catalog A from catalog X where the PRODUCTID of the record ("a") is provided in X via softlink?
Environment:
TIBCO Product name and version: TIBCO Collaborative Information Manager 7.x
Operating System(s): All Operating Systems
Symptoms:
Not applicable
Cause:
Not applicable
Resolution:
There's no straight forward way to achieve this, but you can try the following approach. In the catalogvalidation of Master Catalog A, use the following constraint:
<declare>
<var>CONTAINS_SD</var>
<link type="relationship_record">
<literal>CONTAINS</literal>
</link>
</declare>
<constraint>
<name>Assign_ChildRecordArray_To_SHORTDESC</name>
<description>AssignChildRecordArrayToSHORTDESC</description>
<action>
<assign>
<var>SHORTDESC</var>
<var>CONTAINS_SD</var>
</assign>
</action>
</constraint>
This constraint will assign the array of child records to SHORTDESC attribute of catalog A. Next you can fetch this value in Master catalog X using the following constraint (In X's catalogvalidation):
<declare>
<var>TEXT</var>
<link type="catalog">
<literal>A</literal>
</link>
</declare>
<constraint>
<name>Assign_Child_Records_Of_A_To_SHORTDESC_Of_X</name>
<description>Assign_Child_Records_Of_A_To_SHORTDESC_Of_X</description>
<action>
<assign>
<var>SHORTDESC</var>
<table source="sql">
<literal>TEXT/SHORTDESC</literal>
<where>
<sql>
<eq>
<literal>TEXT/PRODUCTID</literal>
<const type="string">B1</const>
</eq>
</sql>
</where>
</table>
</assign>
</action>
</constraint>
This constraint will assign the SHORTDESC of catalog A to SHORTDESC of catalog X where A.PRODUCTID=B1.
Attachments:
None
References:
None
Is it possible to access related records of a record ("a") in catalog A from catalog X where the PRODUCTID of the record ("a") is provided in X via softlink?
Environment:
TIBCO Product name and version: TIBCO Collaborative Information Manager 7.x
Operating System(s): All Operating Systems
Symptoms:
Not applicable
Cause:
Not applicable
Resolution:
There's no straight forward way to achieve this, but you can try the following approach. In the catalogvalidation of Master Catalog A, use the following constraint:
<declare>
<var>CONTAINS_SD</var>
<link type="relationship_record">
<literal>CONTAINS</literal>
</link>
</declare>
<constraint>
<name>Assign_ChildRecordArray_To_SHORTDESC</name>
<description>AssignChildRecordArrayToSHORTDESC</description>
<action>
<assign>
<var>SHORTDESC</var>
<var>CONTAINS_SD</var>
</assign>
</action>
</constraint>
This constraint will assign the array of child records to SHORTDESC attribute of catalog A. Next you can fetch this value in Master catalog X using the following constraint (In X's catalogvalidation):
<declare>
<var>TEXT</var>
<link type="catalog">
<literal>A</literal>
</link>
</declare>
<constraint>
<name>Assign_Child_Records_Of_A_To_SHORTDESC_Of_X</name>
<description>Assign_Child_Records_Of_A_To_SHORTDESC_Of_X</description>
<action>
<assign>
<var>SHORTDESC</var>
<table source="sql">
<literal>TEXT/SHORTDESC</literal>
<where>
<sql>
<eq>
<literal>TEXT/PRODUCTID</literal>
<const type="string">B1</const>
</eq>
</sql>
</where>
</table>
</assign>
</action>
</constraint>
This constraint will assign the SHORTDESC of catalog A to SHORTDESC of catalog X where A.PRODUCTID=B1.
Attachments:
None
References:
None
Issue/Introduction
Is it possible to access related records of a record ("a") in catalog A from catalog X where the PRODUCTID of the record ("a") is provided in X via softlink?
Feedback
Yes
No
Powered by
