Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
my problem is to search multiple values in the selected values of a field to activate conditional display
I can use instr() with getfieldselections() but it works with only one value. I have to find multiple values stored in a variable each value separated by a delimiter.
and another problem is that these values can have spaces and look similar.
e.g : the field may contain the values 'Mandatory' 'Not Mandatory'
any idea ?
I don't think so ..
the values selected must have all the values of the variable.
for example , if ValueList=Value1,Value2 i have to check that those 2 values are contained in the selected values of the field
with match(), i will know that 0 or 1 of the values match, but not if all match
Maybe with something like this:
count({< Field *= {'$(var)'}>} distinct Field) = substringcount('$(var)', ',') + 1
with the requirement that '$(var)' contained a valid list of field-values including the needed quotes which might be created with: replace('$(varTemp)', ',', chr(39) & ',' & chr(39)).
- Marcus