Forum Discussion

DonLarson's avatar
DonLarson
Qrew Commander
3 months ago

Jinja Expression

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

If my data set was this

RID     Date

200     15 Jan 24

68       12 Dec 23

8         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
------------------------------

4 Replies

  • Hey Don
    I found a solution to this a while back - take a look my responses in this thread. 
    I think it has what you need. :) 



    ------------------------------
    Melissa Doran
    Solutions Consultant
    Quandary Consulting Group

    linkedin.com/in/melissardoran
    mdoran@quandarycg.com
    ------------------------------

    • DonLarson's avatar
      DonLarson
      Qrew Commander

      Melissa,

      Thank you for the lead.  I will test this today.



      ------------------------------
      Don Larson
      ------------------------------
      • DonLarson's avatar
        DonLarson
        Qrew Commander

        Melissa,

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



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