Maximo Open Forum

 View Only

 Work Order Tracking Advanced Search Add Ability to Search the MULTIASSETLOCCI table

  • Everything Maximo
  • Work Management
Stevie Holloway's profile image
Stevie Holloway posted 06-13-2022 12:00
Hi,

Was wondering if anyone has determined a way to search for assets in the MULTIASSETLOCCI  section of Work Order Tracking from the Advanced Search dialog?

Thanks

Stevie
Christopher Winston's profile image
Christopher Winston
That should already be built in. If you put something in the Location, the where clause should include '(exists (select 1 from dbo.multiassetlocci where...'

In app designer you should see where the relationship is used: