Pipelines Advanced Query
Hi All, Does anyone know if I can use the '$' in the advanced query function to ask for the previous value of a field as a condition? I've tried: {$prev.10 .EX. 'Value'} {'$prev.10' .EX. 'Value...
Forum Discussion
Turns out {'{{a.$prev.status}}' .EX. 'Value'} isn't capturing the previous value. I've got the pipeline to be triggered when that status field changes, and I want it only to trigger when the previous value in the status field equals Value. However, after further testing I'm finding that the pipeline is triggering whenever the status field changes and disregarding the advanced query. Is this because there's something wrong with the query? Any ideas?
Thanks,
------------------------------
Daniel Johnson
------------------------------
Thanks,
------------------------------
Daniel Johnson
------------------------------
Another update:
I was on with support yesterday afternoon and we replicated the issue, which appears to be that you can't use the $prev language in an expression, which is unfortunate. Below is an example of the issue. In this case, we added the query expression in a conditional step because we weren't able to see the expression evaluate in the trigger. You can clearly see the condition is evaluating to true, even though the two values on either side of the equals sign are different. A = B is true?
------------------------------
Daniel Johnson
------------------------------
I was on with support yesterday afternoon and we replicated the issue, which appears to be that you can't use the $prev language in an expression, which is unfortunate. Below is an example of the issue. In this case, we added the query expression in a conditional step because we weren't able to see the expression evaluate in the trigger. You can clearly see the condition is evaluating to true, even though the two values on either side of the equals sign are different. A = B is true?
------------------------------
Daniel Johnson
------------------------------
- Daniel,
Did you ever resolve a way to do this?
------------------------------
Don Larson
------------------------------Hey Don,
I can't recall what the exact use case was here, but I'm now sure the issue was I was trying to evaluate a logical expression using a query expression. I'm sure if I used {% if a.$prev.status == a.status %}TRUE{% endif %} that the condition would have returned true if the values were actually equivalent, and false if they weren't. The query expression has to look like this: {'fid'.operator.'matching_value'}. Source
------------------------------
Daniel Johnson
------------------------------
