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.