IBM Support

IV97769: FILTERING ON A WORD IN AN "AFTER" DATE COLUMN PRODUCES UNEXPECTED RESULTS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • PROBLEM:
    
    Filtering on a word in an "After" date column produces
    unexpected result
    
    ENVIRONMENT:
    
    3.5.2.2
    10.5.2
    
    
    STEPS TO REPRODUCE:
    
    1)Open any business object that holds a search filter that
    constains a Planned End (Due Date), i.e triPlannedEndDT field.
    2)For example: Go to the Update Projects tasks 1 page
    3)Put the word "hello" in search filter for the Planned End (Due
    Date) column and click enter
    4)Notice it still returns dates despite it being an unrecognized
    and random search word.
    

Local fix

  • N/A
    

Problem summary

  • The Platform currently treats any invalid string as 'Today's
    Date
    

Problem conclusion

  • For Query Reports that have filters enabled, a check has been
    added whenever a user attempts to use an invalid filter in a
    date or date-time field. If a non date or non date-time string
    is used in this filter, then a "No data to display" message is
    shown to the user in the body of the query results table, and
    zero results are returned.
    This is targeted to the 2h2017 release.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV97769

  • Reported component name

    TRI APPLCATION

  • Reported component ID

    5725F26AB

  • Reported release

    351

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-07-07

  • Closed date

    2017-08-10

  • Last modified date

    2017-08-10

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

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

Modules/Macros

  •    None
    999
    

Fix information

Applicable component levels



Document information

More support for: IBM TRIRIGA Application Builder
IBM TRIRIGA Application builder

Software version: 351

Reference #: IV97769

Modified date: 10 August 2017