Quick Edit Filter Controls
The Quick Edit menu displays different filter controls depending on the query parameter data type.
The possible options for data types are:
- String: If the field is of string data type, you can type a few letters, and a list of matching values appears. Either select a value from the list, or enter a value.
- Numeric: If the field is a numeric data type, type a numeric value.
- Date: If the field is of Date data type, then you can either select a value from those shown in the table, or type your own value.
Data Type Options Description STARTOFDAY
Gives a timestamp, indicating the beginning of the day, formatted using yyyy-MM-dd'T'HH:mm:ss.SSSZ. For example, 2010-05-03T00:00:00.000-0700. ENDOFDAY
Gives a timestamp, indicating the end of the day, formatted using yyyy-MM-dd'T'HH:mm:ss.SSSZ. For example, 2010-05-03T23:59:59.999-0700. TODAY
Gives the current date formatted using yyyy-MM-dd. For example, 2010-05-03. STARTOFYESTERDAY
Gives a timestamp, indicating the beginning of the previous day, formatted using yyyy-MM-dd'T'HH:mm:ss.SSSZ. For example, 2010-05-02T00:00:00.000-0700. ENDOFYESTERDAY
Gives a timestamp, indicating the end of the previous day, formatted using yyyy-MM-dd'T'HH:mm:ss.SSSZ. For example, 2010-05-02T00:00:00.000-0700.
Copyright © Cloud Software Group, Inc. All rights reserved.