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
Hi Gerwin,
As far as I know, I see two possibilities. In both possibilities, I use the feature to dynamically create shapes based on rows (ref. DM Help). Also, the overal group shape is equal in both approaches, i.e. I configure my shapes to be generated from Table B and I'm sorting them based on the PK.
- Possibility 1: Param placeholder
You can get to the end result by just making use of the param placeholder (ref. DM Help). In recent versions of DataMiner, you can simple put the placeholder ([param:*,502,[param:*,1510,[tableindex]]]) in the text field of the shape and it will display the content of it.
2. Possibility 2: Subscription filter
In this approach, I use the feature to retrieve and show the value of a table parameter using a subscription filter (ref. DM Help). For this you need two shape data fields on your child shape:
Parameter: [param:*,502,]
SubscriptionFilter: value=501 == [param:*,1510,[tableindex]]
End Result:
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