Using Connected Query Quick Start

The Connected Query Quick Start is a wizard that walks you through creating a simple connected query with a single parent query and a single child query linked using a set of related fields.

Note: The parent and child queries must exist and be visible in Query Manager before you can use them to create a connected query.

You cannot specify a child query in a connected query that is defined in a union.

Connected Query Quick Start is used only for creating new connected queries. You can edit existing connected queries using the Connected Query Manager page.

Connected query uses query security permissions for each of it member queries.

Use the Connected Query Quick Start - Step 1 (CQ_WZ_INFO) to enter a connected query name and descriptive information, and define ownership of the connected query.

Navigation

Reporting Tools > Connected Query > Connected Query Quick Start

Image: Connected Query Quick Start - Step 1

This example illustrates the fields and controls on the Connected Query Quick Start - Step 1. Definitions for the fields and controls appear following the example.

Connected Query Quick Start - Enter a Name and Descriptive Information page

Field or Control

Definition
Connected Query

This is a required field.

Enter a name for the connected query.

Note: The name of the connected query cannot be changed after you enter the name into the Select a Child Query page of a Connected Query Quick Start.

Because Connected Query uses query name as an XML node, query names used in a Connected Query must follow these naming rules:

  • Query names can include letters, numbers, and other characters.

    However, query names cannot include spaces.

  • Query names can start with letters xml (or XML, Xml, and so on).

    However, these names cannot consist of only three letters XML.

  • Query names cannot start with a number nor a punctuation character.

If a query name starts with an alpha or underscore [ _ ] character, the query node name in an XML file will be the same as the query name. Otherwise, the query node name will be the query name with the prefix PS_. For example:

  • Query MyQuery123 is written to the output XML file as MyQuery123.

  • Query _MyQueryA is written to the output XML file as _MyQueryA.

  • Query 123MyQuery is written to the output XML file as PS_123MyQuery.
Public

Indicate the query ownership.

If the Public check box is selected, this connected query will be public. If the Public check box is not selected, this connected query will be private.

Note: The ownership of the connected query cannot be changed after you enter data into the Select a Child Query page of a Connected Query Quick Start.
Description

(Optional) Enter a description for the connected query.
Comments

(Optional) Enter comments for the connected query.
Next

Note: The Next button is available after you enter the name of the connected query in the Connected Query field and move to any other field.

Click to advance the wizard to the next page.

Use the Connected Query Quick Start - Step 2 (CQ_WZ_PARENT) to select an existing query to use as the parent query.

Navigation

  1. Select Reporting Tools > Connected Query > Connected Query Quick Start.

  2. Enter a connected query and descriptive information, and click the Next button.

Image: Connected Query Quick Start - Step 2

This example illustrates the fields and controls on the Connected Query Quick Start - Step 2. Definitions for the fields and controls appear following the example.

Connected Query Quick Start - Select a Parent Query page

Field or Control

Definition
Parent Query

Click the query Lookup icon to select a parent query from a list of queries for which you have been granted access.

Note: You must use the query Lookup icon to select a parent query and be able to move to the next page.
View Query

Click to open Query Manager component in read-only mode to view the query.
Next

This button becomes active after you select a parent query.

Click to advance the wizard to the next page.

Use the Connected Query Quick Start - Step 3 (CQ_WZ_CHILDQRY) to select an existing query to use as the child query.

Navigation

  1. Select Reporting Tools > Connected Query > Connected Query Quick Start.

  2. Enter a connected query and descriptive information, and click the Next button.

  3. Select an existing query to use as the parent query, and click the Next button.

Image: Connected Query Quick Start - Step 3

This example illustrates the fields and controls on the Connected Query Quick Start - Step 3. Definitions for the fields and controls appear following the example.

Connected Query Quick Start - Select a Child Query page

Field or Control

Definition
Child Query

Click the query Lookup icon to select a child query from a list of queries for which you have been granted access.

After you select a child query, its name appears in the Connected Query Structure section.
View Query

This button becomes active after you select a child query.

Click to open Query Manager component in read-only mode to view the query.
Next

This button becomes active after you select a child query using the Lookup icon.

Click to advance the wizard to the next page.

Use the Connected Query Quick Start - Step 4 (CQ_WZ_FLDMAP) to map query fields from a child query to corresponding fields from a parent query.

Navigation

  1. Select Reporting Tools > Connected Query > Connected Query Quick Start.

  2. Enter a connected query and descriptive information, and click the Next button.

  3. Select an existing query to use as the parent query, and click the Next button.

  4. Select an existing query to use as the child query, and click the Next button.

Image: Connected Query Quick Start - Step 4

This example illustrates the fields and controls on the Connected Query Quick Start - Step 4. Definitions for the fields and controls appear following the example.

Connected Query Quick Start - Map Child Query Fields to Parent Query Fields for Filtering page

This page displays two sets of fields coming from parent and child queries:

  • The parent query section displays parent query fields and is for informational purposes only.

    This section is collapsed by default and you have the option to expand it.

  • The child query section displays child query fields and enables the report developer to select one or more fields for mapping.

    For each child query field selection, a drop-down list with possible parent query field lists appears. Those parent query field lists are filtered by compatible field data types. In some cases, Connected Query Manager uses smart thinking to map fields based on partial matching names but ultimate field matching is up to the user.

Field or Control

Definition
Map Field

Click to update the Connected Query structure.

Note: The Fields column in the Connected Query Structure section displays the values that you just selected.
Next

This button becomes active after you select the fields for mapping and click the Map Fields button.

Click to advance the wizard to the next page.

Image: Connected Query Quick Start - Step 4

This example illustrates the fields and controls on the Connected Query Quick Start - Step 4. Fields are mapped and Connected Query structure is updated.

Connected Query Quick Start - Connected Query structure is updated

Report developers use the Connected Query Quick Start - Step 5 (CQ_WZ_PREVIEW) to review a new connected query and preview the results by running it in a preview mode with a limited number of rows returned from each query.

Navigation

  1. Select Reporting Tools > Connected Query > Connected Query Quick Start.

  2. Enter a connected query and descriptive information, and click the Next button.

  3. Select an existing query to use as the parent query, and click the Next button.

  4. Select an existing query to use as the child query, and click the Next button.

  5. Map query fields from a child query to corresponding fields from a parent query, and click the Next button.

Image: Connected Query Quick Start - Step 5

This example illustrates the fields and controls on the Connected Query Quick Start - Step 5. Definitions for the fields and controls appear following the example.

Connected Query Quick Start - Preview page

Field or Control

Definition
Preview XML

Click to display the formatted XML output for this connected query.

XML output appears in a Preview mode, in the lower section of the Preview page.
Max Rows Fetched For Query

Enter the maximum number of rows to display in Preview mode by each member query.

Note: You should limit the number of rows that are being fetched. The default value is 6. If you enter 0 or clear this text box, no row limits are imposed for a resulting XML, which can cause significant delay in getting results; and because the application runs in synchronized mode using the application server, you may get browser time-out or tuxedo time-out.
Complete

Click to transfer to Connected Query Manager page, where you can perform enhancements and save the connected query.

Note: While working with a Connected Query Quick Start, you can modify your previous selections at any step by clicking the step number (in yellow or gray) icons. Changes in your selection could change a connection query structure.

Note: In the Connected Query Quick Start - Preview page, when XML that contains CDATA sections is displayed at runtime, application users will see <![CDATA* and *]> in places of <![CDATA[ and ]]>.