QuerySetDateRange

Member of namespace

Maintenance Manager

Syntax

bool QuerySetDateRange (string start, string end, bool queryAgeStart)

Parameters

start

Type: string

end

Type: string

queryAgeStart

Type: bool

Parameters

• start: Date Range Start. Smart parameters are supported.
• end: Date Range End. Smart parameters are supported.
• queryAgeStart: True will use the batch start date. False will use the batch end date.

Returns

True if the query has been successfully set. It does not mean the query has been performed. Otherwise, False.

Level

Any level.

Details

Selects all of the batches that match the specified priority. If queryAgeStart is set to True, the query uses the batch start date, qs_start. If queryAgeStart is set to False, the query uses the batch end date, qu_done.

An exclamation point can be prefixed to the value to find all values except the ones specified.

Example:

QuerySetDateRange("03/16/2010","05/26/2010","True")
ProcessRunSqlQuery("")     

This example selects all of the batches that were created between the two specified dates.

QuerySetDateRange("03/16/2010","@DATE(mm/dd/yyyy)","True")
ProcessRunSqlQuery("")

This example uses a Smart parameter to obtain the current date. The query selects all batches that have been created between 03/16/2010 and the current date.