Using Recent Queries
My Recent Queries mode provides fast access to the latest queries you have executed.
To access the latest queries executed:
In the
My Recent Queries tab of the query tool, select an object type in the drop-down list.
When you select a query in the list displayed, its parameters and values are displayed.
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 wish to keep it, you must save it using
.
Memorizing 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.
Configuring the number of recent queries
To configure the number of memorized recent queries:
1. In the workspace, select Tools > Options.
2. Select the Queries folder.
3. In the right part of the dialog box, select a value for Number of recent queries kept.
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#" |