FindQueriesDateRange method: Session class

Syntax

FindQueriesDateRange(StartDateString, EndDateString)

Description

The FindQueriesDateRange method returns a reference to a Query collection, filled with zero or more queries that match the specified date range.

Parameters

Parameter Description

StartDateString

Specify the year, month, and day of the beginning date that you want to look for. This parameter takes a string value. You can specify the date either as YYYY-MM-DD or YYYY/MM/DD.

EndDateString

Specify the year, month, and day of the end date. This parameter takes a string value. You can specify the date either as YYYY-MM-DD orYYYY/MM/DD.

Returns

A reference to a Query collection containing zero or more queries.

Example

Local ApiObject &MySession, &QueryList; 
&MySession = %Session; 
&Start = GetField(VOLUN_ACT_WRK.START_DT_STR).Value; 
&End = GetField(VOLUN_ACT_WRK.END_DT_STR).Value; 
&QueryList = &MySession.FindQueriesDateRange(&Start, &End);

FindQueriesDateRange Considerations

FindQueriesDateRange returns both public and private queries. It depends on your database whether the private query is returned first or the public query. If you have two queries with the same name, it depends on your database whether the first use of Item returns the private or the public query.

Related Topics