Multi-level filtering question
nc
ncouch at mail.airmail.net
Sun Jan 11 12:59:03 EST 2004
I have a database which I have extracted a finite set of attributes
from (call them A,B,C, and D). They are output as four lines of text
for each record, for example:
AttributeA: DN=Smith, John,OU=Users,DN=domain,DN=Com<CR>
AttributeB: MTA=MSEXC210<CR>
AttributeC: MDB=MSEXC210,Server=MSEXC212<CR>
AttributeD: MailAddress: Jsmith at domain.com<CR>
I have been able to filter on any one of these attributes without a
hitch. Even better since the database I am querying against can be
several hundred MB in size the filter query is very fast, oftentimes
taking less than a minute to extract for the query. The queries for
this same job without the filter function took over 45 minutes in some
cases so thank you developers!
Anyway, getting back to my question. What I would like to do is filter
for multiple aspects of each record (assuming several thousand records
and each record having four lines with each line ending with a CR). I
have been able to run a multi-level filter against the database and
that works great, but what I have not been able to solve yet is to run
the multi-level filter and have it extract all four lines of the
record. Going back to the entry above, say I wanted to do a query that
would find all records where AttributeB: MTA=MSEXC210 AND where
AtrributeC: MDB=MSEXC210,Server=MSEXC212 were present then pipe all
four lines of each record that fit the criteria out to a text file or
output field.
I hope this is clear as to what I am trying to accomplish.
If you have any questions please let me know.
Regards and thanks.
Nate
More information about the use-livecode
mailing list