PDA

View Full Version : Using env::roles-array in PRD


Andre Stricker
01-09-2012, 06:10 AM
Hi all,

I use env::roles-array in a where-condition of a SQL Query and that is actually working fine. But testing the reports in PRD is pretty much impossible because in PRD the username is "Designer" and that "Designer" has no role. So my question is: Can I set the user roles array prior to the Parameter GUI being displayed in PRD so the roles array can be in the creation of the parameters?

Many thanks
Andre
Taqua
01-09-2012, 07:37 AM
Look into PRD's installation directory. You should see a folder "resources" with a file "classic-engine.properties". Edit that file to set new values.
Andre Stricker
01-09-2012, 09:29 AM
Hi Taqua,

thanks for the quick reply. There is no way so set that inside PRD?

Cheers
Andre
Taqua
01-09-2012, 10:31 AM
No, not yet. Actually until now no one ever asked for it. So it might be time to file a JIRA case so that we can get it into the 4.0 release.

http://jira.pentaho.com/browse/PRD
Andre Stricker
01-09-2012, 02:21 PM
..done that. Thanks a lot again!

http://jira.pentaho.com/browse/PRD-3674
justyb11
06-05-2012, 02:41 PM
Look into PRD's installation directory. You should see a folder "resources" with a file "classic-engine.properties". Edit that file to set new values.

Taqua: Sorry to bring this back up, but how does one put multiple roles in? ie. Role1,Role2,Role3...

Thank you
Taqua
06-05-2012, 03:50 PM
Exactly like that: "Role1,Role2,Role3".

You set the "roles" environment property, and PRD parses that as CSV string into a array for the *-array accessors.