2022
...
Panel |
---|
Definition |
"Trigger" is the a mechanism to activate/ Extract extract information from the source system for to use in Target the target system. In DBSync the Trigger section is as shown below, Trigger facilitates the
Trigger facilitates information to be read from the source system through a mechanism called Query Builder.
There are a advanced version versions of the query building builder 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.
Trigger section is as shown below:
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.
...
The below table demonstrates the operators supported and meanings of each operations .
S.No | Operator Name | Operator Description |
---|---|---|
1 | equals |
|
2 | not equals to |
|
3 | greater than |
|
4 | greater than equals |
|
5 | less |
|
6 | less than equals |
|
7 | like |
|
Panel |
---|
Advanced Query Builder |
The advanced query builder lets the user to build complex queries , the advanced query builder and contains three section sections: