For that you want DynamicQL which allows you to generate an execute JBossQL at runtime. I suggest you get a copy of the JBossCMP docs ($10) at FlashLine.
-dain Emerson Cargnin - MSA wrote: > question : does it allows to make the ordering dinamic??? or do I have > to have one method for each orering type? > > Dain Sundstrom wrote: > >> Dennis, >> >> You want to use JBossQL which is an extension of EJB-QL with order by >> and other things. Just copy (not move) your ejb-ql declaration from >> the ejb-jar.xml file, change <ejb-ql> to <jboss-ql> and add "ORDER BY >> identifier.Created DESC". >> >> -dain >> >> Dennis Muhlestein wrote: >> >>> Jboss 3.0.0 final >>> >>> In jboss' cmp xml file I want to modify the order by for a finder >>> method: >>> >>> <declared-sql> >>> <order>Created desc</order> >>> </declared-sql> >>> >>> That all works fine but it also overrides the ejb-jar file's where >>> clause. >>> I don't want to have to redo the where clause portion. Is that >>> possible? >>> >>> Thanks >>> Dennis >>> >>> >>> >>> >>> ---------------------------------------------------------------------------- >>> >>> Bringing you mounds of caffeinated joy >>> >>> http://thinkgeek.com/sf <<< >>> >>> _______________________________________________ >>> JBoss-user mailing list >>> [EMAIL PROTECTED] >>> https://lists.sourceforge.net/lists/listinfo/jboss-user >> >> >> >> > > > > > ------------------------------------------------------- > Sponsored by: > ThinkGeek at http://www.ThinkGeek.com/ > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user -- xxxxxxxxxxxxxxxxxxxxxxxx Dain Sundstrom Chief Architect JBossCMP JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx ------------------------------------------------------- Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
