The Abator criteria methods are runtime methods. They allow you to generate different where clauses at runtime based on different "filters" that you might want to set. I think its worth taking a look because it demonstrates the real power available with iBATIS dynamic SQL.
Jeff Butler On 2/7/08, ercannon <[EMAIL PROTECTED]> wrote: > > > Hi, > First of all: thanks for answering. > As far as i know using Abator means defining things in compilation time, am > I right? (I've been working with ibatis only for 2 or 3 months so I'm a real > newbie :)) > Our requirements can change in execution time, i mean, a new filter field > can be added in execution time. > > Thanks > > > Jeff Butler-2 wrote: > > > > The code generated by Abator offers this functionality using iBATIS' > > dynamic > > SQL support. I'm not necessarily suggesting you use Abator, but you might > > take a look at the code it generates for an idea of how to accomplish this > > with iBATIS. > > > > Jeff Butler > > > > > > > > On Feb 7, 2008 11:23 AM, ercannon <[EMAIL PROTECTED]> wrote: > > > >> > >> Hi, > >> Our functional team has asked us for a new requirement: they want to > >> filter > >> data showed to the client by BD. They want something in order to add > >> dynamic > >> filters (for filtering rows and columns) defining them using database > >> (for > >> example, a profile should only retrieve the registers fo the district > >> "5", > >> and we will retrieve this field for filtering (district) and its value > >> (5) > >> from database. > >> I've done something like this easily using hibernate or OJB. Our > >> development > >> team is using ibatis, so we are looking for something like the > >> "addCriteria" > >> but we haven't found nothing that totally satisfy us with ibatis. > >> The "filter" should be transparent to the programmer (so we wouldn't like > >> to > >> use the $ idea in the sql maps nor dynamic tags in the sqlmap). > >> > >> Any ideas? > >> > >> Thanks, Manuel > >> -- > >> View this message in context: > >> > http://www.nabble.com/Something-like-an-interceptor-tp15338736p15338736.html > >> Sent from the iBATIS - User - Java mailing list archive at > >> Nabble.com<http://nabble.com/> > >> . > >> > >> > > > > > > -- > View this message in context: > http://www.nabble.com/Something-like-an-interceptor-tp15338736p15340502.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >
