3.3 Create a Query Predicate
A Query Predicate helps you to query conditions for data extraction from the data table and allows you to view that data in Salesforce. This allows you to filter data according to your query parameters and tells Overcast which subset of data to pull from the external system.
1. On your Integration Scenario, under the Query Predicate section, select New Query Predicate.
(2).png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy83NDg4LzMyMTM5L2NrZmluZGVyL2ltYWdlcy9xdS8yMDIwLTA3LTAzXzEzLTI1LTI3KDEpKDIpLnBuZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTc2NTY3MDE3OH19fV19&Signature=lZw5M3o0dwEEldPOqgx0WLwRcx6BVoA2Teahfs-RAZP5nF-vAvf7D~Z5TogEQQ-2OqkHzSrYoYXzVB9s9ezVeklgL0T7qvtP~4jH~TOSG5IGPzkIE3DbKYr4MMGeQY5H7MuBDZOs58VVYnR2nLZIlsCUpqIZym6txwganLbUoDw3IOZvbNh63SNxtTMOykg64ooXSyHcNC6Wi2rlJQ4zspihwx5FYl3A~1sy9IOjt1-JLAf-8oinas6EY5C9W1DojeasMfnR80B03oLDDi9cEmuWuCzPKIFugX2Rd5cEihHr2Lb87hgJKMmDMf8XMNYXzUVvvIc4OSLV2mmN1Q9wGw__&Key-Pair-Id=K2TK3EG287XSFC)
2. Enter a Query Predicate Name that will allow you to identify this group of criteria in a later step.
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy83NDg4LzMyMTM5L2NrZmluZGVyL2ltYWdlcy9xdS8yMDIwLTEwLTIxXzExLTQ5LTQxKDEpLnBuZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTc2NTY3MDE3OH19fV19&Signature=ZfuRh0Wnt8q2nxT0SeXYd8yA0~WPDDcDM4QBg9wXrj7KoO9wcSBxFr-vtu3r2RPntBBaJ-mPdSNFXQcPcV1MI4dIknM9wHvmzpetdU5mp60khDQ8vliUmX7DXj0xIoKzXhNvBKO8yxlPcySqeBoiNh-QkJ~KV7CHGCTA1teRgMu-FWIZJp6SJzbNUdYrfKhr2DeXX5KH6SEqMUD8AlJBvzUuBbFNt2rhEUAzJV8F4ja7WDTtPxmOSWj3eKz9MEu~lHgIq~LYAJ6SSpSiHqbrKZ4fDCrrcdyzHkFvOmifY8uA6MvN4xtkPcX0zOoqB4leRt~saGkIIhID3UtaO5pbyA__&Key-Pair-Id=K2TK3EG287XSFC)
Select the Fields and enter the corresponding Operator and Value to complete the filter criteria (1). Enter the Filter Logic for the Criteria (2). Select Save (3).
Filter Logic must be entered when inputting more than one field, even if this is "AND" criteria. If not, the Query Predicate will not save.
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy83NDg4LzMyMTM5L2NrZmluZGVyL2ltYWdlcy8yMDIwLTEwLTIxXzExLTUwLTEwKDEpLnBuZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTc2NTY3MDE3OH19fV19&Signature=GDGVWt8DQgM~Q8W9WPGC0y7FSS-EE8895C~WSlYKIdNOU8C-xpXmGITqCifAKOM4Ub~beYjhFYxF9rZYL3vaJGm8HWaf44LxCEUbnSqvFffNoj0~AoP6AlFLZZjE7viaFFwgBsx-LqP~Iai3nvPt6IqKAeaIew3h8oI~LHpeFLDS5QY~wA2xv2SZXsa8FWLdEFTV-DPrk9C8s-CrDvtfnNeNHSeYNsBvhVeBvD4f~gyPpGUtc9EHEB-Jj8ndr0cAATip6JL~giMoi7orLvlhRR~Y5f9wpJec9fkV~gbhjUxEOxUAfYDqysn66qgknMKdi2y2xRN7DjYOatD2Xqc0mw__&Key-Pair-Id=K2TK3EG287XSFC)
3. On your Data Synchronization Integration Scenario, select Run.
4. Ensure the Scenario and Scenario Input is correct, and that the Action Type is "Run". Click Run scenario.
5. You will land on the Monitoring Tab where you can see Scenario Executions. Review to see if the Status displays the green check icon.
For Data Synchronization, you can expect to see two Scenario Executions: One for Read and one for Mapping.
6. Open your Account Tab to see the List View of records matching the criteria of your Query Predicate.
7. Navigate to an Account Record in Salesforce. The fields you selected during
Object Mapping (Step 3.2) will be inserted on records matching the criteria of your Query Predicate.
You must have the fields visible on the page layout in Salesforce, in order to see the data on the record.
Next, you will set up a Scheduled Job.
