Query that picks up current user id in sugarcrm

[sugra]

Hello,

I would like to create an ireport where the query picks up the current user logged into a system and displays information based on it.

What I really want is to know how to write the statement

where users.id = users. [current user id]

 Have any of you tried this before and if so how is it done?

 

Thanks in advance

[hingerl]

hi, for your [current user id] you can use this parameter:

Code:

<parameter name="LoggedInUser" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User" isForPrompting="false"/>

Post Edited by hingerl at 01/08/09 12:25

[sugra]

Thank you but where do I place this code... in the .jrxml file? I tried it and got a few errors.

[mdahlman]

sugra,

 

hingerl's reference is correct. You should use LoggedInUser. But to put this in context, it is referring to JasperServer.

 

Are you already using JasperServer? It includes a sample report that uses this parameter, so you can start with this example:
/reports/samples/SalesByMonth

 

If you have more questions on this topic, you'll get better information on the JasperServer forum.

 

Regards,
Matt

[sugra]

Hi,

I'm not using Jasper Server.

I am using a plugin into SugarCRM. I create the .jrxml file in iReports and then upload to Sugar and run the reports from there. I want to know how I can write the .jrxml script so that once it is in SugarCRM it can pick up the current user.

 

Any ideas??