Query Block

To begin designing an Integration flow, your first step is to select the Query block for the Connection from which you want to retrieve source data. Drag the Query block from the Connections panel to the workspace.

Note: For certain Connectors, such as Microsoft SQL Server, the Native Query Block is also available. Use the Native Query block to enter queries in the language provided by that Connector.

A Query block or Native Query Block is required at the start of all Integration flows. The entity and filters specified in the Query block define what source data is processed by the flow, one record at a time.

If you have more than one stack of blocks on the workspace, only one stack can be processed by the flow. Use the Set Active Stack option on the Query block Gear menu for the stack you want processed to indicate that it is the Active Stack.

From the Query block you can:

Block Properties — General Tab

After you have moved the Query Block to the workspace, you can begin to configure it using the Properties panel on the right.

Edit Query Properties

  1. Select the Query block to display settings in the Properties panel on the right.
  2. Select the General link to open the Properties dialog to the General tab.
  3. Optionally change the label and add a description as described in Block Properties General Tab.

Block Properties — General Tab

From the Block Properties General Tab, you can change the Block Label, add a description, and select the entity to be queried.

Block Properties — Net Change Tab

Use the options on the Net Change tab to either return all records or filter for new or updated records in your source data.

Process all or Process only new and updated records — If you wish to reduce the number of records processed by the flow, you can use the Process records settings to filter records by date. For more information on this filter, see Block Properties Net Change Tab.

When a datetime is configured on the Query block on the Block Properties Net Change Tab to query for new and updated records, that configuration is treated as an additional filter. The Net Change datetime filter is applied as an AND after any other filters specified on the Block Properties Filter Tab. TIBCO Cloud™ Integration - Connect builds a query combining both the Net Change filter and the filters on the Filter tab. See Net Change And Filters for an example.

Some Connectors for TIBCO Cloud™ Integration - Connect only support one filter. For those Connectors you can use either Net Change or one filter on the Filter tab, not both.

Note: The Net Change date is ignored when previewing data on the Preview tab. Filters on the Block Properties Filters tab are used to filter the data on the Preview tab.

Block Properties — Filter Tab

By default Query retrieves all data from the selected entity. Using the Filter tab, you can add one or more filtering criteria to limit the types and number of records processed by a flow. See Block Properties Filter Tab.

Note: Only the records that meet the filtering criteria display in the Preview tab.
Note: Filtering is not supported for the Text Source Connector.

Block Properties — Include Tab

You may wish to process source data that is related to the selected entity. For example while processing accounts, you may want to retrieve all of the contacts for each account. In this case, you can select related entities on the Include tab to include the data from these entities in this flow. See Block Properties Include Tab — Relational Data and Block Properties Include Tab — Hierarchical Entities.

Block Properties — Preview Tab

Preview Source Data

Before building your flow, you can preview the first 25 records of your source data. When you open the Preview tab, TIBCO Cloud™ Integration - Connect generates, and then displays the first record in your source data to be processed when you run this flow. See Block Properties Preview Tab.

Note: Displaying the first record may take a few moments. Records on the Preview tab are filtered using the criteria on the Filters tab, but are not filtered by the date entered on the Net Change tab.

Block Properties — Errors And Warnings Tab

If there are any errors or warnings for this block, the Errors and Warnings tab displays the number of errors or warnings in the tab name. See Block And Flow Errors And Warnings.

Once you have corrected the errors, select the Validate button to update the Errors and Warnings tab.

Related Topics

Defining An Integration Flow

Native Query Block

Block Properties Filter Tab

Control Blocks

Most Recent Record Processed

Active Stack