6 Replies Latest reply on Apr 6, 2017 3:00 PM by ezeitgeist

    Defining global variable AND excluding records

    ezeitgeist

      I am working with Virtual Lists and defining my global variable in my looping script.

       

      I have this at present when defining the global variable (outside "" not in actual script, just for containing in this post):

       

      "If (not IsEmpty ( $$VLContent ) ;  $$VLContent & ¶ ) &

      Contacts::First_name & " "  & Contacts::Last_name & "    " & TextColor ( Contacts::CompanyName ; RGB ( 120 ; 120 ; 120 ) )"

       

      IF I want to do all of the above BUT want to EXCLUDE all Contacts with the field Contacts::Type = "X" or "Y" (or conversely keep when Contacts::Type = "W" or "Z"), how can I script that in?

       

      NB: Working with Web Direct, in case there are WD-specific limitations.