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!
4 Answers:
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...
HTH
This might be more clear:
https://community.jaspersoft.com/documentation/jasperreports-server-ulti...
You 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.
Hi, Any one solve this issue? please inform me to vedamprudhvi@gmail.com thanks
I'm sorry. I didn't really get from this doc how can I access user attributes from query in Derived Table tab?
Hi,
I am unable to access given link: https://community.jaspersoft.com/documentation/jasperreports-server-user...
Can you please check once?
Thanks