Data selection

There is a tool, that creates a GUI out of a SQL-file having some additional commands in. Read here how this works

The criteriabox allows to select elements while checking them.

 

Format

 

#criteriabox(unique-tabtitle,tableattrbiut in;filename)

 

 

To create such a panel, we add the criteriabox-macro to our sql-statement:

 

#criteriabox(Function;function.id in;employee-list.function)

 

 

where the values are:

  1. unique-tabtitle
  2. table-attribute
  3. filename used to create the items

 

the file employee-list.function looks as follows:

 

Sales;1
Marketing;2
CEO;3
Technic;4