Hi Everyone, I am trying to create the search to use with a mass update script to re-populate a field that was cleared. I was thinking I could easily use Maximum grouping on the sys notes date field but since the field was changed multiple times, New value is returning multiple results (i.e. Maximum grouping is not respected) . Any suggestions on how to create a search to only show the most recent change on a field based on system notes would be much appreciated.

Field was changed multiple times on the same date?

not on the same date so im not really sure why it isnt working either

Do you have criteria for the field in question?

so the value was cleared by the store value on the custom field being unchecked so the cleared value isnt record but the field is wiped

Hmmm - lemme see if I can figure something out.

great idea but no luck

Hmmmmm

I was also thinking of sorting in ascnding order by date but i dont think the mass update works synchronously

What type of record is this field on?

contact

So weird that the when ordered by doesn't work...i was messing about on item records using that and it seemed to work.

hmm let me try ungrouping the date

BOOM! Awesome!