I have 2 datasets:
and 2 Controls linked to datafields:
Set1 UUID ← Only relevant values are shown according to the Set 1 category control.
The controls are linked to Parameters UUID and Category respectively.
I want to filter on the category of dataset 1 and pass the resulting UUIDs from set 1 as a filter on dataset 2.
It is possible if the resulting UUIDs are less than 1000. since i can ‘select all’ in the UUID control which is then passed to dataset2
however for more than a 1000 results this doesnt work (no select all option). Also it would be great if the select all step was not needed and the relevant value filter is passed automatically.
I realize joining the datasets would give the desired result as well. however this is not possible due to the size of them. (Error Type: DATA_SOURCE_CAPACITY_EXCEPTION). Also it would unnecessarily fill up SPICE.