Page History

...

"Trigger" is the a mechanism to activate/Extract information from the source system for the use in the Target system. In DBSync, the Trigger section is as shown below, Trigger facilitates the information to be read from the source system through a mechanism called Query Builder.

There are a advanced version versions of query building mechanism, where complex queries - involving across multiple objects are created , - can be created. The result set can also be viewed at run-time, making it convenient for the user users to change the a query as and when needed. 

DBSync offers a very convenient way of building queries - ranging from simple ones to very complex queries. The query builder can be used to build simple query, mostly basing based on a single object.

1. Initially, when the a user lands on this Workflow detail page, s/he /she will have to select the Data source and the object on which the query is to be built.
2. HeS/She he can add N number of condition conditions for the query being built by clicking on "Add New Condition".
3. For adding a condition, a user has to select the a field, select the an operator and, then enter the value with in ' '
4. Basing Based on the number of conditions added, the filter logic is auto populated and by chance if he/she wishes to . However, a user can change the logic they can do by entering the value manually entering a value. 
5. Clicking on the preview button - adjacent to the filter logic - will show the result set in Query Result section.

The below table demonstrates the operators supported and meanings meaning of each operations  operation.

The advanced query builder lets the user to build complex queries , the advanced query builder and contains three section sections:

1. Schema , which  - loads up the whole of source schema with whole table, . It can be expanded to show the columns with respective data types types. 
2. Query Builder , where query will be - Queries are pre loaded for Templates loaded from Template library and a . A user can write their own queries too.
3. Query Result , which will show the result for   - Shows result of relational data models and for XML structures the . The data is shown in a tree format.