Maximo Integration

Expand all | Collapse all

Possible to Filter Lookup based on another field's value in the Advanced Search Dialog Box using Automation Script?

  • 1.  Possible to Filter Lookup based on another field's value in the Advanced Search Dialog Box using Automation Script?

    Posted Tue August 24, 2021 06:07 PM
    With an automation script in the Advanced Search dialog box, is it possible to filter a field's lookup list based on the value of another field on the screen?  In the advanced search dialog box, say a user enters "SITE1" for the SITEID, then they click on the Location lookup list. Is it possible to only show the locations for SITE1?  Since it's a zombie MBO the traditional TABLE domain doesn't work.

    ------------------------------
    H Alexander
    ------------------------------


  • 2.  RE: Possible to Filter Lookup based on another field's value in the Advanced Search Dialog Box using Automation Script?

    Posted Wed August 25, 2021 08:20 AM
    I'm going to start with a caveat that unless you're dealing with a custom field, I probably would never do this. In your case since you're trying to filter location I wouldn't do this. That being said, I came up with a solution that would work if you use the Retrieve List launch point on the attribute (scroll down below where I said it wasn't possible :)). 

    https://community.ibm.com/community/user/iot/communities/community-home/digestviewer/viewthread?GroupId=727&MessageKey=78682d96-daec-47a9-b757-5c2cf7d49bca&CommunityKey=3d7261ae-48f7-481d-b675-a40eb407e0fd&tab=digestviewer


    ------------------------------
    Steven Shull
    ------------------------------



  • 3.  RE: Possible to Filter Lookup based on another field's value in the Advanced Search Dialog Box using Automation Script?

    Posted Wed August 25, 2021 03:15 PM
    It was on a custom field, so we are good.  That code worked perfectly.  Thanks so much, Steven!

    ------------------------------
    Hollie Alexander
    ------------------------------