BigMachines Connector > Synchronization Tasks with BigMachines Connector > Data Filters
  

Data Filters

You can use data filters to fetch specific data of a particular object. The synchronization task processes the data based on the filter field assigned to the object. Informatica Cloud BigMachines Connector supports basic filters.
You can use all the fields present in data tables object as data filters. You can create custom filter fields for parts and data tables object. When you setup the synchronization task for Quote object, you must apply the filter field _FLT_TransactionFileName. The transaction file must contain a column with header name transaction_id. Filters are not mandatary for QuoteV2 and QuoteV2LineItem objects.
Perform the following steps to use data filters:
    1Select Data Filters tab in the synchronization task wizard.
    The Data Filters tab appears.
    The following image shows the Data Filters tab:
    2Select New.
    The Data Filter dialog box appears. The following image shows the Data Filter page:
    3Specify the following details in the Data Filter page:
    Field Type
    Description
    Object
    Select object for which you want to assign filter fields.
    Filter By
    Select the Filter Field.
    Operator
    Select the corresponding operator.
    Filter Value
    Enter the filter value.
    4Click OK.
Note: The data filters support only Equals operator for the objects of Quote module.

Modules and Operators

The following table describes the operators that Bigmachines modules support:
Modules
Objects
Supported Operators
Transaction
Quote_ExportAttachment, QuoteV2, QuoteV2LineItem
Equals Equals, notEquals, greaterThan, lessThan, greaterOrEquals, lessOrEquals, contains
Parts
Parts
Equals, notEquals, contains
Data Tables
Data Tables
Equals, notEquals, greaterThan, lessThan, greaterOrEquals, lessOrEquals, contains
Configuration
BoM
Equals
Spare
Equals
Price
Equals
Note: The supported operators are valid only for query or fetch operation.

Advanced Data Filters

You can use advanced data filter to run search queries that contain complex filter expressions. You can configure advanced filters for Data Tables objects, QuoteV2, and QuoteV2LineItem object.
Perform the following steps to configure advanced data filters:
    1Select Advanced in the Data Filter tab.
    The Advanced Data Filter dialog box appears.
    2Provide the Filter Expression. Use MongoDB format to configure advanced data filter. For more information about MongoDB format, see https://docs.mongodb.com/manual/tutorial/query-documents.
    3Click OK.