Maximo Open Forum

Hi , I have a requirement to display only active asset records when user search any asset using unit number by default.  If no active asset records are present we have to display moved status asset records followed by decommissioned records. Kindly let me know the query I can write for this .Also please let me know where can we write this queries to customize list tab display. 

Hi Aayushi,

I want to pick on the words 'search any asset using unit number'.   This means that the user us actively looking for the asset.  So it's not about the order of the list display, rather providing the correct information to the user.

Using the screenshot, you can see that the status is not provided.  So, it's not unusual to extend this lookup to add the extra information.

This change to 30 seconds to do.

Hi , I have a requirement to display only active asset records when user search any asset using unit number by default.  If no active asset records are present we have to display moved status asset records followed by decommissioned records. Kindly let me know the query I can write for this .Also please let me know where can we write this queries to customize list tab display. 

Hi,

Thanks for the reply. But my bad it's not any but when user tries to search an asset record using find unit number lookup , list view display all the status records for it which confuses the user. So they want to see only active asset records for an unit number,  if not present then they want to see moved followed by decommissioned status record. So how do we customize query to display in list view tab ?

Hi Aayushi,

I want to pick on the words 'search any asset using unit number'.   This means that the user us actively looking for the asset.  So it's not about the order of the list display, rather providing the correct information to the user.

Using the screenshot, you can see that the status is not provided.  So, it's not unusual to extend this lookup to add the extra information.

This change to 30 seconds to do.

Hi , I have a requirement to display only active asset records when user search any asset using unit number by default.  If no active asset records are present we have to display moved status asset records followed by decommissioned records. Kindly let me know the query I can write for this .Also please let me know where can we write this queries to customize list tab display. 

Hi , I have a requirement to display only active asset records when user search an asset using unit number by default.  If no active asset records are present for that unit number we have to display moved status asset records followed by decommissioned records for same unit number searched. Kindly let me know the query I can write for this .Also please let me know where can we write this queries to customize list tab display. 

#Assets

------------------------------
Aayushi Beohar
Tcs
------------------------------