Versions Compared

Old Version 5

changes.mady.by.user Gabriel Wong

Saved on

compared with

New Version Current

changes.mady.by.user Gabriel Wong

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NameDescription
Datasource
  • Custom Datasource - setup to connect to an external database, has an additional configuration.
  • Default Datasource- connect to the Joget database.

By selecting Default Datasource, the database your Joget is currently using will be selected.

Custom JDBC Driver

Custom JDBC Driver. This field is required when Custom Datasource is selected in Datasource above.

Example: com.mysql.jdbc.Driver

Custom JDBC URL 

Custom JDBC URL. This field is required when Custom Datasource is selected in Datasource above.

Example: jdbc:mysql://localhost/jwdb?characterEncoding=UTF8&useSSL=false

Custom JDBC Username 

Custom JDBC Username. This field is required when Custom Datasource is selected in Datasource above.

Custom JDBC Password

Custom JDBC Password. This field is required when Custom Datasource is selected in Datasource above.

Info
titleTest the connection parameters

Click on the "Test Connection" button at the bottom of the page to quickly test out your configurations.

TableChoose a Table from the database as a source to retrieve data.
Joins Form Data Table

Joins Form Data Table

FieldDescription
Join TypeCondition type to fulfil.
TableTarget table to join with.
ColumnField ID from source form to set as option label. 
Join ColumnField ID from source form to set as option grouping value.
Primary Key

Define the primary key column.

By default, it should be "id".

Caching

NameDescription
Cache Row Count?

Enables caching of row count queries to improve performance and reduce database load.

Configuring Cache Time-to-Live (TTL)

Appears only when Cache Row Count? is checked. Defines the cache validity period in seconds (default: 3600). After expiry, a new count query is executed.

Advance

Filter

NameDescription
Filter Conditions

Filter Conditions

Name

Description

Join Type
  • And
  • Or
Column

Table Column ID

Operator
  • Equal
  • Not Equal
  • Greater Than
  • Greater Than Or Equal
  • Less Than
  • Less Than Or Equal
  • Like
  • Not Like
  • In
  • Not In
  • Is True
  • Is False
  • Is Null
  • Is Not Null
ValueFilter value
Extra Conditions

Additional condition(s) for filtering the data set. HQL is expected here.

...