Maximo Open Forum

Hello all,

Is there a way to add a Search Field to search for the "REMEDY" from Failure Reporting on the Work Order?  

In Summary:

• How to add a field to the Advanced Search box in Work Order Tracking using Application Designer?

Is there an article or YouTube video you could recommend for me to learn these steps?

Thank you in advance for any advice to get me pointed in the right direction.

Danny,

You can edit the More Search Fields dialog in Application Designer in Maximo.

1. Navigate to Application Designer and select the Application to edit (e.g. WOTRACK)
2. From the toolbar, select the Edit Dialogs option
3. Look for the "searchmore" dialog in the ensuing window and click on it (you might have to page through the list of dialogs to find it).
4. From there, the More Search Fields dialog should be editable in the same manner that the regular fields in the application are editable.

One thing to note though is that your fields in the More Search Fields dialog should have an Input Mode of "query". Normally this is set at a higher level (i.e. the dialog itself) and cascades down, meaning that you likely won't have to do anything. But something to look out for if it's not behaving properly.

For the REMEDY field itself, you'll likely need to join to the FAILUREREPORT table via a relationship. You might need to create a custom relationship from WORKORDER -> FAILUREREPORT to achieve this (something like wonum = :wonum and siteid=:siteid and type='REMEDY').

Hope this helps,

------------------------------
Alex Walter
A3J Group, LLC

Original Message:
Sent: 01-05-2024 16:17
From: Danny Richardson
Subject: How to add Search Field to Advanced Search in Work Order Tracking

Hello all,

Is there a way to add a Search Field to search for the "REMEDY" from Failure Reporting on the Work Order?  

In Summary:

• How to add a field to the Advanced Search box in Work Order Tracking using Application Designer?

Is there an article or YouTube video you could recommend for me to learn these steps?

Thank you in advance for any advice to get me pointed in the right direction.

Alex, 

I'm attempting to do something very similar to Danny. I need to add the "status date" and "changed by" attributes to the more search fields dialog box within WOTRACK. I have followed your instructions above, and was able to successfully add the "status date" field with date lookups. I am having trouble adding the "changed by" search field. 

When I add it to the dialog box, everything seems to be set up correctly (using the person lookup) but when I save and try to use it within the application. I get a menu full of invalid bindings instead of being able to look up a user in the person lookup. Could you have some insight on why this might be happening?

Thanks!

Danny,

You can edit the More Search Fields dialog in Application Designer in Maximo.

1. Navigate to Application Designer and select the Application to edit (e.g. WOTRACK)
2. From the toolbar, select the Edit Dialogs option
3. Look for the "searchmore" dialog in the ensuing window and click on it (you might have to page through the list of dialogs to find it).
4. From there, the More Search Fields dialog should be editable in the same manner that the regular fields in the application are editable.

One thing to note though is that your fields in the More Search Fields dialog should have an Input Mode of "query". Normally this is set at a higher level (i.e. the dialog itself) and cascades down, meaning that you likely won't have to do anything. But something to look out for if it's not behaving properly.

For the REMEDY field itself, you'll likely need to join to the FAILUREREPORT table via a relationship. You might need to create a custom relationship from WORKORDER -> FAILUREREPORT to achieve this (something like wonum = :wonum and siteid=:siteid and type='REMEDY').

Hope this helps,

------------------------------
Alex Walter
A3J Group, LLC

Original Message:
Sent: 01-05-2024 16:17
From: Danny Richardson
Subject: How to add Search Field to Advanced Search in Work Order Tracking

Hello all,

Is there a way to add a Search Field to search for the "REMEDY" from Failure Reporting on the Work Order?  

In Summary:

• How to add a field to the Advanced Search box in Work Order Tracking using Application Designer?

Is there an article or YouTube video you could recommend for me to learn these steps?

Thank you in advance for any advice to get me pointed in the right direction.

Brett,

Unfortunately the CHANGEBY field itself makes this complicated. Sorry for the technical detail, but here are the reasons:

1. First, the values in the CHANGEBY field are not bound to values in the PERSON or MAXUSER table in the normal way. To make a lookup work against a field, either a field class or a domain need to be associated with the field in the Database Configuration application. The WORKORDER.CHANGEBY field is missing both data points by default:
   
2. I would not recommend adding a class or domain to the attribute either. Maximo by default is copying the MAXUSER.LOGINID value into that field, and not a PERSONID or USERID. Each of those three values could be different for the same user.

So... I would unfortunately recommend that you not have a lookup on the Work Order Change By field. It's possible, but would require some customization that is likely more work than the value provided by the lookup.

Hope this helps,

Alex, 

I'm attempting to do something very similar to Danny. I need to add the "status date" and "changed by" attributes to the more search fields dialog box within WOTRACK. I have followed your instructions above, and was able to successfully add the "status date" field with date lookups. I am having trouble adding the "changed by" search field. 

When I add it to the dialog box, everything seems to be set up correctly (using the person lookup) but when I save and try to use it within the application. I get a menu full of invalid bindings instead of being able to look up a user in the person lookup. Could you have some insight on why this might be happening?

Thanks!

Danny,

You can edit the More Search Fields dialog in Application Designer in Maximo.

1. Navigate to Application Designer and select the Application to edit (e.g. WOTRACK)
2. From the toolbar, select the Edit Dialogs option
3. Look for the "searchmore" dialog in the ensuing window and click on it (you might have to page through the list of dialogs to find it).
4. From there, the More Search Fields dialog should be editable in the same manner that the regular fields in the application are editable.

One thing to note though is that your fields in the More Search Fields dialog should have an Input Mode of "query". Normally this is set at a higher level (i.e. the dialog itself) and cascades down, meaning that you likely won't have to do anything. But something to look out for if it's not behaving properly.

For the REMEDY field itself, you'll likely need to join to the FAILUREREPORT table via a relationship. You might need to create a custom relationship from WORKORDER -> FAILUREREPORT to achieve this (something like wonum = :wonum and siteid=:siteid and type='REMEDY').

Hope this helps,

------------------------------
Alex Walter
A3J Group, LLC

Original Message:
Sent: 01-05-2024 16:17
From: Danny Richardson
Subject: How to add Search Field to Advanced Search in Work Order Tracking

Hello all,

Is there a way to add a Search Field to search for the "REMEDY" from Failure Reporting on the Work Order?  

In Summary:

• How to add a field to the Advanced Search box in Work Order Tracking using Application Designer?

Is there an article or YouTube video you could recommend for me to learn these steps?

Thank you in advance for any advice to get me pointed in the right direction.

Appreciate the response as well as the technical info on why it isn't working. 

This is not something we NEED in place, so I may just scrap the idea as it sounds like it is going to be more of a hassle than its worth. 

Thanks again!

Brett,

Unfortunately the CHANGEBY field itself makes this complicated. Sorry for the technical detail, but here are the reasons:

1. First, the values in the CHANGEBY field are not bound to values in the PERSON or MAXUSER table in the normal way. To make a lookup work against a field, either a field class or a domain need to be associated with the field in the Database Configuration application. The WORKORDER.CHANGEBY field is missing both data points by default:
   
2. I would not recommend adding a class or domain to the attribute either. Maximo by default is copying the MAXUSER.LOGINID value into that field, and not a PERSONID or USERID. Each of those three values could be different for the same user.

So... I would unfortunately recommend that you not have a lookup on the Work Order Change By field. It's possible, but would require some customization that is likely more work than the value provided by the lookup.

Hope this helps,

Alex, 

I'm attempting to do something very similar to Danny. I need to add the "status date" and "changed by" attributes to the more search fields dialog box within WOTRACK. I have followed your instructions above, and was able to successfully add the "status date" field with date lookups. I am having trouble adding the "changed by" search field. 

When I add it to the dialog box, everything seems to be set up correctly (using the person lookup) but when I save and try to use it within the application. I get a menu full of invalid bindings instead of being able to look up a user in the person lookup. Could you have some insight on why this might be happening?

Thanks!

Danny,

You can edit the More Search Fields dialog in Application Designer in Maximo.

1. Navigate to Application Designer and select the Application to edit (e.g. WOTRACK)
2. From the toolbar, select the Edit Dialogs option
3. Look for the "searchmore" dialog in the ensuing window and click on it (you might have to page through the list of dialogs to find it).
4. From there, the More Search Fields dialog should be editable in the same manner that the regular fields in the application are editable.

One thing to note though is that your fields in the More Search Fields dialog should have an Input Mode of "query". Normally this is set at a higher level (i.e. the dialog itself) and cascades down, meaning that you likely won't have to do anything. But something to look out for if it's not behaving properly.

For the REMEDY field itself, you'll likely need to join to the FAILUREREPORT table via a relationship. You might need to create a custom relationship from WORKORDER -> FAILUREREPORT to achieve this (something like wonum = :wonum and siteid=:siteid and type='REMEDY').

Hope this helps,

------------------------------
Alex Walter
A3J Group, LLC

Original Message:
Sent: 01-05-2024 16:17
From: Danny Richardson
Subject: How to add Search Field to Advanced Search in Work Order Tracking

Hello all,

Is there a way to add a Search Field to search for the "REMEDY" from Failure Reporting on the Work Order?  

In Summary:

• How to add a field to the Advanced Search box in Work Order Tracking using Application Designer?

Is there an article or YouTube video you could recommend for me to learn these steps?

Thank you in advance for any advice to get me pointed in the right direction.