| Greetings,
Hope everyone is having happy holidays to the extent that's relevant. I am having a strange issue with a subclass of ERXBatchingDisplayGroup. I am creating s search component to filter the results of the displayGroup.
I have created a qualifier, which appears correct. The SQL generated seems appropriate, and the navigation appears to properly display the correct number of pages from the batch count (and resulting select count(*) statement). However, the rows returned and displayed in the displayGroup are many fewer, so where I have 3 pages in the navigation with batches of 20 for a set of 55, only 12 rows are in the table of the displayed objects, so clicking navigation returns an empty component.
I looked at the SQL and the first statement is the count, the second gets the actual ids for the rows counted (both add up to 55), then the very next SQL statement asks for objects of the appropriate type matching 12 ids, and thus returns 12 rows only.
Anyone have any idea what might cause this?
Andrew
Wonder Head, WO 5.4.3 WOLips head for 3.5
Eclipse 3.5
Snow Leopard |