Maximo Open Forum

 View Only

 Relationship Invalid Binding

  • Customizations
Keith Henderson's profile image
Keith Henderson posted 03-06-2024 10:30

Good Morning all,

I'm having some issue with creating a relationship in the SR table with the RELATEDRECORD table. The goal is to display the work order number on the SR application. When users create the SR, work control converts the SR into a work order which creates a RELATEDRECORD record. The RELATEDRECORD>RELATEDRECKEY field contains the SR number, and RELATEDRECORD>RECORDKEY contains the work order value, which is what I want to display..

When I try to use the relationship REL_WO.RECORDKEY on the SR application I get the Invalid Bindings error. Seems simple, What am I missing ? Thanks

 

Travis Herron's profile image
Travis Herron posted 03-07-2024 10:53

There's an OOTB relationship from TICKET to RELATEDRECORD with the ID of RELATEDWO.  The WHERE clause it uses is:

recordkey=:ticketid and class =:class and relatedrecclass in (select value from synonymdomain where domainid ='WOCLASS' and maxvalue in ('CHANGE', 'RELEASE','ACTIVITY', 'WORKORDER'))

>>When I try to use the relationship REL_WO.RECORDKEY on the SR application 

It should be REL_WO.RELATEDRECKEY

Related Content