Using a SELECT statement in a value
Use select statement in the Value field
When you want to describe a dataset using SQL, you write a SELECT statement. The SELECT statement contains a complete description of the dataset you want to get from the database.
In the Edit templates window, in the Setting object values section below, enter any SELECT statement in the Value field.
We have defined a select simple statement for the ident field:
When using a template, the program will write the result of the SELECT statement to the ident criterion:
In the Ident codebook, we have the LARA3 Ident with the name TENT LARA 3:
