[SOLVED]Problem with Username in report query

[etorona]

Hi,

I want to get the logged username to use it in a report query 

My jxml have 2 parameters :

-parameter class="com.jaspersoft.jasperserver.api.metadata.user.domain.User" isforprompting="false" name="LoggedInUser">

-parameter class="java.lang.String" isforprompting="false" name="Utilisateur">

 

defaultValueExpression ![CDATA[$P{LoggedInUser}.getUsername()]]

 

My query use looks like :

 

 ... where u.nomsgbag = $P{Utilisateur} ...

 

When i execute the report i always get Utilisateur as null values.

if i display it in a text field i get the username.

 

any HELP !

Thanks

 

 

[ernestoo]

The forum seems to have eaten the formatting - I cant see how you declared the parameters.

 

I'll take a wild guess though - you declared LoggedInUsername BEFORE Utilisateur? If that's the case then the default value for Utilisateur wouldn't be populated before LoggedInUsername?

 

Also, take a look at my sample here, maybe it helps? http://community.jaspersoft.com/wiki/designing-row-based-security-standard-reports

[etorona]

thanks for response.

i have in fact LoggedInUser before Utilisateur parameter but i get always a null value.

[ernestoo]

Oh then I think you're making things more complicated for yourself, just need this:

[etorona]

IT Work!  

Thank you very very much !!

[amine.benyoussef]

Sorry I have the same Problem.

 

In iReport a created a

parameter : LoggedInUser

Parameter Class: com.jaspersoft.jasperserver.api.metadata.user.domain.User

 

With no DefaultValueExpression.

 

 

I have a second Parameter : FullName

Parameter Class : String

Default Value Expression: $P{LoggedInUser}.getFullName()

 

 

When I display it in the report it's always NULL.

 

Please Help