thank you jakob, scarab tells me:
"You do not have permission to view an issue with that ID. If you believe it is a valid ID, check with the project owner or system administrator" any help? Sergey (I am associated with OJB module) -----Original Message----- From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 2:16 PM To: OJB Users List Subject: Re: OJB report query hi sergey, ojb currently cannot handle multiple columns in one criteria. see http://nagoya.apache.org/scarab/issues/id/OJB242 jakob Manukyan, Sergey wrote: > Folks, > > I am repeating my question here as obviously it stands as a problem for me > now and either: > 1. it cannot be solved by current OJB implementation > 2. there is a solution I don't know about > > How can I specify expressions in OJB report query? > > F.e. I am making a report that as a column should produce addition of two > table columns : > > qry.setColumns( > new String[] { > "materialVariance + laborVariance" > } > > materialVariance and laborVariance are defined as field names in OJB > repository, unfortunately this code doesn't work as OJB failes to make a > mapping to actual table column names in SQL generation and makes SQL like: > > SELECT materialVariance + laborVariance FROM .... > > And of course there are no such columns in database table, > Now I am forced to make substitution and instead of field names include > column names in OJB query: > > qry.setColumns( > new String[] { > "MATVAR + LABVAR" > } > > Which is evidently a bad way of using OJB that is increasing future > maintenance. I am using RC4. > > Please tell me if there is or there is no solution for this problem in OJB > as it looks like limitation for me, > > Thank you, > -Sergey > > > > > ********************** > ** LEGAL DISCLAIMER ** > ********************** > > This E-mail message and any attachments may contain > legally privileged, confidential or proprietary > information. If you are not the intended recipient(s), > or the employee or agent responsible for delivery of > this message to the intended recipient(s), you are > hereby notified that any dissemination, distribution > or copying of this E-mail message is strictly > prohibited. If you have received this message in > error, please immediately notify the sender and > delete this E-mail message from your computer. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
