Having some issues with running a saved search aga...
# general
s
Having some issues with running a saved search against System Notes fields. Basically I am trying to get the maximum date of a field change and the new value of said date. Keep getting multiple results.
c
Can do something along these lines: In your criteria add the type of record you're going to be looking at. Then through the "System Notes fields..." add the field you're looking at seeing the changes. Then also add System Notes fields... Type = Change. In your results, add the Document Number with "Grouped" summary type, add System Notes Fields... Date with "Maximum" summary type. Then add System Notes Fields... Old Value and New Value, both also with "Maximum" summary type. For the Systems Notes... Old Value and New Value lines, in the "When Ordered by Field" add System notes fields... Date for both of those lines.
s
Thank you so much! I think I was just missing the when ordered by portion.