IJ50349: INCORRECT WHERE CLAUSE GENERATED BY USING NOT EQUAL OPERATOR IN MAXIMO QUERY

APAR status

• Closed as program error.

Error description

• ERROR DESCRIPTION:
  Incorrect WHERE clause generated by using Not Equal operator in
  Maximo query
  
  PROBLEM:
  Use of multiple criteria with the Not Equal operator on the List
  tab of any application generates an incorrect WHERE clause in
  the SQL query.
  The following results of single and multiple criteria in the
  Site field of the Assets application illustrate the issue:
  
  =BEDFORD generates (siteid = 'BEDFORD')
  !=BEDFORD generates (siteid != 'BEDFORD')
  =BEDFORD,=BOSTON generates ((siteid = 'BEDFORD' or siteid =
  'BOSTON'))
  !=BEDFORD,!=BOSTON generates (siteid != 'BEDFORD,!=BOSTON')
  --> should be (siteid != 'BEDFORD' and siteid != 'BOSTON')
  
  STEPS TO REPRODUCE:
  1. Open Maximo as maxadmin
  2. Go to Assets app
  3. In the List tab, with the Filter for the Site field type the
  following:
  	!=BEDFORD,!=BOSTON
  
  4. Hit ENTER
  5. Click the Combo Drop down arrow from Advanced Search and
  select Where Clause
  6. You will see that the current query is displayed as:
  	(siteid != 'BEDFORD,!=BOSTON')
  
  This is wrong. The query should be :   (siteid != 'BEDFORD' and
  siteid != 'BOSTON')
  
  CURRENT ERRONEOUS RESULT:
  You will see that the current query is displayed as:
  
  	(siteid != 'BEDFORD,!=BOSTON')
  
  EXPECTED RESULT:
  The query should be :   (siteid != 'BEDFORD' and siteid !=
  'BOSTON')
  
  ENVIRONMENT VERSION:
  App Server IBM WebSphere Application Server 9.0.5.17
  Version Tivoli's process automation engine
  7.6.1.3-IFIX20231130-1347 Build 20220823-0909 DB Build V7613-344
  HFDB Build HF7613-130
  IBM Maximo Application Framework 8.8.0 Build 20220823-1257 DB
  Build V7600-23
  IBM Maximo Asset Management Scheduler 7.6.8.2 Build
  20220823-0909 DB Build V7682-23 HFDB Build HF7682-10
  IBM Tpae Integration Framework 7.6.1.3 Build 20231130-0805 DB
  Build V7613-61
  LabelPro for Maximo by Asset Partners 7.6.0.0 Build
  20710413-0001 DB Build V7600-11 MT DB Build V7600-11
  IBM Maximo Asset Management 7.6.1.3 Build 20220823-0909 DB Build
  V7611-01
  IoT Connection Utility 7.6.0.4 Build 20220303-1642 DB Build
  V7604-01
  Server OS Windows Server 2019 10.0
  Server DB Oracle 19.1 (Oracle Database 19c Enterprise Edition
  Release 19.0.0.0.0 - Production Version 19.21.0.0.0)
  

Local fix

Problem summary

Problem conclusion

• A fix for this APAR will be included in a future release.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels