webapps30 Posted April 22, 2014 Share Posted April 22, 2014 I would like to use a Logged in User Profile Attribute in the report SQL. ( yes, another example of row-level security )My initial test failed; just showing a User Profile Attribute in the title of a report. I believe you should create a Parameter for each attribute, which I did. But there was no way to define it, using the expression editor. I've found a few things from the .pdf manual set, and reference links (many of which are old), which I will include. The topics are relevant, even if the links they reference are dead links.btw - Where is the Jasper Reports API published ? ------ From the Server Admin Guide ------4.4.2 Built-in Parameters for Query-based Input ControlsTable 4-1 Built-in Parameters for Query-based Input ControlsLoggedInUser ....LoggedInUserAttribute_<attribute-name>If there is no match, the parameter is empty.This parameter is only available if it is defined in a queryor as a report parameter.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~http://community.jaspersoft.com/questions/541574/user-parameterhttp://community.jaspersoft.com/questions/523017/referencing-logged-user-attributes-sqlhttp://community.jaspersoft.com/questions/530433/how-use-looggedinuser-getting-rolehttp://community.jaspersoft.com/questions/532644/ireport-row-level-securitykeywords API: Jasper Reports Library API IQueryManipulatorThere are Parameter available which provide this data: ?? Old Post ??http://community.jaspersoft.com/questions/532644/ireport-row-level-security?? Old Post ?? No Replieshttps://community.jaspersoft.com/questions/543844/getting-profile-attributes-ireportkeywords API: Jasper reports API MetadataUserDetailshttp://community.jaspersoft.com/wiki/how-access-user-profile-attributes-report Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now