FME Transformers: 2025.1 BETA

TestSuite.DatabaseConstraintQuerier

Creates a database reader based on selected spatial and attribute constraints to be used when reading the data. These constraints are invoked via FME Objects.

Readers are often used to access datasets with millions of features. By using setConstraints() via FME Objects, an optimized query can occur where we limit the amount of data to be read. This can be useful when a dataset is very large or slow to access. A list with the possible types of constraints can be found here: https://docs.safe.com/fme/html/FME_setConstraints/index.html

Input Ports

Output Ports

Parameters

Example

READER DATASET = testsuitedb

READER TYPE = POSTGIS

READER CREATION AND CONSTRAINTS ARGUMENTS = --HOST bt-db-rhes3 --USER_NAME postgres --PASSWORD postgres --PORT 5432 fme_search_type fme_all_features fme_feature_type postgres.PR18099 fme_where 'test_index = 1'

Editing Transformer Parameters

Using a set of menu options, transformer parameters can be assigned by referencing other elements in the workspace. More advanced functions, such as an advanced editor and an arithmetic editor, are also available in some transformers. To access a menu of these options, click beside the applicable parameter. For more information, see Transformer Parameter Menu Options.

Transformer Categories

TestSuite Tools (Safe Internal)