1 Reply Latest reply on Oct 12, 2013 11:06 AM by deathrobot

    Join two lists to keep only common values

    deathrobot

      Title

      Join two lists to keep only common values

      Post

           I am using ExecuteSQL to set a global variable ($$result) to a return-delimited list of primary id's. I would like to use a field or two to pare down that list (for a few reasons, I don't want to include those fields in the original SQL statement). For example, if $$result is:

           id_01
           id_02
           id_03
           …
           id_25

           I might have a popup list where I can select a status value for a record (e.g. "in progress"). In that case, I would need $$result to be filtered down so that it only shows the ids that were part of $$result AND whose records have a status of "in progress." I thought of creating another list of all records with status "in progress" and then somehow merging the two lists so that only values that were on both lists remained. Is this possible? Or is there some better method?

           Thanks,

           Michael