-
1. Re: EntityQuery between filter dates.
ztiringer May 26, 2009 4:45 AM (in response to pinguino)Restrictions support only one binding per restriction. Just separate 'between' into 2 different restriction (less than maxDate, more than MinDate). This way besides the 'between' effect, you will handle even open-ended queries if user specifies only one of the filters.
-
2. Re: EntityQuery between filter dates.
pinguino May 26, 2009 9:11 AM (in response to pinguino)Thank you very much for your answer.
The problem with this solution is that I can't control the
execution plan for the select by the database - In this case oracle -.This case fails with this solution:
"msgim.procdatetime >= #{msgimList.date1}",
"msgim.procdatetime <= #{msgimList.date2}",
"msgim.regdatetime >= #{msgimList.datea3}",
"msgim.regdatetime <= #{msgimList.datea4}",The result is the following:
select ... where msgim.procdatetime >= msgimList.date1
and (msgim.procdatetime >= msgimList.date2
and msgim.regdatetime >= msgimList.datea3)
and msgim.regdatetime <= msgimList.datea4Thanks again
-
3. Re: EntityQuery between filter dates.
pinguino May 26, 2009 9:14 AM (in response to pinguino)What happened is that the joins between the filter dates haven't been done as I want
-
4. Re: EntityQuery between filter dates.
pinguino Jun 1, 2009 10:58 AM (in response to pinguino)Sorry for my English.
I explain better my previous post.
What happens is that the joins between the filter dates is not as I would likeThanks