Get specific data from Value stream

Forum|Forum|9 years ago
November 30, 2016
8 replies
5639 views

Hi,

I have created a thing with 4 property S1 , S2, S3 & TC from hardware device. Am logging the data to my value stream. Now I have to extract particular data using timestamp.

For Ex: S1 S2 S3 and TC are Count of a product per day. In mashup when I select date using widget, Count for that particular date should be displayed in using ValueDisplay/ LED widget. Help me with this.

Regards,

Vel

T

ttielebein

5-Regular Member

If you look under "Snippets" in the Services Editor, you can find one called "Create query for Stream". Select the stream name, and then add a timestamp filter. Pass the timestamp in as a parameter, import this service into a mashup, and bind everything as needed. Hope this helps!

N

nagrawal-2

1-Visitor

Hi Tori,

I was trying to implement similar but I can't find my ValueStream in stream name list. What else I should do to achieve the same ?

Regards,

Neety

R

rnayak-2

5-Regular Member

valuestream and stream are 2 different entity types.. while valuestream stores timeseries data, stream gives you capability to create your own data structure...

for your case all you have to do is look at the basetype of your defined property (ex:NUMBER, STRING etc) and then use the corresponding Queryservice available on your Thing (or ThingTemplate) depending on what your mashup needs... for instance if the basetype is Number then there is a service called QueryNumberPropertyHistory... you just have to pass property name and timestamp and it will return the required values...