Forum Discussion
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
------------------------------
Melissa_Doran
4 years agoQrew Cadet
If it's the maximum from all records on the table, I would suggest using a 'helper' table.
You would relate all the contact records to the one single record on that table.
Related help table = 1 (Default this field to 1, so all contacts are automatically related to the only record on that table)
Then get the max version number through a summary up to the help table, then either
a) reference the help table directly in your pipeline
or
b) If the contact records are already part of your pipeline, lookup the max version number from the help table down to the contacts table.
------------------------------
Melissa Doran
Solutions Consultant
Quandary Consulting Group
linkedin.com/in/melissardoran
mdoran@quandarycg.com
------------------------------