Forum Discussion

Qrew Elite

3 years ago

Jinja Max Value of a Field

I have a Search step that looks at all the child records for a parent. In that Search I am collecting a single Date Time Stamp Field. Then I am evaluating the field to get the max value using ...

Pipelines

DougHenning1
3 years ago
I believe max returns the whole object, so you would need to grab the single attribute from that object:

{{ a | max(attribute='child_table_date') | attr('child_table_date') }}

Hope that helps!

------------------------------
Doug Henning
------------------------------

DougHenning1

Community Manager

I believe max returns the whole object, so you would need to grab the single attribute from that object:

{{ a | max(attribute='child_table_date') | attr('child_table_date') }}

Hope that helps!

------------------------------
Doug Henning
------------------------------

DonLarson

Qrew Elite

3 years ago

Doug,

Where did you get the answer?

I got the expression from here:

https://helpv2.quickbase.com/hc/en-us/articles/4471048652308-About-Jinja-

I substituted the field name in the attribute and got the data returned. Your solution is much more powerful now that I think about it.

A business case would be find the largest value for the currency field and then tell me who the record owner is. It opens a whole host of possibilities similar to field queries.

I would like to see what the other options are and how to use them. I would never have guessed to put in another attribute or to abbreviate it as attr.

------------------------------
Don Larson
------------------------------

DougHenning1
Community Manager
3 years ago
Hi Don, glad that worked! That help page lists some of the supported filters but not all. At the top of that page is a link to the Jinja documentation. From there are all the Jinja built-in filters: https://jinja.palletsprojects.com/en/2.11.x/templates/#list-of-builtin-filters.

Since filters are chained, the output from one is the input for the other. In your original Jinja it returned the entire record but you needed a single attribute from it thus the attr() filter. Chaining combines multiple statements into a single:

{{ a|max(attribute='child_table_date')|attr('child_table_date') }}

is equivalent to:

{% var maxrec = a|max(attribute='child_table_date') %}
{{ maxrec | attr('child_table_date') }}

------------------------------
Doug Henning
------------------------------