Query Center

The column to query.
There are ten 'custom' columns -

Raw Date - Use this with the TODAY() function to query for a relative date.(eg:raw date >= TODAY() - 7 will query for all records in the last 7 days)

Raw time - Use this with the CLOCK() function to query for a relative time.
CLOCK() - The number of hundredths of a second that have elapsed since midnight.
Example:Raw Date =TODAY() and Raw Time > CLOCK() - 360000 (All the jobs in the last hour)

Day of month - the day of the month 1-31.

Day of week - 0 = Sunday, 1 = Monday etc.

Month - 1 - January, 2 = February etc.

Year - The year number. eg:2006

Previous month - The previous calendar month. If todays month is June, then the previous calendar month is May 1 to May 31. This is a boolean (logical) function, it returns Y if the log date is in range and N if it is not.
Example: Previous month equals Y (Note: You should always use uppercase Y or N)

Previous 3 months - The previous three calendar months. If todays month is June, then the previous three calendar months are March 1 to May 31. This is a boolean (logical) function, it returns Y if the log date is in range and N if it is not.
Example: Previous 3 months equals Y (Note: You should always use uppercase Y or N)

Previous 6 months - The previous six calendar months. If todays month is June, then the previous six calendar months are Jan 1 to May 31. This is a boolean (logical) function, it returns Y if the log date is in range and N if it is not.
Example: Previous 3 months equals Y (Note: You should always use uppercase Y or N)

Previous 12 months - The previous twelve calendar months. If todays month is June 2007, then the previous twelve calendar months are June 1 2006 to May 31 2007. This is a boolean (logical) function, it returns Y if the log date is in range and N if it is not.
Example: Previous 12 months equals Y (Note: You should always use uppercase Y or N)

The query operator eg: Less than, greater than, not, equals.

Shows all logs, but highlights logs that meet the search criteria, rather than filtering out logs that do not meet the search criteria.

Makes string searches case sensitive.

The value or expression to query against.

Removes the current query.

Saves changes to the query.

Saves a query under a specified name.

Loads a previously saved query.

Applies the query to the job data set.

The logical connection between query statements. eg: And, or, not.
Use the DONE connecting operator when you have finished your query statement.