Clear a VL using a DDE (pre-6.5)
A popular request in ArcherLand is to be able to clear the selected value(s) from a values list field through a DDE. In other words, if I have a DDE Rule where when I select value “X” from VL field A, I want an Action to remove any selected values from VL field B. This is especially useful if selecting “X” in A causes B to be hidden - we want to not only hide B, but clear out whatever had been previously selected.
According to RSA this could not be done through a DDE until version 6.5. As it turns out, this is not quite true. How is this possible?
Kudos to whoever figured this out - I can't take credit. Here’s the magic.
- Create an additional value for the target VL field, say Set to Null, and save the value and VL
- Create an action that sets the value to Set to Null and save the action
- Edit the target VL field and inactivate Set to Null (save the value and VL)
Now the action will show that the value is being set to nothing (don’t try to save the action because Archer won't let you). Amazingly enough, it actually works – the value is cleared. An added bonus is that when you eventually upgrade from your Jurassic Archer version, you would already have DDE actions in place that you can just update to set the value to No Selection (and get rid of the bogus value).
The caveats. As far as I know, this technique is not RSA supported. I have only tested this in 6.4 SP1 P1. I have no idea if this works due to a bug that is not found in any other version. If you are on 6.5+, use the No Selection option that is now available.
- Community Thread
- Forum Thread
- RSA Archer
- RSA Archer Suite
- Tips and Tricks