On To access the Query Object Editor, go to the Reporting home, click and select Navigate > Design > Query Object. The Query Object Editor screen is displayed.
...
The Query Object Editor has includes the following sections as shown in the image above:
Steps Selector
...
: The left pane
...
where you can drag and drop
...
required steps, such as Join, Union, and Format
...
, to design the Query Object
...
in the editor pane.
Editor or Transformation
...
Area: The central pane that represents the design of the current Query Object.
...
By default, the Data Source and Format
...
steps are displayed in this area when you begin designing.
Properties Tab: Located at the bottom left, this tab allows you to edit properties of the selected item in the editor, such as Data Type, Length, and Locale
...
.
Result
...
Tab: Located at the bottom right, this tab shows the data result set processed up to the currently selected step.
Options Menu
...
: The top menu provides action buttons
...
for CRUD operations
...
Item
...
Action
...
Save
...
and other actions.
Options Menu Actions
Save: Save changes made to the Query Object.
Help
...
: Access help documentation for query objects
...
Click
...
Add
...
.
Actions menu (More Options):
Add: Create a new Query Object.
Save As
...
: Save the current Query Object under a different name.
Open
...
: Open an existing Query Object using a selector dialog
...
. Expand the folder, then double-click or
...
select the Query Object name and click Open.
List View: View
...
Query Objects in a list format.
Detailed View
...
: View Query Objects
...
with detailed information.
Refresh List
...
: Refresh the
...
list of Query Objects fetched from the repository
...
Save As
...
Saves the editing work in a different name
...
Advanced
...
Refer the section Advanced Steps.
...
Delete
...
.
Advanced: Access advanced steps (refer to the Advanced Steps section).
Delete: Delete the currently opened Query Object from the repository after confirming. This action is
...
Add, Open, Save As, Advanced, and Delete options are inside the ellipses for better user experience.
...
irreversible.
Working with the Query Object Editor
...
The Editor section
...
provides a
...
canvas
...
for designing Query Objects.
Naming the Query Object: Double-click the Untitled Query Object text at the top of the screen to rename the query object.
Default Steps: When you add create a new Query Object, you get the already created two steps – two steps—Data Source and Format on —are automatically added to the editor. An edge line joins the two steps, with an arrow depicting depicts the flow of data between them.
You can select a new Adding Steps: Drag a step from the step selector and drag it on the editor and then join the step with another. Draw the joining Steps Selector onto the editor. Join the new step to another step by drawing a line in the direction of dataflowthe data flow. You can also double-click the a step to place add it on directly to the editor.
You can also directly drop a step on Inserting Steps: Drop a new step onto an existing edge line , to insert the new step it between the two existing ones joined by that linetwo connected steps. For example, to insert a filter Filter step between Data Source and Format, drop the Filter step on the connecting line.
Multiple Data Sources: You can
...
include multiple Data Source steps in a Query Object.
...
Steps like Join can take
...
two inputs
...
,
...
and steps like Union can take more than two inputs.
Viewing Results: At each step
...
, use the Result tab to
...
view the
...
processed data set up to the selected step.
...
Adding a
...
New Query Object
...
On the
...
Query Object
...
Editor, click the Add icon.
Select Query Object.
The Query Object Designer screen appears
...
, where you can design the
...
Below is a sample query object:
...
Figure 2: A sample Query Object
...
new Query Object.
Notes
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note Reserved keywords cannot be used when writing SQL queries or creating stored procedures. |