Maximo Open Forum

 View Only

 Invalid Binding when adding "SERIALNUM" to WOTRACK Table Column

  • Administration
  • Customizations
  • Everything Maximo
  • Functional
  • Work Management
Danny Richardson's profile image
Danny Richardson posted 07-17-2023 11:10
Hello all,  I've added a Table Column to the WOTRACK application but am getting this error when adding the attribute "SERIALNUM".  If I add the attribute "ASSETNUM" it works fine.  Any help would be greatly appreciated.
Thank you 
Christopher Winston's profile image
Christopher Winston

You need to leverage the 'relationship' between the primary object for that application (WORKORDER) and its relationship to the child object you are targeting (ASSET). That means a trip to Database Configuration to capture the correct 'relationship' to use - ASSET.SERIALNUM

Remember to utilize the 'relationship' identified, which will not always be the same as the object name. 

Danny Richardson's profile image
Danny Richardson

Thank you @Christopher Winston.  If you have a link to a step-by-step on IBM's website I would appreciate it because I wasn't able to figure out how to add the relationship correctly that way.  It actually ended up working by writing the name you suggested "ASSET.SERIALNUM" in the Attribute field. :)  Not sure why I did not have to create the relationship that way but the name you suggested did fix it.  Thank you.

 

Christopher Winston's profile image
Christopher Winston

I would suggest you look at the Application Configuration Best Practices page and I have included the most relevant section below for easy reference, but it is in public domain, so you will not need to log in:

Add existing fields to an application

You may want to show data to your users that is not currently displayed in the application.  To verify the field exists, access Database Configuration application within Maximo.  Locate the object, and confirm that the data you want to display is fy available as an attribute of this object. 

If this is the case, adding this attribute to the application user interface is a simple drag and drop operation from Maximo's Application Designer.  

If the data that you wish to show is available on a field on a related object and the parent and child objects are related in a one-to-one relationship, you can follow a similar approach add the related field to the user interface setting an attributename with this syntax:

RELATIONSHIPNAME.ATTRIBUTENAME.

Best Practices:  It is not recommended to show related fields in the list tab of an application because of performance impacts.  The additional database query can cause significant performance degradation.

You can modify the advanced search dialog for your application to allow searching on this related information using the same related field syntax.  When searching on these related fields, you can search on one-to-many relationships. For instance, you can find any work order with a child task that’s assigned to you.

Christopher Winston's profile image
Christopher Winston

Just in case it is a question, the answer is the same in Application Suite: