Listview QuickSearch Date Field Filter Not working

  • 17 March 2016
  • 0 replies
  • 4 views

Badge +12


 

Symptoms


Filtering of Date values on a List View Quick Search does not work
 

Diagnoses


Problem using Quick Search when filter is a date type. Tried Searching DD/MM/YYYY, MM/DD/YYYY, DD MMM YYYY, MMM, DD-MM-YYYY, MM-DD-YYYYY, DD MM YYYY, MM DD YYYY. All no result.
 

Resolution

This has been logged as a bug to be fixed on a future version of the product. As a workaround, kindly consider the following:

1. Filter must match underlying data. If the data source (SQL for example) format's dates in YYYY-MM-DD format, then the filter functionality of the view will work with that same format. This does not necessarily match the display format of the data.

2. Create your own custom view control which has its own filtering logic




 

0 replies

Be the first to reply!

Reply