Re: join: possible with ReportQueries?
hi joerg, ojb can only build joins based on relationships defined in the repository. hth jakob Joerg Lensing wrote: Gelhar, Wallace Joseph wrote: Hi joerg, OJB executes all queries on the database, so there must exist a mapping of attributes to database columns if you want to be able to query them. ReportQueries also use the repository.xml mapping to translate attributes of classes to database columns. Can you explain further what you are trying to accomplish? Hi Wally, The classes I want to query by ReportQueries are mapped by OJB but they don't have a direct relationship. joerg Wally -Original Message- From: Joerg Lensing [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 4:47 AM To: OJB Users List Subject: join: possible with ReportQueries? Hi, Is it possibel to query a field from a different class, only having the "Where"-criteria? e.g. Article.class and ArticleGroup.class are not mapped by OJB. Only a ref-id exist. (Ariticle holds a field 'refArticleGroupID'). Now I want to query the class Article and some of the fields from ArticleGroup. It is NOT intended to map the Class by OJB to support querying BusinessObjects Can I use a ReportQuery to get one or more values from ArticleGroup ? Is there an example? tx joerg - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: join: possible with ReportQueries?
Gelhar, Wallace Joseph wrote: Hi joerg, OJB executes all queries on the database, so there must exist a mapping of attributes to database columns if you want to be able to query them. ReportQueries also use the repository.xml mapping to translate attributes of classes to database columns. Can you explain further what you are trying to accomplish? Hi Wally, The classes I want to query by ReportQueries are mapped by OJB but they don't have a direct relationship. joerg Wally -Original Message- From: Joerg Lensing [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 4:47 AM To: OJB Users List Subject: join: possible with ReportQueries? Hi, Is it possibel to query a field from a different class, only having the "Where"-criteria? e.g. Article.class and ArticleGroup.class are not mapped by OJB. Only a ref-id exist. (Ariticle holds a field 'refArticleGroupID'). Now I want to query the class Article and some of the fields from ArticleGroup. It is NOT intended to map the Class by OJB to support querying BusinessObjects Can I use a ReportQuery to get one or more values from ArticleGroup ? Is there an example? tx joerg - 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]
RE: join: possible with ReportQueries?
Hi joerg, OJB executes all queries on the database, so there must exist a mapping of attributes to database columns if you want to be able to query them. ReportQueries also use the repository.xml mapping to translate attributes of classes to database columns. Can you explain further what you are trying to accomplish? Wally -Original Message- From: Joerg Lensing [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 4:47 AM To: OJB Users List Subject: join: possible with ReportQueries? Hi, Is it possibel to query a field from a different class, only having the "Where"-criteria? e.g. Article.class and ArticleGroup.class are not mapped by OJB. Only a ref-id exist. (Ariticle holds a field 'refArticleGroupID'). Now I want to query the class Article and some of the fields from ArticleGroup. It is NOT intended to map the Class by OJB to support querying BusinessObjects Can I use a ReportQuery to get one or more values from ArticleGroup ? Is there an example? tx joerg - 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]
