269 views

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

  • For the search in Step 8 to return one search result because "11-07-2006" matches the date in the Begins column of 11-07-2006.

  • For the search in Step 9 to return no search results because "2006-07-11" does not match the 11-07-2009 date in the Begins column.

Actual behavior

  • Step 8 returns no search results because the search string is not in the format YYYY-mm-dd.

  • Step 9 returns one search result because the search string is in the format YYYY-mm-dd.

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

Seen In

Eureka Patch 10
Eureka Patch 6
Fuji Patch 11
Fuji Patch 12
Fuji Patch 7 Hot Fix 5

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-12-23 13:22:11
Published:2016-03-22