Versions Compared

Old Version 3

changes.mady.by.user Hugo

Saved on

compared with

New Version 4

changes.mady.by.user Hugo

Saved on

Key

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

...

NameDescription
Datasource
  • Default Datasource
  • Custom Datasource
If the default datasource is selected, the custom JDBC settings below will be ignored.
Userview Key Name

When defined, additional condition will be appended using the value defined here as the parameter and the userview key value as the value.

Info
titleExample

SQL: SELECT category, count(category) FROM table1

Userview Key Name: type

Userview Key Value: val

Resultant SQL:  SELECT category, count(category) FROM table1 WHERE type = 'val'

When userview key value is defined, you may define #userviewKey# in your SQL query to have it replaced with the userview key value.

Info
titleExample

SQL: SELECT category, count(category) FROM table1 WHERE type = '#userviewKey#'

Userview Key

Name 

Value: val

Resultant SQL:  SELECT category, count(category) FROM table1 WHERE type = 'val'