Hi bal,

There is a hard limit of the number of characters in a filter (it's large, but obviously you've hit it here).

Would it be possible to use the "comment" field in the docket to identify the files you want to look at? Or perhaps one of the staff member codes? For example, if you placed the string "XYZ" in the comment of the dockets you wanted to select, then you could just use the formula:

FIND("XYZ",{Comment},1)<>0

to identify the file.

Another way to select items from an arbitrarily long list is to use a "NamedItem" file. Use Edit | Named items to create a list of the dockets with the letter "X" after the docket number, with the "Value" for the named item as the letter "X". Then use the formula:

GETNAMEDITEM(CONCATENATE({Docket #},"X"))="X"

GETNAMEDITEM(s) looks up a string in the named item file, and returns the value on the right side of the equals when a match is encountered. (Don't forget to save the "Named Item" file after you have created the list.)

The "Named item" file is a simple text file that can be editied with Notepad if you desire. Here's a named item file with a single entry: