FYI, this is a reposting of my post here: https://jace.pro/post/2019-09-06-mvrs-dependent-variables/
So It's been asked a few times, "How can I make my MRVS variables depend on other variables?"
The question has some caveats;
1. If the Variables are all in the same row, that's possible.
2. If the Variables are not all in the MRVS, it's possible but you need to add stuff to the MRVS.
Let's go over each of those.
So I'm going to deal with the 2nd one first. It's a design choice that you cannot make the MRVS variables dependent on variables outside of the row. The way around this is to add the variable to the MRVS and use that copy instead of the non-MRVS. I don't see another way around this.
Now that is dealt with the only time this comes up is if you seem to want to use a Lookup Select variable that re-evaluates based on other variables. I've written about this in the past here. If you're not familiar with it might be worth reading that.
Now I'm going to add reproduction steps cause I don't want to re-create things all over.
So lets decide out test. Let's load all .. notification devices for a user, based on a user variable.
1. On your PDI import my "ATF" scoped app.
2. URL: `https://github.com/jacebenson/atf.git`
3. Change scope to "ATF"
4. Goto maintain items, and look for "Test Item"
5. Open the variable set "Multi Row Variable Set"
At this point you should see a "question" and "answer"
6. Rename "question" to "user"
7. Change it's type to "reference" to `sys_user`
8. Rename "answer" to "device"
9. Change it's type to "lookup select box"
10. Set it's table to `cmn_notif_device`
11. Add a variable attribute of `ref_qual_elements=user`
12. Add a reference qualifer of \
`javascript: 'user=' + current.variables.user`
Now when I try this is just works.
Now say you don't want the Reference in the MRVS. Okay. I have a Reference variable on this test item already, it has a silly name, "Reference". But it works. Lets try that and change the variable attribute and reference qualifier.
1. Change variable attribute to `ref_qual_elements=Reference`
2. Add a reference qualifier of
`javascript: 'user=' + current.variables.Reference`
You'll notice this doesn't appear to work. It seems this is as designed 😭.
Further Reading:
- Community Post
- MVRS Documentation
- ref_qual_elements Documentation
