MAM 7.6.1.2:

Scenario:
A user is looking for WOs that meet certain criteria, but his default & saved queries don't fit what he's looking for. So the user runs the 'All Records' query, which selects all columns & rows from the WORKORDER table. Then he applies a filter to narrow down the results.

For applications that don't have many records, the 'All Records' query runs quickly and isn't a problem. However, for WOTRACK, we have hundreds of thousands of WOs/tasks, so the 'All Records' is far too slow. And in general, it doesn't make sense to SELECT * FROM WORKORDER -- before the user has a chance to apply a filter. That just selects records for no reason and is an unnecessary load on the system.

Question:
In WOTRACK, is there a way to clear the WHERE clause and clear the resultset...so that the user can filter all records, before selecting all records?

For example, is there a single button somewhere that achieves #1 and #2 -- all with a single click?


Thanks.

​​
#AssetandFacilitiesManagement
#Maximo

The closest thing I can think of is in Advanced Search, Revise button, Clear Query and Fields:

------------------------------
Travis Herron
------------------------------

Original Message:
Sent: Fri June 04, 2021 02:07 PM
From: User1971
Subject: List View: Clear the WHERE clause & clear the resultset?

MAM 7.6.1.2:

Scenario:
A user is looking for WOs that meet certain criteria, but his default & saved queries don't fit what he's looking for. So the user runs the 'All Records' query, which selects all columns & rows from the WORKORDER table. Then he applies a filter to narrow down the results.

For applications that don't have many records, the 'All Records' query runs quickly and isn't a problem. However, for WOTRACK, we have hundreds of thousands of WOs/tasks, so the 'All Records' is far too slow. And in general, it doesn't make sense to SELECT * FROM WORKORDER -- before the user has a chance to apply a filter. That just selects records for no reason and is an unnecessary load on the system.

Question:
In WOTRACK, is there a way to clear the WHERE clause and clear the resultset...so that the user can filter all records, before selecting all records?

For example, is there a single button somewhere that achieves #1 and #2 -- all with a single click?


Thanks.

​​
#Maximo
#AssetandFacilitiesManagement

Thanks. That helps.

For what it's worth, that 'Clear Query and Fields' button doesn't seem to clear the filter criteria in the main list view:


That's not a huge problem. Just thought I'd make a note of it.

Cheers.
Original Message:
Sent: Mon June 07, 2021 09:26 AM
From: Travis Herron
Subject: List View: Clear the WHERE clause & clear the resultset?

The closest thing I can think of is in Advanced Search, Revise button, Clear Query and Fields:

But that's going to be three clicks.  I'd imagine if you wanted to, you could create a button somewhere that does this.  You can find this in MENUS.XML, the event that happens here is called clearqryandfld.

------------------------------
Travis Herron

Original Message:
Sent: Fri June 04, 2021 02:07 PM
From: User1971
Subject: List View: Clear the WHERE clause & clear the resultset?

MAM 7.6.1.2:

Scenario:
A user is looking for WOs that meet certain criteria, but his default & saved queries don't fit what he's looking for. So the user runs the 'All Records' query, which selects all columns & rows from the WORKORDER table. Then he applies a filter to narrow down the results.

For applications that don't have many records, the 'All Records' query runs quickly and isn't a problem. However, for WOTRACK, we have hundreds of thousands of WOs/tasks, so the 'All Records' is far too slow. And in general, it doesn't make sense to SELECT * FROM WORKORDER -- before the user has a chance to apply a filter. That just selects records for no reason and is an unnecessary load on the system.

Question:
In WOTRACK, is there a way to clear the WHERE clause and clear the resultset...so that the user can filter all records, before selecting all records?

For example, is there a single button somewhere that achieves #1 and #2 -- all with a single click?


Thanks.

​​
#AssetandFacilitiesManagement
#Maximo

Right; in Advanced Search, you click that button, and if you look at the top of the dialog box, you can see that it changes the filtering to "All Records" -- but it doesn't run the query.  So your user would do the filtering within the Advanced Search dialog instead of on the List tab.

As an alternative solution, maybe whatever fields that need to be cleared out could be added to the List tab?  Based on your screenshot, the need is to search Status = CAN, so that means you need to clear out the History = 0 default setting.  So, maybe:
1) Add History Flag to the List tab.  Of course this would affect all users -- unless you apply some Conditional UI so it only is visible for the Security Group(s) that need it; or
2) Create a clone of WOTRACK with History Flag on the List tab, and grant that application to the Security Group(s) in question (and revoke regular WOTRACK); or
3) Can't say I'd recommend this, assuming that in most cases you don't want to load those thousands of records from history, but you could change WOTRACK so it doesn't have the History = 0 filter.

------------------------------
Travis Herron
------------------------------

Original Message:
Sent: Mon June 07, 2021 09:50 AM
From: User1971
Subject: List View: Clear the WHERE clause & clear the resultset?

Thanks. That helps.

For what it's worth, that 'Clear Query and Fields' button doesn't seem to clear the filter criteria in the main list view:


That's not a huge problem. Just thought I'd make a note of it.

Cheers.
Original Message:
Sent: Mon June 07, 2021 09:26 AM
From: Travis Herron
Subject: List View: Clear the WHERE clause & clear the resultset?

The closest thing I can think of is in Advanced Search, Revise button, Clear Query and Fields:

But that's going to be three clicks.  I'd imagine if you wanted to, you could create a button somewhere that does this.  You can find this in MENUS.XML, the event that happens here is called clearqryandfld.

------------------------------
Travis Herron

Original Message:
Sent: Fri June 04, 2021 02:07 PM
From: User1971
Subject: List View: Clear the WHERE clause & clear the resultset?

MAM 7.6.1.2:

Scenario:
A user is looking for WOs that meet certain criteria, but his default & saved queries don't fit what he's looking for. So the user runs the 'All Records' query, which selects all columns & rows from the WORKORDER table. Then he applies a filter to narrow down the results.

For applications that don't have many records, the 'All Records' query runs quickly and isn't a problem. However, for WOTRACK, we have hundreds of thousands of WOs/tasks, so the 'All Records' is far too slow. And in general, it doesn't make sense to SELECT * FROM WORKORDER -- before the user has a chance to apply a filter. That just selects records for no reason and is an unnecessary load on the system.

Question:
In WOTRACK, is there a way to clear the WHERE clause and clear the resultset...so that the user can filter all records, before selecting all records?

For example, is there a single button somewhere that achieves #1 and #2 -- all with a single click?


Thanks.

​​
#AssetandFacilitiesManagement
#Maximo

Hi,

It sounds like you need to set a default query that is basic and returns fewer records.
This technote explains how to modify an application to use it.
https://www.ibm.com/support/pages/setting-default-filter-where-clause-maximo-application

the catch is that this would apply to all users who use that application.
best regards,
Mark

------------------------------
Mark Robbins
Support Lead/Technical Design Authority / IBM Champion 2017 & 2018 & 2019 & 2020 & 2021
Vetasi Limited
https://www.linkedin.com/pulse/maximo-support-advice-from-non-ibm-engineer-article-mark-robbins/
------------------------------

Original Message:
Sent: Fri June 04, 2021 02:07 PM
From: User1971
Subject: List View: Clear the WHERE clause & clear the resultset?

MAM 7.6.1.2:

Scenario:
A user is looking for WOs that meet certain criteria, but his default & saved queries don't fit what he's looking for. So the user runs the 'All Records' query, which selects all columns & rows from the WORKORDER table. Then he applies a filter to narrow down the results.

For applications that don't have many records, the 'All Records' query runs quickly and isn't a problem. However, for WOTRACK, we have hundreds of thousands of WOs/tasks, so the 'All Records' is far too slow. And in general, it doesn't make sense to SELECT * FROM WORKORDER -- before the user has a chance to apply a filter. That just selects records for no reason and is an unnecessary load on the system.

Question:
In WOTRACK, is there a way to clear the WHERE clause and clear the resultset...so that the user can filter all records, before selecting all records?

For example, is there a single button somewhere that achieves #1 and #2 -- all with a single click?


Thanks.

​​
#AssetandFacilitiesManagement
#Maximo