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