multiple filters on recordset by user

[Bryan Harrington]

Hello all.. I'm working on an application that has a worklist of items for
users to work on. I'd like to, based on user security, to filter a worklist
based on between 1 and 8 items (i.e., location, category, alpha split).

That first part is no problem.. the problem is.. how to then allow that user
that is (for example) restricted to work 3 locations, to then further filter
that worklist to just one location?

Yes.. I can use the ADO filter.. but.. that won't work if you extend the
filter beyond one element (i.e., location and category).

Suggestions?

TIA

[Cowboy \(Gregory A. Beamer\) [MVP]]

You have two ways to filter: Server and Client.

In the Server methodology, you would firther filter by taking another trip
to the server and issuing the proper SQL command. You can also use tricks,
like ADO filters, et al. (NOTE: .NET allows for multiple filters on a single
DataView, or the creation of different views for different purposes).

In the Client, you have to loop through data to reduce it. JavaScript arrays
created by your recordset are the most common. Realize, this is heavy
programming, can tax the browser and leads to rather weighty pages.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"Bryan Harrington" <ne**@psacake.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hello all.. I'm working on an application that has a worklist of items for
users to work on. I'd like to, based on user security, to filter a worklist based on between 1 and 8 items (i.e., location, category, alpha split).

That first part is no problem.. the problem is.. how to then allow that user that is (for example) restricted to work 3 locations, to then further filter that worklist to just one location?

Yes.. I can use the ADO filter.. but.. that won't work if you extend the
filter beyond one element (i.e., location and category).

Suggestions?

TIA

[Bob Barrows [MVP]]

Bryan Harrington wrote:

Hello all.. I'm working on an application that has a worklist of
items for users to work on. I'd like to, based on user security, to
filter a worklist based on between 1 and 8 items (i.e., location,
category, alpha split).

That first part is no problem.. the problem is.. how to then allow
that user that is (for example) restricted to work 3 locations, to
then further filter that worklist to just one location?

Yes.. I can use the ADO filter.. but.. that won't work if you extend
the filter beyond one element (i.e., location and category).

Yes it will. It's only Find that's restricted to a single Field.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bullschmidt]

Perhaps this might give some ideas:

ASP Design Tips - Search For an Expression on Multiple Fields
http://www.bullschmidt.com/devtip-se...iplefields.asp

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!