Query Operations
Description
This page provides an overview of query operations and looks at how to perform them.
Overview of Query Operations
The Query operation saves filter and order expressions for a table or set. The query that you create here can be seen on the Operations tab of the Control Panel and on the Saved Queries tab of the Primary Index or Query dialog box.
Performing a Query Operation
Display the Operations tab of the Control Panel.
Click New.
Select "Query Records" from the Select operation list.
Select the target table or set from the Select Table/Set list.
For those who know how to write Xbasic expressions, click Create to display the Query Builder dialog.
For those who know how to write Xbasic expressions, click Create to display the Query Builder dialog.
For those who would like to create the query interactively, click Create Using Genie to display the Query Genie.
To run the finished query immediately click the 'lightning' icon to Run.
To run the finished query against a specific layout based on the selected table or set, click Run Special.
Select the Layout Type.
Select the Layout Name and click OK.
To save the operation click the save and enter the name of the operation into the Save Query dialog and click OK.
The next step is a one-way operation from Query Genie to Query Builder.If you created the query with the Query Genie, you may convert your inputs to filter and order expressions by clicking Convert. The results will appear in the Query Builder.
See Also