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
Got some help from customer service on this one. Let's say field 10 is a text field called Status, then the correct syntax in the trigger query would be:
{'{{a.$prev.status}}' .EX. 'Value'}
I was told you have to use the written form of the field and not the field ID number.
------------------------------
Daniel Johnson
------------------------------
{'{{a.$prev.status}}' .EX. 'Value'}
I was told you have to use the written form of the field and not the field ID number.
------------------------------
Daniel Johnson
------------------------------
- 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
------------------------------- 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
------------------------------- Daniel,
Did you ever resolve a way to do this?
------------------------------
Don Larson
------------------------------
