Jinja Expression

Question

I have a Pipeline Search Step that returns an array of records.&nbsp; &nbsp;From that result I need to find the record id# of the one with most recent date field&nbsp; (not Date Created)

If my data set was this

RID&nbsp; &nbsp; &nbsp;Date
200&nbsp; &nbsp; &nbsp;15 Jan 24
68&nbsp; &nbsp; &nbsp; &nbsp;12 Dec 23
8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21 Jan 24

The answer that I am looking for is Record ID# 8 as that record has the highest value for the field Date.
If one of the Jinja / Python gurus has some insight it would be gratefully appreciated.
------------------------------Don Larson------------------------------

melissadoran3 · Answer

Hey DonI found a solution to this a while back - take a look my responses in this thread.&nbsp;I think it has what you need. :)&nbsp;
------------------------------Melissa DoranSolutions ConsultantQuandary Consulting Grouplinkedin.com/in/melissardoranmdoran@quandarycg.com------------------------------

donlarson · Answer

Melissa,

Thank you for the lead.&nbsp; I will test this today.------------------------------Don Larson------------------------------

donlarson · Answer

Melissa,

Of course I had to insert a parentheses error, but otherwise this is a great tip.

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

melissadoran3 · Answer

Awesome, glad it worked out! :)&nbsp;------------------------------Melissa DoranSr. Solutions ConsultantQuandary Consulting Grouplinkedin.com/in/melissardoranmdoran@quandarycg.com------------------------------

Forum Discussion

Jinja Expression