Filter

Filter settings allow you to enable automatic data ordering by primary key and to limit the maximal number of rows to import.

 

Add ORDER BY using primary key columns

In the Filter section of the Visual Query Builder, a sorting order can be added or removed for the imported data. By default, data is sorted by the primary key column. Clear this check box to remove sorting from queries.

 

Add ORDER BY for Relational Database Management Systems (RDBMS) only

Select this check box to disable sorting of data retrieved from non-relational data sources.

 

Maximum row count

The setting determines the maximum number of rows to import. The default value is 0, which means unlimited.

 

DateTime picker editor default value

Determines the default datetime value selected when you open datetime picker: