Hi all,
We are using a router control component that is retrieving its inputs and outputs from a matrix element. These inputs and outputs are linked to a table parameter that has the partial option enabled. As it stands, we are unable to select inputs/outputs above 1000 (the threshold for the partial):
Is there a way to ensure the matrix component is able to retrieve all inputs and outputs? Many thanks.
Hi Tiago,
It is possible to use (partial) tables in Router Control.
For partial tables, you need to add "FORCEFULLTABLE=true" to your inputs and/or outputs table filter.
Copy from Help:
"This filter can be used on partial tables to force the filter to go through all the pages rather than just the first. The filter should be followed by true or false."
Dynamic table filter syntax: https://help.dataminer.services/dataminer/DataMinerUserGuide/part_2/visio/Dynamic_table_filter_syntax.htm
Example:
Additional info
If you want to use parameter caching, then you have to copy the filters in the JSON file.
Copy from Release Note (22845):
"How to use parameter caching:
In the ClientSettings.json file (Global user settings, located in C:\Skyline DataMiner\Users\), add the parameter that needs to be cached.
- Note 1: these are the input table and output table parameters
- Note 2: The subscription filter must be a 1-1 match with the filter on the configured matrix. More information on this can be found on RN 21113.
- Note 3: When the file is updated manually, please sync the file from the DMA where you have changed the file.
This can be done in the Tools > Synchronize (file) module in System Center Component of Cube."
That works Matthias. Thank you :).