yamini Posted April 6, 2007 Share Posted April 6, 2007 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:41Post edited by: yamini, at: 2007/04/06 10:45 Link to comment Share on other sites More sharing options...
yamini Posted April 6, 2007 Author Share Posted April 6, 2007 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.ThanksPost 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 More sharing options...
csbac Posted April 7, 2007 Share Posted April 7, 2007 Hi!Have a look at http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=10&id=22705#22705about 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 More sharing options...
yamini Posted April 9, 2007 Author Share Posted April 9, 2007 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. ThanksYamini Link to comment Share on other sites More sharing options...
jens_noering Posted April 10, 2007 Share Posted April 10, 2007 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 Link to comment Share on other sites More sharing options...
swood Posted April 10, 2007 Share Posted April 10, 2007 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? ShermanJasperSoft Link to comment Share on other sites More sharing options...
jens_noering Posted April 10, 2007 Share Posted April 10, 2007 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 More sharing options...
Teodor Danciu Posted April 20, 2007 Share Posted April 20, 2007 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 Link to comment Share on other sites More sharing options...
abrahama Posted May 24, 2007 Share Posted May 24, 2007 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 RegardsAbraham Link to comment Share on other sites More sharing options...
zhu001 Posted July 2, 2008 Share Posted July 2, 2008 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:49Post edited by: zhu001, at: 2008/07/01 18:49 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now