Define a relationship to a secondary table

[SEDatSAS]

In CSM/FSM Configurable Workspace we have a UI action for a case that creates a request (REQ). The request may have one or more requested items (RITMs) associated with it.  When when the request is created, the case is the parent, so it is easy to display a related list of requests (REQ). The requirement is to display a related list of requested items (RITMs). 

It looks like I need to go into System Definition -> Relationships and define a relationship to the sn_customerservice_case table. How do I query from the sc_req_item table when there is no direct relationship?

Thanks.

[swathisarang98]

Hi @SEDatSAS ,

Yes if you want to have RITM as a related list you can create a relationship between sn_customerservice_case table and RITM 

Here current belongs to Queries from Table , so in RITM table there should be reference record which is capturing sn_customerservice_case record number (reference field (PARENT NUMBER))

Parent is sn_customerservice_case table record so we have to query something like below

current.addQuery('u_cutomerservice_case.number', parent.number);

So Related list will be created for 'Applies to table' which is sn_customerservice_case .

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[swathisarang98]

@SEDatSAS i forgot to mention so req will have the case number (parent) so through BR update the RITM custom field with parent field number then the above mentioned will work.

If you require more info please let me know 

Regards,

Swathi