Symptoms

The quick search feature is not working for one of my columns.

From the quick search drop down list - I selected the column which is a date field call Add Date. When I put a date in the search text box and search. It returns nothing.

It seems to work for all the other columns, just not the date field. Please advise how to fix this.
 

Diagnoses

N/A
 

Resolution

Found that the sql column for the AddDate is of type DateTime. Try to change that column to Date type, then refresh the sql service instance and the smartobject. Then try searching by the date using the format yyy-mm-dd to resolve the issue.