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.

...

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 contains three section 

...