Missing columns from QueryPropertyHistory

[jborovský]

Hi, I have a problem with some Things created from a common template call it T.

When a QueryPropertyHistory service is called on them in a composer, all Things have their properties stored. So that part is OK.

But when I am calling this service in a mashup I dont get data from at least one column.

in Mashup propertyhistory Row 0 from thing A{_0: false, _1: 509, _2: 46.44, _3: 97, _5: 225, _6: -121, _9: false, _11: -12.8, _12: 1503983024000,…}

in Mashup propertyhistory Row 0 from thing B{_0: false, _1: 195, _2: 2284.973, _5: 106, _6: -119, _8: 11, _9: false, _11: -17.5,…}

>>column with alias _3 is missing.

in composer Row 0 from thing B

{_0: false, _1: 195, _2: 2284.973, _3: 99, _4: "4/5", _5: 106, _6: -119, _7: true, _8: 11, _9: false,…}

I have tried to Restart the Thing but it havent solved it. Any ideas?

Thank you

Jara

Edit: If I change _3 (battery) property manually or in javascript, it starts to show up. It is a number type and logged by value datachange.

Message was edited by: Jaroslav Borovský

[jborovský]

I found out what was the problem. I was reading very short history where there was not even one change in battery value. So the whole column was without values.

When I extended the time interval to reach at least one battery value change, the value copied until to all further(above/newer) rows.