Filter list by multiple values for a field.

[John_Titor]

Hi guys,

Say I have a table, Listing users and what categories they are allowed to view.

UserID	Permission
Tom	"C"
Ben	"A"
Ben	"B"
Tom	"B"

And a table, which will populate the list looking like.

Name	Value	Category
Some Name A	1200	A
Some Name A2	1400	A
Some Name B	100	B
Some Name C	700	C

Now I want to filter the list based on all the categories the user is allowed to view. For example Tom should see all category B and C items. But this presents a problem because Im not sure how alpha would be able to go though the permissions table and filter the list with multiple values for the same field.

I can do a parent child list idea, have the permissions list filter on username, listing all categories for a user and when clicked on a category it filters the child list. But I want the list just filtered for all the user's categories at once.


Anyone have any ideas on how to do this kind of advanced filtering based on username and multiple values for one field?

[armasoft]

Re: Filter list by multiple values for a field.

If possible I'd suggest that users with permission A can view all records, permission B view any record B or lower, permission C any record C or lower. This way you only need one entry per user.

[Davidk]

Re: Filter list by multiple values for a field.

Your user permission table may look like what you've presented, but you're not going to show it that way in a List... are you? I'd guess you're going to show a List of Users... in your example it would display 2 rows... Ben and Tom. Is that right?

If so, then your List will be based on a view that combines the Permission values for Ben and Tom into a string.

Once that's done you can use the List Object .setFilter() to apply filters to the Name and Category fields of your 2nd List.

What SQL back end are you using?