Forular View Selection not working as intended

well, i have view selection based on the @UserName of people using that view.

works like a charm.

but now i wanted to have specific people see all document, not just those with their name in some field using their ACL Roles

so the view selection changed from:

SELECT some_field=@UserName

to:

SELECT @If(@IsMember(“[Support]”;@UserRoles);@All;some_field=@UserName)

but now this selection allways returns results based on the @UserName and not @All.

okay, just to make sure, the role really is named like this since i used it on pages with computed text. and in those pages it works fine.

And yes - the user i used also has this role :wink:

Subject: Forular View Selection not working as intended

slap me around!

@UserRoles

This function does not work in column, selection, mail agent, or scheduled agent formulas.

seesh, someone gimme some glases :wink:

Subject: Formula View Selection not working as intended

You can achieve the same result with the release of version 6 using @SetViewInfo:https://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/b8223c648179f8458525715a0050caeb?OpenDocument