Maximo Open Forum

 View Only

 Set Whereclause or Condition on Asset/Location Open Drilldown Dialog

  • Administration
  • Customizations
  • Everything Maximo
  • Security
Matt F's profile image
Matt F posted 07-28-2023 13:00

Hi Folks,

Working in 7.6.1.2, looking for a configurable way to apply a Whereclause or Condition to the Location/Asset Open Drilldown dialog to show only a specific System and hide others. Is this possible?

I tried applying it to the listbox and dialog in the LIBRARY.xml but it did not take effect. 

Thanks in advance!


Cheers,
Matt

Invading Moss's profile image
Invading Moss

The data in the systems is being populated from a table domain which refers to the LOCSYSTEM table. You can create a QUALIFIED global data restriction on the LOCSYSTEM object and the application you want the restriction to occur. 

The condition can be something like this 

:systemid != 'SYSTEMID you want hidden'

I was able to try this it out in my system and it seems to work for now.  Again whenever using global data restriction try to limit the same to a specific application

Matt F's profile image
Matt F

@Invading Moss, thank you for the reply and solution! Unfortunately I can't respond to your answer as I chose this as a Question and not Discussion. 

This does work for me too after my initial testing, but I need to apply it specifically to a single field. I think this will require me to attempt to duplicate the Drilldown dialog as it's shared amongst multiple fields (ie. LIBRARY.XML). Essentially, I want it to display PRIMARY system Locations for the ASSET.LOCATION field Open Drilldown selection and SECONDARY system Locations for the ASSET.FBR  field Open drilldown selection. 

I hope that makes sense. I'll try a few things while waiting for a response.