Query Multiple Entity Records

Description

Retrieves a list of records across multiple Data Fabric entities by performing a join operation.

Compatibilidade do projeto

Windows | Multiplataforma

Propriedades

• Data Fabric connection - Select the Data Service connection you established in Integration Service. Access the dropdown menu to select, add, or manage connections.
• Primary entity - Specify the main entity from which records are retrieved.
• Secondary entity - Specify the related entity to join with the primary entity.
• Join type - Define the type of join performed between the primary and secondary entities.
  • Inner Join - Select to return only records where matching values exist in both entities.
  • Left Join - Select to return all records from the primary entity and matching records from the secondary entity. If no match exists, secondary fields return null.
• Primary entity join field - Specify the field from the primary entity used to establish the join relationship.
• Secondary entity join field - Specify the field from the secondary entity used to establish the join relationship.
• Filter conditions - Define filtering criteria for records from the primary and/or secondary entity.

Opções

• Skip - Specify the number of records to skip from the start.
• Top - Specify number of records to return at most. The property supports values from 1 to 1000. The default value is 100.
• Sort ascending - Specify whether to sort in ascending (true) or descending (false) order.
• Sort by field - Specify the field used to sort the returned records.

Saída

• Records - Retrieved records automatically generated output variable. You can use it as it is or save it with a different name.