Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Fapi.getContentObjects) not respecting "time" value

Description

getContentObjects is not dealing with "lte" date filters properly - it is not including results on the day specified.

This is occurring because of the ambiguous behaviour of filtering on cf_sql_date, and would also impact "gt" filters.

Environment

None

Activity

Blair McKenzie February 28, 2011 at 4:08 AM

I fixed this issue by assuming filter values with no time value (i.e. 00:00:00) were date-only filters. For LTE or GT filters these values are incremented by a day simulate a date-only comparison with timestamps.

i.e. <= 15 January is equivalent to < 16 January 0:00:00
> 15 January is equivalent to > 16 January 0:00:00

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created February 28, 2011 at 3:57 AM
Updated February 28, 2011 at 4:08 AM
Resolved February 28, 2011 at 4:08 AM