Using Recent Queries
In the advanced search tool, My Recent Queries tab provides fast access to the latest queries you have executed.
Accessing your recent queries
To access the last queries you have launched:
1. Open the advanced query tool.
2. Select the My Recent Queries tab.
3. By default the object type on which your last query dealt with is selected; if needed, in the drop-down list, select another object type.
4. Select a query in the list.
The query code is displayed at the bottom of the list.
Defining recent queriesÂ
My Recent Queries mode uses the "Temporary Query" object type (or MetaClass) to temporarily memorize your queries.
They contain the final code that produced the objects listed in the result tab. These objects are specific to each user.
A recent query is not intended to be kept indefinitely. If you want to keep it, you must save it.
Configuring the number of recent queriesÂ
For each user, a defined number of recent queries is memorized.
When this number is reached, the oldest recent queries are deleted, except if they are among your favorites.
To configure the number of memorized recent queries:
1. In HOPEX menu bar, select Tools > Options.
2. Select the Queries folder.
3. In the right pane, in the Number of Recent Queries Kept field, modify the value.
The default value is 50.
Examples of recent queriesÂ
A recent query is a query that has been resolved and is directly executable. If the query includes parameters, the recent query contains the values of these parameters.
Query | Parameter values | Temporary query code memorization |
|---|
Select [Project] Where [Short name] ="&[Short name] | HBC for &[Short name] | SELECT [Project] WHERE [Short name] ="HBC" |
Select [Project] Where [Start date] = "&Project.Start date" And [Project manager names] = "&Project.Project manager names" | "15/02/2004" for "&Project. Start date" and "Brown" for &Project.Project manager names" | Select [Project] Where [Start date] = ""15/02/2004"" And [Project manager names] = ""Brown"" |
Select [Organizational Process] Where [Name] Like "Com#" | | Select [Organizational Process] Where [Name] Like "Com#" |