Jump to content
Changes to the Jaspersoft community edition download ×

How to get User details in Jasper server


yamini

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 9
  • Created
  • Last Reply

Top Posters In This Topic

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]
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...

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

Link to comment
Share on other sites

  • 1 year later...

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...