Maximo Open Forum

 View Only

 Dynamic Datasrc / Relationship on Table Control

Jump to  Best Answer
  • Administration
Khalid Tarek's profile image
Khalid Tarek posted 01-05-2025 02:38

Hello,

I would like to inquire on the ability of creating table controls in Maximo (7.6.1.4+) that could switch between using different data sources or relationships.

To explain my use case in detail:

I am attempting to show the user the interested parties (CCICIINTERESTEDPARTY) relating to the selected CI on a ticket in the ticket application. The catch here, is I want to show only a specific type of interested parties if the CI is or a certain classification, and another type of interested parties if the CI is of another classification.

I did think of creating a table for each case and using a signature option with a condition on it, but does not seem like a good solution for several reasons. I have tried several conditional UI properties so far on my table including:

  • relation
  • relationship
  • datasrc
  • datasrcid
  • usedatasrc
  • viewdatasrc
  • nodedatasrc

But none of these properties had any effect on my table. 

Could anyone have tips on reaching my goal here? Could I be looking at this situation from a wrong perspective? How about using a script to achieve this functionality? 

Jade Warren's profile image
Jade Warren posted 01-06-2025 08:38  Best Answer

Hello Khalid!  This may be as simple as crafting your relationship SQL statement...something like

(:classstructureid IN ('FIRST', 'SET', 'OF', 'VALUES', 'HERE') AND cciciinterestedparty.type = 'TYPE_1') OR (:classstructureid IN ('NEXT', 'SET', 'OF', 'VALUES', 'HERE') AND cciciinterestedparty.type = 'TYPE_2')

Related Content