Error 'a value in the filter ... is too long'

gazpacho

Hello

I use a function to dynamically fill a code variable (length 250) with certain salesperson codes (for example, it returns the variable LocCodFiltervalue with value '100|150|180|200|210'). Then, I want to use this value as a filter on the salesperson code field in the interaction log entry table. But when I use SETFILTER("Salesperson Code",'%1',LocCodFiltervalue), it returns the error message

'a value in the filter "100150|180|200|210" in the salesperson code field in the interaction log entry table is too long for the field type." Type Code 10.

What am I doing wrong here ? Or is there a better way ?

Best regards

Josh

gazpacho

Solved: removed the '%1' did the trick. Don't know why, but it works now !

Thomas_Hviid_Thorn

Hej Gazpacho,

As far as I know, it's quite simple:

- using SETFILTER(field,'%1',Text)
nav expects Text to align to field in type/length.
That is Text is supposed to hold a value valid for field.

- using SETFILTER(field,FilterText)
nav accepts that FilterText holds a filter .
That is FilterText is supposed to hold a filter valid for field.