Skip to main content
A
ad'orso-21-Visitor
1-Visitor
September 1, 2017
Solved

Problem with service QueryNamedPropertyHistory

  • September 1, 2017
  • 1 reply
  • 6389 views

Hello to all

I have a problem extracting data with the QueryNamedPropertyHistory service

Following is the example

I have a thing with the properties flow1 and flow2

If I extract data from the only property flow1 here is the result


If I extract data from the only property flow2 here is the result

If I pull both properties together here is the result

Why are the values duplicated?

How can I properly extract the values of both properties together?

Thanks in advance

Antonio

Best answer by CarlesColl

Hi Antonio,

What QueryNamedPropertyHistory does it's merge both ValueStreams, and as you can note on your data the milliseconds for entries are different, then instead of creating empty values what QueryNamedPropertyHistory does it's fill with previous value when there's no value for the given timestamp.

Data on ValueStreams are stored by property, it's not a Table with a column for each property.

If you want a row for each exact timestamp then you may query one property by one ( as your first two examples ) and then Pivot both infotables with Pivot snippet.

Best Regards,

Carles.

1 reply

C
CarlesColl1-VisitorAnswer
1-Visitor
September 1, 2017

Hi Antonio,

What QueryNamedPropertyHistory does it's merge both ValueStreams, and as you can note on your data the milliseconds for entries are different, then instead of creating empty values what QueryNamedPropertyHistory does it's fill with previous value when there's no value for the given timestamp.

Data on ValueStreams are stored by property, it's not a Table with a column for each property.

If you want a row for each exact timestamp then you may query one property by one ( as your first two examples ) and then Pivot both infotables with Pivot snippet.

Best Regards,

Carles.

A
ad'orso-21-VisitorAuthor
1-Visitor
September 1, 2017

OK thanks Carles.

so the only way to have both properties is to run the QueryNamedPropertyHistory service for each property and put the results into a correct infotable?

Best Regards

Antonio

C
CarlesColl1-Visitor
1-Visitor
September 1, 2017

Well to just query one by one, maybe better if you use "QueryNumberPropertyHistory" service instead of QueryNamedPropertyHistory, the second one it's more meant to query multiple properties in once.

Terms & ConditionsAccessibility statement