Hi
I'm trying to use setvar with information from a table, where i want to limit the select using subscription filter for a different column to that which is displayed but this does seem to be limiting the selection. Below is the shape data, can anyone point me in the right direction, thanks
thanks
Hi
I tried creating what I think you wanted to achieve. To add a subscription filter in this way, it has to be added as a separate as shape data and not as part of the setvaroptions:
Also mind the two "=" in the second part of the subscription filter to have it filter correctly.
In my example I have used Card variables but that is not necessary, so that "Options" shape data is not necessary.
My setup had a table at PID 500 with a column 510 with number of which some were 1, and a column 504 with strings. If i used this, only the rows that had 1 at 510 had their strings in the dropdown.
Thanks Klaas, that worked.