Jump to content
Changes to the Jaspersoft community edition download ×

User Profile Attribute in .jrxml report SQL query. LoggedInUserAttribute


webapps30

Recommended Posts

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 Controls
Table 4-1 Built-in Parameters for Query-based Input Controls

LoggedInUser   ....
LoggedInUserAttribute_<attribute-name>

If there is no match, the parameter is empty.
This parameter is only available if it is defined in a query
or as a report parameter.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


http://community.jaspersoft.com/questions/541574/user-parameter

http://community.jaspersoft.com/questions/523017/referencing-logged-user-attributes-sql

http://community.jaspersoft.com/questions/530433/how-use-looggedinuser-getting-role


http://community.jaspersoft.com/questions/532644/ireport-row-level-security
keywords API: Jasper Reports Library API   IQueryManipulator





There are Parameter available which provide this data:    ?? Old Post ??
http://community.jaspersoft.com/questions/532644/ireport-row-level-security

?? Old Post ??   No Replies
https://community.jaspersoft.com/questions/543844/getting-profile-attributes-ireport

keywords API: Jasper reports API  MetadataUserDetails
http://community.jaspersoft.com/wiki/how-access-user-profile-attributes-report
 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...