skkane Posted October 7, 2009 Share Posted October 7, 2009 Hello, I'm am trying to create a query resource based on a domain. I can easily create a query resource using a data source but i would like to get one to work off of the domain so the security file in place would be utilized.From the "Query - Locate Data Source" screen I select the "From the Repository" option and select domain. The "Edit Query" screen comes up next where you select a "Query Language" of SQL, Domain, Or HQL. I am unclear as to which one to pick and what to put for the Query String. I am sure I am using the wrong combination but I can find no reference on how to do it the proper way.Can anyone please provide some quidance on creating a query from a domain to be used in an input control?Thanks for you help.... Link to comment Share on other sites More sharing options...
swood Posted October 7, 2009 Share Posted October 7, 2009 Yes, it is missing. It should be easy to add as a custom data source. Some work would need to be done to allow it to appear as an option on the screen. Could you raise an enhancement request? ShermanJaspersoft Link to comment Share on other sites More sharing options...
skkane Posted October 7, 2009 Author Share Posted October 7, 2009 Thanks for the reply Sherman... Are you saying even though the Domain is a selectable option in the "From the Repository" drop down list it is not currently supported? Just seemed to me that it should be since you can even select a "Query Language" or Domain on the subseguent screen. I just want to make sure we are talking about the same thing before I come up with a work around. Thanks again.. -Sean Link to comment Share on other sites More sharing options...
swood Posted October 13, 2009 Share Posted October 13, 2009 Oops! You are right, Domain is there as a query langage option. Domain queries look like the XML below. A list of queryFields that refer to the presentation names in the domain. A queryFilterString (optional).When the query runs, the domain security is active if you have defined it in the domain. iReport has a domain query designer. ShermanJaspersoftCode:<query> <queryFields> <queryField id="expense_join_store.ej_store_store_name" /> <queryField id="expense_join_store.ej_store_first_opened_date" /> <queryField id="expense_join_store.ej_store_store_state" /> <queryField id="expense_join_store.ej_store_store_city" /> </queryFields> <queryFilterString><![CDATA[ expense_join_store.ej_store_first_opened_date in (s_first_opened_date_1_1:s_first_opened_date_1_2) and startsWith(expense_join_store.ej_store_store_country, startsWithParam) ]]></queryFilterString></query> Link to comment Share on other sites More sharing options...
frankee787 Posted December 17, 2012 Share Posted December 17, 2012 Is there a way to put a GROUP BY clause in the "queryFilterString" or is there some other place to put this? Link to comment Share on other sites More sharing options...
efrain_santiago Posted February 2, 2015 Share Posted February 2, 2015 did you ever find out how to do this? 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