Forum Discussion
Melissa_Doran
5 years agoQrew Cadet
I stumbled upon this thread last night while looking for a similar solution. I found something that worked after tons of trial, error, and googling. Here's a screenshot.
It takes the array of results returned in step B, looks for the one with the highest attribute for the field called "specificity_score" and returns that RID to a field in the action step. It's not exactly sorting results but if you were looking for the "earliest" record, you could set the attribute to a "created_date" or similar, and use a min() filter instead of max()
ex:
{% set desiredrecord = b|min(attribute="created_date")%}
{{desiredrecord.desired_field}}
 
------------------------------
Melissa Doran
Jr. Solutions Consultant
Quandary Consulting Group
mdoran@quandarycg.com
------------------------------
ChrisJefferson
4 years agoQrew Member
I get an error when I try and do this, it says there are too many results and I should use LOOP. (there are only 400 records from the search) 
A = Trigger
B = Search Results
C = Update Record.
I am trying to return the max version number (field) from the contacts table so I can use it in a Fetch JSON query so it limits the results returned from the external source.
Too obscure? :-)
------------------------------
Chris Jefferson
------------------------------
A = Trigger
B = Search Results
C = Update Record.
I am trying to return the max version number (field) from the contacts table so I can use it in a Fetch JSON query so it limits the results returned from the external source.
Too obscure? :-)
------------------------------
Chris Jefferson
------------------------------