Jump to main content
GE Vernova
  1. Home
  2. Queries
  3. Query Sources, Fields, and Joins
  • Queries
    • Query Creation
    • Query Results
    • Query Sources, Fields, and Joins
    • Query Expressions, Clauses, and Prompts
    • Query Settings
    • Workflow
    • Reference

Query Sources, Fields, and Joins

About Query Sources, Fields, and Joins

The following topics describe available actions related to query sources, fields, and joins.

Add a Source

Procedure

  1. To add a source to a new query:
    1. Access the Design workspace.
    2. Depending on the type of query source that you want to use, on the Select a Family or Query window, select either the Families or Queries tab.
      Depending on your selection, the list of entity families or Catalog folders to which you have at least View privileges appears.
      Note: If all sources have been removed from the Design workspace, in the page heading, select Add Source to open the Select a Family or Query window.
    3. In the Families section, in the list, select an entity family. Or, in the Queries section, navigate through the folder hierarchy and select a query.
    4. Select Add.
      The Select a Family or Query window closes, and your selected query source appears as a node on the design canvas.

  2. To add a related source:
    1. Access the Design workspace.
    2. On the design canvas, select the source to which you want to add a related source.

    3. Select the plus symbol, and then drag the pointer to another location on the design canvas.
      A blank node appears, and, in the direction that you drag the pointer, a line connecting the two nodes is drawn automatically.

    4. In the location where you want to place the related source, release the pointer.

      The Add Related Source window appears.

    5. Depending on the type of related source you want to use, select one of the following tabs. Select the Add Related Family tab to access the list of entity families to which you have at least View privileges, as well as the corresponding APM relationship families that link those entity families to the source you selected on the design canvas. Select the Add Manual Join tab to access options that allow you to manually link a field in the predecessor source (the source you selected) to a field in a successor family or query. Once you select a successor source, you can then define the type of join you want to use.
    6. In the Add Related Family section, select the desired entity family and relationship family combination. Alternatively, add a manual join via the Add Manual Join section.
    7. Select Add.

      The design canvas appears, and the new source node is populated with the selected source. The line connecting the two nodes changes to represent one of the following types of relationships.

      Join TypeLine Style
      APM Inner Join
      APM Outer Left Join
      APM Outer Right Join
      Manual Inner Join
      Manual Outer Left Join
      Manual Outer Right Join

What To Do Next

  • Add a field to a query.

Add a Field to a Query

Procedure

  1. Access the Design workspace.
  2. In the design canvas, select the source that contains the field you want to add to the conditions grid.
    The [<Source Name>] window appears, where [<Source Name>] is the name that appears on the query source node in the design canvas.

  3. In the [<Source Name>] window, in the Fields section, select the field that you want to add to the query.
    The field appears in the grid in the Conditions section.
    Note: If you add the same field from one source to the grid in the Conditions section twice, you must specify a unique value in the Alias cell for each field. If you do not specify a unique alias, APM will add a unique alias automatically.

Results

  • The Field cell contains a drop-down list, where you can modify your field selection.

What To Do Next

  • Run the query.

Arrange Columns

Procedure

  1. Access the Design workspace.
  2. In the Conditions section, select the heading of the column that you want to move, drag the pointer to a different location within the grid, and then release the pointer.
    The column is moved to the specified location.

Modify the Properties of a Join

Procedure

  1. To modify a join:
    1. Access the Design workspace.
    2. On the design canvas, select the line that connects two query sources.
      The window for the selected relationship family appears.
    3. Select Join Properties.
      The Join Properties window appears.
    4. On the Join Properties window, modify the join type to one of the following options, and then select Done:
      OptionDescription
      Inner joinRepresented by the Only include rows that are linked through '<Relationship Family>' option.
      Left outer joinRepresented by the Include ALL rows from '[<predecessor source>]' and only those rows from '[<successor source>]' where the joined fields are equal option.
      Right outer joinRepresented by the Include ALL rows from '<Successor Family>' and only those rows from '<Predecessor Family>' that are linked through '<Relationship Family>' option.
  2. To modify a manual join:
    1. Access the Design workspace.
    2. On the design canvas, select the line that connects two query sources.
      The window for the selected relationship family appears.
    3. Select Join Properties.
      The Join Properties window appears.
    4. On the Join Properties window, modify the join type to one of the following options, and then select Done:
      • Inner join, represented by the Only include rows that are linked through '<Relationship Family>' option.
      • Left outer join, represented by the Include ALL rows from '[<predecessor source>]' and only those rows from '[<successor source>]' where the joined fields are equal option.

      • Right outer join, represented by the Include ALL rows from '<Successor Family>' and only those rows from '<Predecessor Family>' that are linked through '<Relationship Family>' option.

      The properties of the join are modified.

Delete a Join

Procedure

  1. Access the Design workspace for the query from which you want to delete a join.
  2. On the design canvas, delete a source that is directly connected to the join that you want to delete.
    The join is deleted.

Display the System and Inactive Fields for a Query Source

Procedure

  1. Access the Design workspace.
  2. Add one or more sources to the design canvas.
  3. Select the source node for which you want to display system or inactive fields.
    The window for the selected source node appears.
  4. In the window, in the Fields section, select . Then, in the drop-down list, select either one or both of the Show System Fields and Show Inactive Fields check boxes.
    Depending on your selection, the system and/or inactive fields for the family appear in the Fields section, at the end of the list. System fields are identified by their field IDs, and inactive fields are identified by their field captions appearing within square brackets.

Remove a Query Source

Procedure

  1. Access the Design workspace for the query from which you want to remove a source.
  2. On the design canvas, select the source node that you want to remove.
    The option buttons appear just above the source node.
  3. Select the button.

    The source and all connected joins are removed from the query.

On this page
  • About Query Sources, Fields, and Joins
  • Add a Source
  • Add a Field to a Query
  • Arrange Columns
  • Modify the Properties of a Join
  • Delete a Join
  • Display the System and Inactive Fields for a Query Source
  • Remove a Query Source
© 2024 GE Vernova and/or its affiliates. All rights reserved. GE and the GE Monogram are trademarks of General Electric Company used under trademark license.

Privacy | Terms | Cookies | Accessibility