URGENT: need to restore an old version of an object, but need QUERY to find the changed objects

Discussion created by SamahSohrab607228 on Mar 7, 2018
Latest reply on Mar 19, 2018 by Carsten_Schmitz
I ran an API call that modified about 691 objects and removed an old unused promptset. It turns out that when I removed the promptset it erased all the values of the other promptset that was part of that job object (guessing this is another bug with the api). I would like to get the old values of the promptset back into the job, but if I can't do that I need to revert all these objects to an older version.

Any ideas on how to first FIND all the objects that were modified? I've tried the OPUD table, but it doesn't have the old promptsets associated with the jobs.  I've tried the OH table, but too many jobs get returned that were modified around the same time via the api user. Is there a query that will return me the objects that HAD that missing promptset that I can then go and restore? Or even better some way to refill those values into the promptset?