Column Search does not work with correct date format


Description

Searches using the column search at the top of a list do not respect the date format currently in use (set either by system property or user preference). Instead, all dates are expected to be in the format YYYY-mm-dd. If you enter a date that is not in this format, no search results are returned.

For example, a record in the list shows a date of 15-03-1995 (15 March 1995). If you use the column search method to search for "15-03-1995", no result is returned. However, if you search for "1995-03-15", the record is displayed in the list.

Steps to Reproduce

Using a Geneva instance with demo data installed, perform the following steps:

  1. Impersonate an ITIL User.

  2. Navigate to Self-Service > My Profile.

  3. Select the date format dd-MM-yyyy.

  4. Click Update.

  5. In the application navigator, type sla.list and press the Enter key.

  6. Click the gear icon  to personalize the list and show the Begins column.

    Only one record should appear in the list, and it should show a date in the Begins column of 11-07-2006.

  7. Click the search icon  to show the column search headers.

  8. Type 11-07-2006 into the Begins column's search field and press the Enter key.

  9. Type 2006-07-11 into the Begins column's search field and press the Enter key.

Expected behavior

Actual behavior

Workaround

Use the list filter instead of the list column search. List filters respect the date format currently in use by the system.


Related Problem: PRB622619