The initial solution for running repeated searches was to fake it by building many discreet searches. This creates problems for queries that repeat daily, weekly, and monthly over long time spans, such as decades. It results in many queries being sent to the server and creating a large request load.
A solution to this was to use wildcard symbols and the LIKE operator. Unfortunately because the datetime property is stored as a date/datetime type the LIKE operator cannot be used with this type input, and wildcard symbols cannot be used with timestamp type input.
The initial solution for running repeated searches was to fake it by building many discreet searches. This creates problems for queries that repeat daily, weekly, and monthly over long time spans, such as decades. It results in many queries being sent to the server and creating a large request load.
A solution to this was to use wildcard symbols and the LIKE operator. Unfortunately because the datetime property is stored as a date/datetime type the LIKE operator cannot be used with this type input, and wildcard symbols cannot be used with timestamp type input.