Unsupported content

 

This version of the product is in limited support. However, the documentation is available for your convenience. You will not be able to leave comments.

Performing basic query tasks

The basic tasks for queries include creating, modifying, and deleting a query or a query folder. 

To create a query

  1. Select Queries in the left window pane.
    If you want to create the new query within a query folder, select the respective query folder before continuing with step 2.

  2. Select Edit> Create Query .
    The Properties dialog box appears.

    Parameter

    Description

    Name

    The name of the object under which it is known in BCM. This name may be any combination of characters.

    Type

    Select the target type of the query from all principal objects available in the BCM database.

    Free Query

    Defines if the query is a free SQL query.

  3. Enter the desired data in the respective boxes.
  4. Click OK at the bottom of the window to confirm the data for the new query.
    A new query was created. It directly displays in the table in the right window pane.

To create a query folder

  1. Select Queries in the left window pane.
  2. Select Edit > Create Query Folder .
    The Properties dialog box appears.
  3. Enter the desired data in the respective boxes.
  4. Click OK at the bottom of the window to confirm the data for the new query folder.
    A new query folder with the specified properties has been created.

To modify a query

  1. Select Queries in the left window pane.
  2. Select the query to change to a free query in the table in the right window pane.
  3. Select Edit > Properties .
    The Properties dialog box appears.
  4. Check the Free Query box.
    A confirmation window appears.
  5. Click OK to confirm the modification.
    The modification of the query comes into operation.

Note

You can change the query type only in one direction: from a criterion query to an SQL query. SQL queries cannot be converted to criterion queries. When a criterion query is converted, the SQL syntax of its criteria will be displayed in the SQL tab.

To delete a query or a query folder

Queries which are assigned to other objects cannot be deleted. If the query folder to be deleted contains any members, they will be moved to Lost and Found under Global Settings.

Note

When deleting a query you lose all criteria definitions as well.

To delete a query or a query folder,

  1. Select Queries in the left window pane.
  2. Select the query or query folder to delete in the right window pane.
  3. Select Edit > Delete .
    The selected object will be deleted immediately.

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments