find records comparing two fields (same record)

Discussion created by pfroelicher on May 30, 2016
Latest reply on Jun 1, 2016 by pfroelicher

I have to isolate some records that have to be updated by a server side script.

In my MRP solution I need to find all records that the calculation field "c_number_on_hand"(an unstored calculation field)  is different from "number_on_hand" (a number field, updated periodically, to be shown in layouts and lists where the calculation update of c_number_on_hand would take to long).

Then I write the calculation value into "number_on_hand" for these records thereby updating the number field. 


I would like to isolate these records without creating a extra field (c_number_on_hand<>number_on_hand) and search for that, without creating a TO where one field unequals the other.

How is that done?