Dynamic Queries

How to find the "Dynamic Queries"?

To find Dynamic Queries:

        1. Go toTables

        2. Then-Dynamic Queries

Now you can see the dynamic query list:

Here you can see, create (Add (+)), see data (Details (» icon)), edit (Edit (pencil icon)) and delete (Delete (bin icon)) Dynamic Queries

 How to create a new Dynamic Query?

New dynamic query dialog

 To create a new Dynamic Query, 

1. Click on Add (+);

2. In the dialog table:

    2.1. Enter a name;

    2.2. Choose an object;

    2.3. Add columns (Columns (+))

    2.4. Join other objects;

    2.5. Now you can see and add other parameters in the column (Columns (+))

Pridėti (dialogas)

    2.6. You can also sort data (Sort (+)):

        2.6.1. Click on Sort (+)

        2.6.2. Choose a column and direction (Ascending or Descending)

        2.6.3. Click on  Confirm

3. Click on Create

Now you can see your dynamic query: