Conditions to control on-demand data
When working in the installed client, you can specify to load data from data connections or from information links on demand, based on different conditions.
The on-demand loading can be controlled by specifying one or more conditions that must be met for data to be loaded. See Configuring an on-demand data table for some examples.
Conditions can be set in a number of different ways. For example, they could be determined by the value of a property or an expression, or by the values of the filtered or marked rows in a column from another data table. If a selected data connection or information link has been configured with required prompts or parameters, then these will automatically be required parameters for the on-demand loading and you must specify a condition using the Define Input button for each required parameter.
If desired, you can apply a transformation to the data prior to loading. While the transformation will be performed on the data corresponding to the condition only, you might gain some performance by doing the transformation here rather than conditioning an entire information link directly.
Examples of conditions
What to control on-demand loading | How to set it up |
---|---|
Marking in another data table |
|
Filtering in another data table |
|
A range of values defined by the min and max values from the current marking or filtering, for a selected column |
|
A document property value |
|
An expression |
|
All values over (or under) a certain
limit, for example:
Sales > 1000
|
|
The data retrieved for the on-demand data table can be based on a combination of all of the examples above.