IJ36518: THE SAVED QUERY "FREQUENTLY ASKED QUESTIONS" HAS THE WRONG 'WHERE CLAUSE' IN THE SOLUTIONS APPLICATION

APAR status

• Closed as program error.

Error description

• Problem Description:
  
  In the Solutions application there is a saved query Frequently
  Asked Questions with a 'where clause' of (status like '%FAQ%'),
  but this should be (type like '%FAQ%'). Using the current query
  returns no records.
  
  Steps to reproduce:
  
  1. Go to Solutions application
  2. Click on Save query drop down button
  3. Click on View/Manage queries
  4. Expand the FAQ query
  5. The 'where clause' reads:  (status like '%FAQ%')
  
  Current results:
  
  When using the query with this 'where clause', no record is
  returned.
  
  Expected results:
  
  The 'where clause' should be (type like '%FAQ%'). If using this
  'where clause', then the correct number of records are returned.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO, ICD                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Solution application query for FAQ does not display any      *
  * solution                                                     *
  ****************************************************************
  

Problem conclusion

• Fixed the whereclause of the query (shipped with maxdemo data)
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels