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