Can Dataview-Condition's Expression syntax work with a parameter and IN

Kinetic ERP
1

The situation I’m working on is we have a UD field on the ProjPhase table that when a user changes the value at one level the value should push down to all children of the Phase all the way down to set the same value, unless previously to something else.

I am trying to do this via a Dataview-Condition. I am setting a TransView parameter with a list of phases where we’d want to check for changes.

For example purposes assume my project has a phase A with two children B and C. Also phase B has a child D. If I set my Dataview-Condition Expression to ProjPhase.ParentPhase IN (‘A’,‘B’) the event will be called for phases B, C, and D. However when I make the Expression ProjPhase.ParentPhase IN TransView.TestParam where TransView.TestParam is set to (‘A’,‘B’) it doesn’t call the event. I also tried with ProjPhase.ParentPhase IN (TransView.TestParam) where TransView.TestParam is set to ‘A’,‘B’.

Is there some syntax change I can make to get this to work? If this would evaluate then I can make the parameter’s value be dynamically generated, which I’ve already proven I can do.

1 Like
2

Any chance you ever figured out how to do this..? :zombie:

3

Haven’t tried with that action but try:

ProjPhase.ParentPhase IN (?{TransView.TestParam})

The single ? will stop eval if TestParam is null and the curly braces denote a binding syntax that evals to the dataView.Column value.