how to use LoggedInUserAttribute_<attribute name>

[frankslin]

 hi

We have some users with several attributes defined in JIProfileAttribute, we would like to use them to filtre the input control

Having looked at the cascading input control, and find this

LoggedInUserAttribute_<attribute name>

String

Attribute value for matched attribute name (like "att1") on the user. Empty string if no match. Only provided if defined in a query or as a report parameter.

No

 

Does anyone know how can i use  this in my input controle query

 

 

I use like this :

select my_col from my_tab where my_attri=$P{LoggedInUserAttribute_my_attri},

but it didn't work

 

jasperserver version: 3.7.0 pro

Thanks

 

[kimblbob]

I want to do this same thing. I assume this cannot be done?

Post Edited by kimblbob at 04/13/2011 18:51

[mandm]

any luck with this guys, i wanted to use it my single select input control, does anyone know how it work?

[sercan]

Use     $P!{LoggedInUserAttribute_my_attri} instead of $P{LoggedInUserAttribute_my_attri}