Block Properties Preview Tab

When configuring a Query Block or a Fetch Block in a flow, use the Preview tab to view source data for the first 25 records.

Note: For some third-party connectors, TIBCO Cloud™ Integration - Connect times out when attempting to preview data in the Query Block. Use filters in the Query block to reduce the amount of data returned. See Block Properties Filter Tab.

Browsing Data

Use the buttons at the top of the Preview tab to scroll through the records retrieved by the block.

Button	Function	Definition
	Display first record	Displays the values in the first source and target records.
	Display previous record	Displays the values in the previous record.
	Record n of nn	Indicates which record is displayed in the preview set.
	Display next record	Displays the values in the next record.
	Display last record	Displays the values in the last record in the preview set of 25 records.

Tip: To refresh the data, select a different tab and then return to the Preview tab.

Previewing Related Entities

If you select one or more related entities from the Include tab of the Block Properties, the Preview tab displays the following:

Fields from each parent entity.
The number of child records that are associated with the source record are displayed, if you included a related child entity.

If you include a related entity and selected Return records with or without relationship, all source records display, whether there is a related entity.
If you include a related entity and selected Return only records with relationship, only those source records with a related entity display.

Previewing Hierarchical Data

If you select one or more hierarchical entities from the Include tab of the Block Properties dialog, the Preview tab displays the following:

Fields from the parent entity.
If you include a related child entity where there is a one-to-one relationship with the parent entity, fields from the child entity display.
If you include a related child entity where there is a one-to-many relationship with the parent entity, the number of child records display. Counts for any children of this entity do not display.

Tip: Loading the data selected on the Include tab may take a few moments. If you receive a message indicating that metadata is not available yet, select OK to close the Block Properties dialog and save your selections. Wait a few moments and try the Preview again.

Previewing Filtered Data

If you specify filtering criteria on the Block Properties Filter tab, the first 25 records that meet the specified criteria are available in the Preview tab. See Block Properties Filter Tab.

Note: Net Change is ignored on the Preview tab. You can temporarily set the date in the Block Properties Filter tab to preview the data. When you are done previewing, remove the date filter. The flow uses the Net Change filter when it runs.

Viewing Field Details

To access additional field information, select the Info icon for that field. Details displayed vary depending on the type of field selected but may include any of the following types of information.