1 2 Previous Next 16 Replies Latest reply on Jun 1, 2016 1:31 PM by pfroelicher

    find records comparing two fields (same record)

    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?

      Yours

      Pierre

        1 2 Previous Next