2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel

Panel
Definition

"Trigger" is the mechanism to activate/ Extract information from the source system for use in 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 of query building mechanism , where complex queries involving across multiple objects are created , result set can also be viewed at run-time making it convenient for the user to change the query as and when. 

 

Panel
Query Builder
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 on a single object.

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

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

S.No

Operation Name

Operation Description

1

equals to

 

2

not equals to

 

3

greater than

 

4

greater than equals

 

5

less than

 

6

less than equals

 

7

like