SEARCHVAL
- SEARCHCOL (in PARAM)
- SEARCHCOL (Row 1)
=mandatory in row 1
Parameter |
Mandatory/Optional |
Value (example) |
Comment |
|
|---|---|---|---|---|
FORMS |
REPORT |
|||
SEARCHVAL |
<object value(s)> |
Mandatory parameter in row 1. This parameter should define the search object values for each row. The object values need to be valid values connected to the object stated in SEARCHCOL. |
||
SEARCHVAL is a mandatory parameter in row 1. In this column, the search object values for each data row should be defined. The values that are defined need to be valid values connected to the object stated in SEARCHCOL (in the same row or in PARAM). The search object values can be defined as an interval, one specific value, several specific values, and so on. When the SQL queries run, then the object values specified will be added to the where-clause for that particular row.
If the document has the EXPAND parameter in column A, then a new row will be created for each object value stated in the SEARCHVAL column. However, if the row is NOT defined with EXPAND, then only ONE row will be created for the defined value(s) in SEARCHVAL.
If the selections for the row includes more than one object, then the second object and object value need to be defined in the SEARCHVAL column. In the example below, cell D23 includes the search values 101..109(ITEMGRP:1*), which means that the search values for the row is ITEMs between 101 and 109 and ITEMGRP starting with 1. It is NOT possible to add several SEARCHCOL and SEARCHVAL columns in the template.