G
Guest
I appear to be encountering length limit problems on a few SQL filters.
Following is an example. Any assist or workaround would be appreciated. I
tried using the wildcard around an individuals name and it does not work.
Sample Filter:
Where I am selecting the Region = New York and various employees that have
been assigned to tasks that are not complete.
(((Region="New York")) AND ((tblTask.AssignedTo="Last Name1, First Name"))
OR ((tblTask.AssignedTo="Last Name2, First Name2"))) AND ((Not
tblTask.Status="Completed"))
Following is an example. Any assist or workaround would be appreciated. I
tried using the wildcard around an individuals name and it does not work.
Sample Filter:
Where I am selecting the Region = New York and various employees that have
been assigned to tasks that are not complete.
(((Region="New York")) AND ((tblTask.AssignedTo="Last Name1, First Name"))
OR ((tblTask.AssignedTo="Last Name2, First Name2"))) AND ((Not
tblTask.Status="Completed"))