1 Reply Latest reply on Aug 29, 2017 8:43 AM by jborovský RSS
    jborovský Newbie

    Missing columns from QueryPropertyHistory

    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ý