john.doe1991 Posted February 2, 2015 Share Posted February 2, 2015 Hello colleagues!I've been creating Ad hoc domain and trying to use derived table because I have a specific query. Can I provide some kind of placeholders in query as parameters while creating domain? For example, here we have a query: select * from table_x where y = ?. How can I provide parameter for this "?" so that I can use it and pass it in View or Report component further?Thank you! Link to comment Share on other sites More sharing options...
nthapa Posted February 2, 2015 Share Posted February 2, 2015 You can use profile attribute or user attribute. Those could be defined at server level, user level or tenant level.https://community.jaspersoft.com/documentation/jasperreports-server-user-guide/profile-attributesHTH Link to comment Share on other sites More sharing options...
john.doe1991 Posted February 3, 2015 Author Share Posted February 3, 2015 I'm sorry. I didn't really get from this doc how can I access user attributes from query in Derived Table tab? Link to comment Share on other sites More sharing options...
john.doe1991 Posted February 3, 2015 Author Share Posted February 3, 2015 Seems that we should use domain design XML file. Otherwise, what expression should I use to access current logged in user from that XML? Link to comment Share on other sites More sharing options...
nthapa Posted February 3, 2015 Share Posted February 3, 2015 This might be more clear:https://community.jaspersoft.com/documentation/jasperreports-server-ultimate-guide/v55/roles-users-and-profile-attributesYou can also add server level attributes from Repository ->root->System properties ->GlobalPropertiesList ->Edit (after right clicking) and make the required changes.To access those variables, you can directly use {attribute('attributeName')} on your sql. Link to comment Share on other sites More sharing options...
gowthamsenmca Posted March 13, 2015 Share Posted March 13, 2015 Hi, I am unable to access given link: https://community.jaspersoft.com/documentation/jasperreports-server-user-guide/profile-attributes Can you please check once? Thanks Link to comment Share on other sites More sharing options...
vedamprudhvi Posted November 3, 2016 Share Posted November 3, 2016 Hi, Any one solve this issue?please inform me to vedamprudhvi@gmail.comthanks 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