APAR status
Closed as program error.
Error description
Selecting all records will return tasks and history records, however if you click on Restore Application Defaults the ?N? values do not populate if you have a default query. If you select All records and you do not have a default query clicking on Restore Application Defaults the ?N? values will populate. Steps to replicate: Login as maxadmin and go to workorder tracking application, search those workorder records which status='wappr' then I save it as a public query named testquery in workorder tracking application. Login as maxadmin again and go to worktrack application, then the testquery is display by default. Query new result: from querylist, select All Records and open more search fields of Advanced query The value of priority or is Task are empty. Click Default button, nothing changed, History and Is Task is still empty. Input asset '=11430' and hit Find, 60 rows return. Save this query as test2. Go to view/manage queries and open details of test2: (siteid = 'BEDFORD') and (exists (select 1 from maximo.multiassetlocci where ((assetnum = '11430')) and (recordkey=workorder.wonum and recordclass=workorder.woclass and worksiteid=workorder.siteid))) There is no History = N or Is Task = N in this query, so there are closed workorder in resultlist. This is the way it should perform when you have a default query and wish to search for records that do not come up in your default query. Replicate in 7114. Client's background to raise this issue: This is a major issue to my users, they are not interested in viewing 300,000 records when looking for an active work order to enter labour and Materials against a job. Most of the time they will use a work order from the default query which is by Craft, however they at times will require to enter data against a work order which has a different lead craft which will not be in their default list, displaying all records makes the search that much more difficult, if the 'N' remained when resetting it would make my users life much easier and I would not have to put up with the complaints from users. The system needs to reset with the 'N' in place and if you need to search all records then removing the 'N' would be better and more user friendly. I strongly feel this needs a rethink and a fix. Comments from Tom Rontiris: After reviewing the PMR with a Product Manager, they have concluded that the Restore Application Defaults button, should restore the application defaults only after the user selects the REVISE Drop Down button. and clicks "Clear Query and Fields" from the dropdown. Step 1: Revise Drop Down Step 2: Clear Query and Fields Step 3: Restore Application Defaults Step 4: Click Find Currently, when you step through these steps, the user is still left with their User Defined Default Query, and the Application Defaults are not restored. This is a DEFECT and an APAR should be created to address the problem.
Local fix
NA
Problem summary
**************************************************************** * USERS AFFECTED: Work order app * **************************************************************** * PROBLEM DESCRIPTION: Selecting all records will return tasks * * and history records, * * * * however if * * * * you click on Restore Application * * Defaults the ?N? values do * * * * not * * * * populate if you have a default query. * * * * If you select All records and you do * * not have a default query * * * * clicking * * * * on Restore Application Defaults the ?N? * * values will populate. * * * * Steps to replicate: * * * * Login as maxadmin and go to workorder * * tracking application, * * * * search those * * * * workorder records which status='wappr' * * then I * * * * save it as a public query named * * testquery in workorder tracking * * * * application. * * * * Login as maxadmin again and go to * * worktrack application, then * * * * the * * * * testquery is display by default. * * * * Query new result: from querylist, * * select All Records and open * * * * more * * * * search fields of Advanced query * * * * The value of priority or is Task are * * empty. * * * * Click Default button, nothing changed, * * History and Is Task is * * * * still * * * * empty. * * * * Input asset '=11430' and hit Find, 60 * * rows return. * * * * Save this query as test2. * * * * Go to view/manage queries and open * * details of test2: * * * * (siteid = 'BEDFORD') and (exists * * (select 1 from * * * * maximo.multiassetlocci * * * * where ((assetnum = '11430')) and * * (recordkey=workorder.wonum and * * * * recordclass=workorder.woclass and * * worksiteid=workorder.siteid))) * * * * There is no History = N or Is Task = N * * in this query, so there * * * * are * * * * closed workorder in resultlist. * * * * This is the way it should perform when * * you have a default query * * * * and wish * * * * to search for records that do not come * * up in your default query. * * * * Replicate in 7114. * * * * Client's background to raise this * * issue: * * * * This is a major issue to my users, they * * are not interested in * * * * viewing 300,000 records when looking * * for an active work order to * * * * enter labour and Materials against a * * job. Most of the time they * * * * will use a work order from the default * * query which is by Craft, * * * * however they at times will require to * * enter data against a work * * * * order which has a different lead craft * * which will not be in * * * * their default list, displaying all * * records makes the search that * * * * much more difficult, if the 'N' * * remained when resetting it would * * * * make my users life much easier and I * * would not have to put up * * * * with the complaints from users. The * * system needs to reset with * * * * the 'N' in place and if you need to * * search all records then * * * * removing the 'N' would be better and * * more user friendly. * * * * I strongly feel this needs a rethink * * and a fix. * * * * Comments from Tom Rontiris: * * * * After reviewing the PMR with a Product * * Manager, they have * * * * concluded that the Restore Application * * Defaults button, should * * * * restore the application defaults only * * after the user selects the * * * * REVISE Drop Down button. and clicks * * "Clear Query and Fields" * * * * from the dropdown. * * * * Step 1: Revise Drop Down * * * * Step 2: Clear Query and Fields * * * * Step 3: Restore Application Defaults * * * * Step 4: Click Find * * * * Currently, when you step through these * * steps, the user is still * * * * left with their User Defined Default * * Query, and the Application * * * * Defaults are not restored. * * * * This is a DEFECT and an APAR should be * * created to address the * * * * problem. * * * * LOCAL FIX: * * * * NA * * * **************************************************************** * RECOMMENDATION: * * * * * * * **************************************************************** DEFAULT QUERY ON WO REMOVES THE HISTORY AND ISTASK 'N'
Problem conclusion
The fix for this APAR is contained in the following maintenance package: | REL 7.1.1.5 - BS | REL 7.1.1.7 - BS
Temporary fix
Comments
APAR Information
APAR number
IZ69969
Reported component name
WORK ORDER TRAC
Reported component ID
5724R46WO
Reported release
711
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-02-10
Closed date
2010-03-10
Last modified date
2010-03-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
MAXIMO
Fix information
Fixed component name
WORK ORDER TRAC
Fixed component ID
5724R46WO
Applicable component levels
R711 PSY
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPPU","label":"Work Order Tracking"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"711","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
10 March 2010