meta data for this page

Parameters at runtime

Usage

Parameters are typically used by Vigilens to filter a subset of data when creating the report: for a particular company code, for a date or a date range, etc…

Creation

Parameters can be created in the screens that can use them, for example in conditions on joints or extractions according to criteria.

Reuse

In all the dialog boxes that accept parameters, any parameter already defined can be reused:

Mapping

During the creation of a new query, there is the parameter assignment screen :

This is where it's done:

  • mapping the parameter passing between a calling query and a subquery
  • the choice of the order in which all parameters are entered

We can go to a subquery:

  • or a fixed value (single value, range or list of values)
  • or the value of a parameter of the calling request.


You can of course reuse the same parameter several times. For example, if we have several subqueries that have a company code as a parameter and/or a criterion about the company in the calling query, it makes sense to reuse the same parameter each time. Thus, at runtime, we will have a single entry of this parameter.