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

While using the betweenpanel, the user has the possibility to enter values as letters or numbers.

 

Format

#between(Unique-tabtitle;table.attribut;number of lines;or|and;text|zahl)

 

 

#between(Mileage;car.mileage;1;and;zahl)

 

 

where the values mean:

  1. Unique Tabtitle
  2. table-attribute used
  3. number of lines to generate at the beginning
  4. mode (and or or) to generate the between-SQL-fragment
  5. select 'text' if the attribute contains text and 'zahl' if the content is numbers

 

This is from the second example in our demo-DB. We use this to define the mileage range we'd like to have. If we enter between 5000 and 10000 our generated query-fragment would look like this:

 

 

( car.mileage BETWEEN 5000 AND 10000 )