Subject Re: [IBO] HDR and SQLWhereItems
Author Jason Wharton
> > If you add anything that reduces the amount of records from the base
> > then HDR is disabled under the assumption that you are taking care of
> > own refinements.
> >
> What do you mean with my own refinements ?

If you are adding SQLWhereItems then you are adding in SQL to reduce the
amount of records your base dataset will return. Thus, your base dataset is
"refined" by your OnPrepareSQL customizations.

> >
> > What I think you should do is make an input parameter to integrate in
> > own refinements and this will make it so that you base query will remain
> > same and not trigger the HDR to become disabled.
> >
> Some like that 'select * from table where field=:param' ?
> But then I reduce the amount of records as well.

Yes, that is my point. But, you do it in a way that isn't recognized as a
refinement to the base query. Come to think of it, I should disable HDR when
input parameters are used for the same reason I do when SQLWhereItems is

I need to add a property something to the affect of:

HDRMode: hdrmAuto, hdrmAlways, hdrmNever

How does this sound?

Jason Wharton
CPS - Mesa AZ