TMG-L Archives

Archiver > TMG > 2005-09 > 1125757899


From: "Cheryl Freeman" <>
Subject: Help needed with filter for people who have witness roles in particular location
Date: Sat, 3 Sep 2005 09:31:39 -0500
References: <000301c5af0a$f6971f40$6a02a8c0@Moms17>


How can I get a list of people who have witness roles on tags with a certain
location. I am trying to filter the PE to find people with either P or W
roles on tags containing a certain county:

I thought I could use this filter on the PE:

Any Event County Contains CAMDEN END

But the output of this filter doesn't include people who have witness roles
on events where the county is Camden.

I tried a LOP using the query by example tab, entering only "Camden" in the
any even location field and leaving the "consider primary events only " box
unchecked, but again, that gave me only a list of people with P roles.

Can anyone help? I really need this for a project I am working on this
weekend.

Thanks!

Cheryl Freeman

This thread: