Hi Kevin, I have tended to use the paging mechanisms of HQL and JBoss Seam's Application Framework, so maybe use a similar approach? I think they have some kind of Proxy to fetch "a pageful" of rows.
Best Regards Mike Burton On 23 Mar 2012, at 13:59, Kevin Meyer - KMZ wrote: > Hi guys, > > At the moment, the SQL object store defaults to instantiating no more > than 100 instances of any POJO (e.g. allInstances(Member.class) will > only return up to 100 Members). > > I have added the ablity to increase this maximum via the properties file > (e.g. use: "isis.persistor.sql.maxinstances=1000"). > > What's the general rule here? > > Real world example: I want to generate an invoice for all NORMAL > members for their dues this year. From a pure design point of view, I > therefore want to use a pattern query to fetch all NORMAL members, > then with each member, create an invoice. Neither the list of members > nor the created invoices is ever presented to the UI. > > As it stands right now, I need to increase the maxinstances value. > > I don't really want to fire off a custom SQL query to create the invoice > entries manually... > > Regards, > Kevin >
