This is an old revision of the document!
Table of Contents
Search
Protogrid provides a simple search/filter functionality in tableviews and selection/dropdown lists. Please note that a Google-like search engine is not yet available for Protogrid but is planned for a future release. The system does not provide boolean operators like AND, OR, NOT.
Textual search
Single text values can be entered straightforward. If you would like to search for word combinations enclose your search with double quotes.
Searching for numbers
Searches for number values do not require any special handling.
Searching for date and time entries
Usually the frontend displays date/time values in your local timezone and according to your regional settings. The system stores date/time values in UTC format.
Searches for dates must meet the following format: YYYY-MM-DD where YYYY is the 4 digit year number, MM is the two digit month number and DD is the two digit day number, each part connected by a minus
Note that in some cases due to UTC format the day number may differ compared to the day number in your local timezone.