/api/dataValueSets not returning lastUpdated with datetime

Support - Assistance technique
1

Hi,

can you check the database column type of datavalue.lastupdated ? It should be “timestamp without time zone”.

Lars

···

On Fri, Jan 9, 2015 at 12:09 PM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Hi,

When we do a GET on /api/dataValueSets, the lastUpdated field is always of the format YYYY-MM-DDT00:00:00 irrespective of when the data value was POSTed. The time component is always 00:00:00.

Is this a bug?

Thanks,

Kiran/Mahendra

2

Can you try to save some data now and see if the time component is still 00 ?

···

On Fri, Jan 9, 2015 at 12:22 PM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Bang On! It is indeed “timestamp without time zone”. The same is the case even with created field.

On Fri, Jan 9, 2015 at 4:46 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi,

can you check the database column type of datavalue.lastupdated ? It should be “timestamp without time zone”.

Lars

On Fri, Jan 9, 2015 at 12:09 PM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Hi,

When we do a GET on /api/dataValueSets, the lastUpdated field is always of the format YYYY-MM-DDT00:00:00 irrespective of when the data value was POSTed. The time component is always 00:00:00.

Is this a bug?

Thanks,

Kiran/Mahendra

3

Great, thanks.

···

On Thu, Jan 15, 2015 at 6:03 AM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Hi Lars,

Sorry for the late reply.

This is fixed in the latest rev.

Thanks!

On Fri, Jan 9, 2015 at 4:55 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Can you try to save some data now and see if the time component is still 00 ?

On Fri, Jan 9, 2015 at 12:22 PM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Bang On! It is indeed “timestamp without time zone”. The same is the case even with created field.

On Fri, Jan 9, 2015 at 4:46 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi,

can you check the database column type of datavalue.lastupdated ? It should be “timestamp without time zone”.

Lars

On Fri, Jan 9, 2015 at 12:09 PM, Mahendra Kariya mahendra.kariya@thoughtworks.com wrote:

Hi,

When we do a GET on /api/dataValueSets, the lastUpdated field is always of the format YYYY-MM-DDT00:00:00 irrespective of when the data value was POSTed. The time component is always 00:00:00.

Is this a bug?

Thanks,

Kiran/Mahendra