AnsweredAssumed Answered

Defining global variable AND excluding records

Question asked by ezeitgeist on Apr 6, 2017
Latest reply on Apr 6, 2017 by 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.

Outcomes