Skip to main content

Query Multiple Entity Records

Description​

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

Project compatibility​

Windows | Cross-platform

Properties​

  • 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.

Options​

  • 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.

Output​

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