[solved] optional/dynamic/somewhat filter problem

[VisioX]

Hi there!

I try to filter down a list-report, but the result isn't what i am looking for.

Ok, here is my situation.

"Equipment Master File" - Location, Eqp.Number, Cost
"Location File" - Location, Region
"Location" is the relationship in Frameworkmanager

List is grouped by Region. That works so far.

Now I want to filter the regions down by the users access.
I have a file which looks like that: username, region code, master authority
Every user can have multiple records, one for each region he has access to; or he has access to every region because he has 'Y' in Master-Authority.

I try since two days to figure out how to do that, but can't find a solution.

We are running on 8.3 + latest SP
Content store is MSSQL

Thanks,
Guido




I found the solution....
1) do not use relationships in FM
2) type everything in SQL and attach it to a query
3) use variables like CAMID and #sq($account.personalInfo.userName)# and a lot of IF and ELSE