Current Customers filtered by GL Department

A QueryPlus user (surprise!) had this request: ‘Show me all current customers assigned to a specific department’.

The fields for this query:

Filters:

Customer Open Policy Count - is not null

Customer General Ledger Department Name – as required

Of course, this query can be modified in many ways.

Posted by bwerner on Thursday, September 04, 2008 8:24 AM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

Customers who do NOT have a certain Policy LOB Here's an interesting query request: Show me a list of all my Customers who do NOT have an Act...Employee Access to 'Secured' Customers A QueryPlus user wanted a list of all the Employees who had access to the various 'secured'...Inactive Customers with Active Policies When I work with QueryPlus users in their AMS databases, I often see odd and/or conflicting data f...

The Daily(?) Querier