Date Range Filters

There are three types of dates that can used to limit the scope of data returned:

Date Type	Description	Use Case
Submitted	The DateTime the “Submit” button was pressed by the Operator.	Submitted Date is based on the goal of reporting on when a record activity was completed.
Processed	The DateTime the System Processed the Record and saved the data.	Processed Date is best used for maintaining a data warehouse. This ensures the most recently added records can be retrieved. This is because Offline mode means that Submitted data is not when it was added to the database. For example, requesting all records submitted in the last hour does not guarantee that all records have been processed.
Modified	The Last Date the record was modified.	Modified Date may be needed or changed to records need to be exported to maintain a warehouse. Note: all records have a modification that as a minimum aligns with the submitted datetime. If modified date is used a record that was pulled previously may be included in a subsequent call. If this data is being inserted into a data warehouse you may need to add logic to replace or update that records in your data warehouse.

📘
Note:
The Modified Date is less performant than Submitted Date or Processed Date because the history data must be processed to set the last modified date.

Start and End Dates

Each of the three data times supports a Start and End date, For Example:

        "DateFilters": {
            "DateType": "Submitted",
            "TimeZoneOffset": 0,
            "End": "2024-02-01",
            "Start": "2024-01-01"
        },

The supported date format is “yyyy-MM-DD HH:mm:ss” for example 2024-01-01 23:05:00
If the End Time is omitted, then all records from the Start Time to the Current Time are returned.
If the Start Time is omitted all records before the end time are returned (rarely used).

🚧
Important
Do not use Start and End Dates when using MinAgo (Slide Time Scale); they cannot be used together.

Slide Time Scale

A sliding Time Scale of “Minutes Ago” is supported. This will return all records between the end time and a time established by subtracting the minutes ago. If no End Date is provided, the current datetime is used. For example: “MinAgo=5 ” returns all records submitted in the last 5 minutes. (assuming they are available in the system).

Example:

        "DateFilters": {
            "DateType": "Submitted",
            "TimeZoneOffset": 0,
            "MinAgo": 5
        },

📘
Note:
Do convert days to minutes, Multiply by 1440. Example: 2880 is 2 days.

Time Zone Offset

All dates are stored in a UTC time zone. A “TimeZoneOffset” parameter allows you to define the number of hours to offset from UTC adjust the date time values. The offset applies to all filter input parameters, as well as all date and time output parameters.

📘
Note:
The Default is 0

Time	Eastern	Central	Mountain	Pacific	Alaska	Hawaii
Standard	-5	-6	-7	-8	-9	-11
Daylight	-4	-5	-6	-7	-8	-10

Exact Filters

Exact Filters request records based on key attributes of records. The Filters are additive with an AND conditions so adding more filters further restricts the results set. Exact Filters are faster than the _Like or _List filter and should be used wherever possible to narrow the scope of records returned.

Parameter	Description
Form.Name	Exact Form Name
Resource.Name	Exact Resource Name
Location.Name	Exact Location Name
Identifier.Name	The FieldName of an Identifier. Example "Lot'
Identifier.Value	The Value of an Identifier that corresponds to the Identifier name. Identifier Name and Value are used together
RecordNumber	Record Number. Returns a Single Record
RecordCompliance	Returns Records Where compliance is True of False. NOTE that records with No Compliance are assumed to be "True"
IsSigned	Returns any record that has a SignOff or Validation

Like Filters

Like filters allows you search key attributes for a partial match on the name using a "Contains” match on any part of the parameter’s name. Like Filters are SLOWER than Exact.

Parameter	Description
Form.Like	Form Name 'Contains'. Example 'Check' Returns any Form that contains 'Check'
Resource.Like	Resource Name 'Contains'. Example: 'Apple' Returns All Resources that contain Apple
Location.Like	Location Name 'Contains': Example: . 'USA-' Returns all Locations that contain 'USA-' in the name.
isVerified	Filters the results to only records that have been signed or verified when the filter is set to "True".

List Filters

List filters will allow you to search using an array of values. Each value in the array will do an exact match for the records returned. Example:

Form.List
Resource.List
Location.List