I have confiforms entries tracking changes:
Key Sequence Other fields...
------ --------- --------------------------------------------------
value1 1 ... initial data for key=value1 ...
value1 2 ... updated data for key=value1 ...
value2 1 ... initial data for key=value2 ...
value2 2 ... updated data for key=value2 ...
value2 3 ... updated (again) data for key=value2 ...
The Sequence field could alternatively be a timestamp of when the change was made.
In a "Lookup and set value" rule, I want to pull the single most recent (i.e. "current", not historical) entry. E.g. something like:
Key:value1 AND Sequence:max(sequence)
-or-
Key:value1 AND ChangeTimestamp:max(ChangeTimestamp)
Is there filter logic that can get me to the single entry with the max sequence or highest timestamp? Thank you!
