Forum Discussion

DavidLeech's avatar
DavidLeech
Qrew Member
5 months ago

Jinja Filter for Matching String then Max Record ID

Hello! I am trying to write a pipeline that will trigger upon creation of a new record, search the table for records that have the same location, identify the maximum value of another field for that location, and update the new record. I am stuck on the Jinja expression to accomplish this.

My record search conditions look like this: 

b.location equals {{a.location}}

b.related_id equals {{b | max(attribute='related_id') | attr='id'}}

However, I am getting the following error: Validation error: Incorrect template "{{b | max(attribute='id') | attr = 'id'}}": expected token 'end of print statement', got '='



------------------------------
David Leech
------------------------------
No RepliesBe the first to reply