No, you can't have a single input tied to two attributes. I'm not entirely sure what you mean by conditional expressions in this context or how you would expect conditional UI to help but list tab/advanced search conditional UI is not really a thing as it can't evaluate the rules.
The only way I could see something like this being possible is to build a custom view that has a single column for your two values. You mentioned model and catalog on items for example. So you could create a view that looks like this (replacing emxcatalog & emxmodel with the actual attribute names in your environment):
SELECT itemnum,itemsetid,emxcatalog as [modelcatalog] FROM item WHERE emxcatalog is not null
UNION
SELECT itemnum,itemsetid,emxmodel as [modelcatalog] FROM item WHERE emxmodel is not null
And then build a relationship from ITEM (on itemnum=:itemnum and itemsetid=:itemsetid) to this view and display the attribute as RELATIONNAME.modelcatalog. Maximo will build an exists SQL query that looks at this view to try and see if the item exists in this custom view.
This would in theory work, but has the negative issue that you're no longer on the ITEM object for example. That means searching might be slower than if you were able to build the SQL on the ITEM object itself.
------------------------------
Steven Shull
Projetech Inc.
------------------------------
Original Message:
Sent: 04-08-2021 10:47
From: Pradeep Rout
Subject: How to use two attributes in a single search field in Maximo advance search
Thanks Steve. Yes the your understanding is correct.
The requirement is for example user wants to use the Asset column field from teh advance search option and while entering value it should enter the value as assetnum='1000' or location='200'.
Can we bind two attributes to a single columns or is it possible to use a conditional expression on properties tab to trigger the search action with adding OR clause to the existing binding.
------------------------------
Pradeep Rout
TCSL
Original Message:
Sent: 04-08-2021 10:36
From: Steven Shull
Subject: How to use two attributes in a single search field in Maximo advance search
EDIT: Sorry, I had started a response and didn't refresh where you clarified that you're trying to do what I thought. Leaving my full response.
Can you clarify your intended scenario? I'm assuming you're looking for a user to provide a value in a generic field that generates a SQL statement like "(assetnum='VALUE' or location='VALUE')" where they only provide VALUE in your single field. Assuming that's the case I don't believe that's possible. Maximo requires persistent attributes which have to be tied to a single column.
If you're looking to provide two values for a single attribute (IE a date range for example), that is possible but I don't think that's what you're looking to do.
------------------------------
Steven Shull
Projetech Inc.
Original Message:
Sent: 04-08-2021 09:46
From: Pradeep Rout
Subject: How to use two attributes in a single search field in Maximo advance search
Dear All,
Is it possible to search a field with multiple attributes in Maximo advance search?
#Customizations
------------------------------
Pradeep Rout
TCSL
------------------------------