Skip to main content
P
preddy-21-Visitor
1-Visitor
May 5, 2016
Question

Number of rows in QueryPropertyHistory

  • May 5, 2016
  • 3 replies
  • 2986 views

Hello All,

I have a confusion in, how many number of rows valuestream querypropertyhistory returns?

I have a device with 3 properties (i,j,k) and I am updating these values every minute in timer event.

In the mashup, I bound thing's  'querypropertyhistory' to the Grid. And I am refreshing 'querypropertyhistory' every minute.

Result is, number of rows is totally unpredicted way...

The distance between two time stamps is 1 minute as my timer event is for every minute.

But I wonder why for few time stamps two entries and for other time stamps, only one entry is there.  Can anyone has better explanation?

Thank you.

With B/R,

Praveen.B

    3 replies

    T
    ttielebein5-Regular Member
    5-Regular Member
    May 5, 2016

    Hello,

    This is the grid as it appears in a mashup, right? When you query the value stream directly on the Thing, does it display like this also? It is possible that some data is not being written to the value stream in that case. Otherwise, there may be something wrong with the way it is displaying in the grid.

    Thanks!

    Tori

    P
    preddy-21-VisitorAuthor
    1-Visitor
    May 6, 2016

    Hi Tori,

    Yes...that is the grid in mashup. I queried directly thing value stream, that result also same. Below is the screenshot.

    Not sure how to understand this.

    With B/R,

    Praveen.B

    T
    ttielebein5-Regular Member
    5-Regular Member
    May 6, 2016

    Ok, so it looks like some data is not being written to the value stream properly. Can you please go to the Application Log and see if there are any error messages?

    P
    preddy-21-VisitorAuthor
    1-Visitor
    May 7, 2016

    No.I do not see any relevant application log errors also.

    With B/R,

    Praveen.B

    T
    ttielebein5-Regular Member
    5-Regular Member
    May 9, 2016

    How is your value stream set up? Do properties log to it whenever there are changes? Are you sure properties are updating when they are supposed to?

    A
    Aanjan5-Regular Member
    5-Regular Member
    May 9, 2016

    Praveen, here's an article on how QueryPropertyHistory works when using multiple properties.

    P
    preddy-21-VisitorAuthor
    1-Visitor
    May 10, 2016

    Hi Ravi,

    Thank you for the reference data.Even with that explanation also,I don't see any case of multiple entries for same time stamp.

    In my case, few of the time stamps came twice in the table. How can it be possible?

    With B/R,

    Praveen.B

    Terms & ConditionsAccessibility statement