So you say that GREATER_THAN_EQUAL_TO (which means GREATER_THAN or EQUAL_TO) does not work for dates
using the performFind service ?
It's true that I can't see any uses of greaterThanEqualTo but in FindServices[262] (nor in Lookups UIs). And there
GREATER_THAN_EQUAL_TO is only used for sameDay which is not what you are looking for. So I think you are right though it surprises
me a bit that this was not yet implemented and I wonder if we are not missing something.
Anyway, please feel free top open a Jira issue for this.
Jacques
From: "Stanimir Todorov" <
[hidden email]>
> Hi all,
> I need to find a date period. For example to find all birth dates from
> 2008-01-02 to 2008-01-05 including start and end date. Using the
> performFind service and the following field in the UI:
> <field name="birthDate" title="Time Period">
> <date-find type="date"/>
> </field>
> The problem is the following.
> The entity field type is date (java.sql.Date). For example 2008-01-02.
> The start period date also is 2008-01-02. Then I need to compare 2
> equals value (2008-01-02 00:00:00.000). But I don't see such a operator
> in the performFind. If I am using "Greater Than From Day Start" the
> entityOperator is "GREATER_THAN" and that exclude the start date
> (2008-01-02). Thus I found only birth dates after 2008-01-02, but
> without in 2008-01-02.
> For the end date I am using "Up Thru Date" and it's OK.
> One of decision could be a new options for the "GREATER_THAN_EQUAL_TO"
> entity operator. For example "Greater Than Equal To" and "Greater Than
> Equal To From Day Start".
> Any thought would be appreciated! And then as soon as possible I can
> create a patch.
> Thanks, Stanimir!
>
Locked
