Hi i'm trying to resolve an parameter of a table based on the dynamic value in other table. I think i should use the resolve with the dynamic table filtering and ParameterSubscriptionFilter
My shape data is now:
Element: dma/eid
Parameter: 3402
ParameterSubscriptionFilter: RESOLVE=3506,3500
So how to do i select a specific row for the resolve? So that parameter 3402 is the one to show where the key is based on the value parameter 3506 of a specific row in table 3500
Jarno Lernou [SLC] [DevOps Enabler] Answered question 5th August 2021
Maybe to add some more clarity a bit of the tables:
Table A (id: 3400):
|Number (PK)(id: 3401)| Label (id: 3402)|
| 39 | FancyName |
| 40 | FancyName2 |
| 65| FancyName2 |
Table B (id: 3500):
|Number (PK)(id: 3501)| CI (id: 3506)|
|60| 39|
|61| 39|
|62| 40|
|63| 65|
What i want to do is make a few shapes that will display the Label of tabel A based on the row where the row id is the value of the CI value of table B