How to get User details in Jasper server

[yamini]

Hi,

 

I created one query in jasper server. For where condition I need to pass username. How can I get Username in Edit Query Wizard.

 

 

Thanks

 

Post edited by: yamini, at: 2007/04/06 10:38 [file name=img1.jpg size=15313]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/img1.jpg[/file]

 

Post edited by: yamini, at: 2007/04/06 10:41

Post edited by: yamini, at: 2007/04/06 10:45

[yamini]

yamini wrote:

Hi, I created one query in jasper server. For where condition I need to pass username. How can I get Username in Edit Query Wizard. Thanks Post edited by: yamini, at: 2007/04/06 10:38 [file name=img1.jpg size=15313]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/img1.jpg[/file] Post edited by: yamini, at: 2007/04/06 10:41<br><br>Post edited by: yamini, at: 2007/04/06 10:45

[file name=img1-2e9f26c5d3416a1ddaee1c30dd471d62.jpg size=15313]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/img1-2e9f26c5d3416a1ddaee1c30dd471d62.jpg[/file]

[csbac]

Hi!

Have a look at

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=10&id=22705#22705

about how to pass login information to a Jasper Report.

It can then be used in the query as a parameter.

 

Citing Lucian:

"JS always assigns a com.jaspersoft.jasperserver.api.metadata.user.domain.User instane to the "LoggedInUser" parameter, so one would need to declare this type for the parameter and then used getters to extract the user details."

 

Hope it helps,

Sebastian

[yamini]

Hi,

 

Actually in Jasper Server I want to create one Input Control, Type: "Single-select Query" depending on logged in person I need to populate that drop down through query.

 

So please tell me how to populate that data in drop down based on logged in person id.

 

Thanks

Yamini

[jens_noering]

Hello,

it would be great to have the opportunity to pass user informations to input controll query.

Is there a way to handle this?

 

Greetz

Jens

[swood]

We would have to have a way of including values from the logged in user into the where clause. We could do this like JasperReports does it - with variable subsitution $F{user.name}. There are other values that could be available, like the assigned roles.

 

Would this be an approach that works?

 

 

Sherman

JasperSoft

[jens_noering]

That would enhance security management a lot.

 

The administrator would have the oportunity to filter the data of a query-input control through a join with a permission table. that would be great.

 

 

We are using jasperserver 1.2.0 in combination with jasperanalysis and jasperreports.

 

I've seen that a olap.report.datasource is implemented in JS 1.2.1.

But Roles are not passed to the olap.datasource or is this feature implemented now?

 

 

Greetz Jens

[Teodor Danciu]

Hi,

 

We are open to all feature requests. But to track them, it would be good if you could log this here:

http://jasperforge.org/sf/tracker/do/listArtifacts/projects.jasperintelligence/tracker.feature_requests

 

Otherwise it would just be buried deep into this forum.

 

Thank you,

Teodor

[abrahama]

Hi,

The feature suggested is of great importance.

There should be a way to include "WHERE" clauses with Logged In User parameters in input query.

Not only the Logged in user name alone, but also other parameters like "ROLE" should be used.

That way it help to support LDAP user verification.

Thanks and Regards

Abraham

[zhu001]

Does any one know if that feature was actually submitted and implemented? Looks like that is what i was asking here Referencing logged-in-user attributes in a sql

 

Post edited by: zhu001, at: 2008/07/01 18:49

Post edited by: zhu001, at: 2008/07/01 18:49