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:

&ltdeclare>
&ltvar&gtCONTAINS_SD</var>
&ltlink type="relationship_record">
&ltliteral&gtCONTAINS</literal>
</link>
</declare>

&ltconstraint>
    &ltname&gtAssign_ChildRecordArray_To_SHORTDESC</name>
    &ltdescription&gtAssignChildRecordArrayToSHORTDESC</description>
    &ltaction>
      &ltassign>
    &ltvar&gtSHORTDESC</var>
    &ltvar&gtCONTAINS_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):

&ltdeclare>
&ltvar&gtTEXT</var>
&ltlink type="catalog">
&ltliteral&gtA</literal>
</link>
</declare>

&ltconstraint>
   &ltname&gtAssign_Child_Records_Of_A_To_SHORTDESC_Of_X</name>
   &ltdescription&gtAssign_Child_Records_Of_A_To_SHORTDESC_Of_X</description>
   &ltaction>
     &ltassign>
       &ltvar&gtSHORTDESC</var>
       &lttable source="sql">
          &ltliteral&gtTEXT/SHORTDESC</literal>
          &ltwhere>
          &ltsql>
          &lteq>
          &ltliteral&gtTEXT/PRODUCTID</literal>
          &ltconst type="string"&gtB1</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