I am trying to create a list of dockets that have 2006 transactions. Then I want to see only certain dockets.
So far my filter looks like this:


AND

(({Last Time/Disb Post Date} >=BEGINYEAR()),

{Docket #} <> " 10-04",
{Docket #} <> " 10-46",
{Docket #} <> " 40-04")

It works but....
I have tried to use a wildcard so that any docket numbered "10-*" is excluded but it doesn't seem to work. Is there a way to do that?
Do I have to show each excluded docket separately? (Can I make a list somehow - i.e.Docket #<> " 10-*, " 48-04"," 82-01" ?)


Thanks.

Hi Bal,

There isn't a concept of Wildcards with GridView functions - rather you need to apply a formula similar to what you would use with Excel.

The LEFT function takes the left-most characters from a string:
LEFT({Docket #},2) would take the first 2 characters.
LEFT(TRIM({Docket #}),2) would get rid of any leading/trailing spaces from the docket code and then take the first two characters.

There is a function called FINDANY that might be useful for your specific docket search:
FINDANY({Docket #},"10-04","10-46","40-04")
The result will be 1 if there are any matches or 0 if there are none. So you would have to use this in a manner like:

AND(
{Last Time/Disb Post Date} >=BEGINYEAR()
,
FINDANY({Docket #},"10-04","10-46","40-04")=0
)

Some tweaking of this may be necessary. Good luck!

Hello bal,

Here are another two ways to solve this problem:

1) Choose an unused field in the Docket record (Comments? Managing office?) and enter an indicator on the record if you want the docket included in the View. Then you can just test the contents of the field in the record to include/exclude the record.

2) Use the "GetNamedItem()" function to see if the docket is contained in a separately maintained list of docket numbers. The structure of the list would be:
Code:

---

[NamedItems]
10-04="Y"
10-46="Y"
10-48="N"
40-04="Y"

---

and the function call would be:

GETNAMEDITEM(TRIM({Docket #})="Y")

You can easily create the named item file by exporting the list of dockets to Excel and creatin the two entries there - finally saving the list as a CSV file.