2022
...
Panel |
---|
Definition |
"Trigger" is a mechanism to activate/Extract extract information from the source system for the to use in the Target target system. In DBSync, the Trigger section is as shown below, Trigger
Trigger facilitates information to be read from the source system through a mechanism called Query Builder.
There are advanced versions of the query building builder mechanism, where complex queries - involving across multiple objects - can be created. The result set can be viewed at run-time, making it convenient for users to change 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 to very complex queries. The query builder can be used to build simple query, mostly based on a single object.
...
The below table demonstrates the operators supported and meaning of each operation.
...
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 build complex queries and contains three sections:
...