AnsweredAssumed Answered

Join two lists to keep only common values

Question asked by deathrobot on Oct 12, 2013
Latest reply on Oct 12, 2013 by 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

Outcomes