topic History of a thing in ThingWorx Developers

History of a thing

ngourav — Sat, 24 Sep 2016 09:40:24 GMT

Carles CollJoao PintoThounaojam AmarjitDonna ReynoldsGlenn Sinclair

Hi All,

Can anyone help me on getting the history of the changes made in a thing . Can I get the that data in thingworx??

Thanks

Naveen

Re: History of a thing

rupadhyay — Sat, 24 Sep 2016 10:30:11 GMT

Hi @Naveen ,

Please clarify your question , as in what are you trying to do ?

Changes made to a Thing in Thingworx can easily been seen in Change History.

Please see the screenshot and let me know , if this is what you are looking for .

Re: History of a thing

ngourav — Sat, 24 Sep 2016 10:34:11 GMT

Hi Ravi Upadhyay

I want to get the history of the thing property changed.

Re: History of a thing

rupadhyay — Sat, 24 Sep 2016 10:34:58 GMT

Let me know if I understand your phrase correctly " Can I get that in Thingworx " means are you trying to export the changes to Excel ?

Re: History of a thing

ngourav — Sat, 24 Sep 2016 10:40:43 GMT

Hi Ravi Upadhyay

If you are doing any modification in a thing property I want to get that information with time and the changes which were made in that thing property value.

So when ever any user changes any thing in the property I need that info (property history).

Thanks

Naveen

Re: History of a thing

rupadhyay — Sat, 24 Sep 2016 10:48:51 GMT

To get this , once you have made changes , to the property , you will need to a export from the Property tab itself .

Re: History of a thing

rupadhyay — Sat, 24 Sep 2016 10:51:15 GMT

Check the xml file and it will contain the changes made to the Property of Thing.

I believe this is what you are looking for .

Re: History of a thing

CarlesColl — Sat, 24 Sep 2016 14:18:08 GMT

Hi Naveen,

If what you want it's recover the property values changes ( data), you should set the property as Logged and assign a ValueStream to the thing in order to store the logged values on the ValueStream. Once done this, all property values change will be recorded on the stream, then to recover the history values, you should leverage "Query"+baseType+"PropertyHistory" services on the thing.

Best Regards,

Carles.

Re: History of a thing

rupadhyay — Sat, 24 Sep 2016 14:54:52 GMT

Thankyou Carles Coll , your answer made me realise that I was not able to understand the the question. I thought , Naveen is talking about the changes in property and Its property value.

Thanks once again

Re: History of a thing

athounaojamamar — Sun, 25 Sep 2016 20:32:10 GMT

Hi Naveen Gourav,

If I got your question right, Carles Coll rightly answered your question. But I have created a blog post containing step by steps instruction on how to set up property logging, to make it clear and easy for lesser understood members. Find the blog post here Log Thing Property History ( Thing Property history logging and retrieval). Hope it helps.

Re: History of a thing

ngourav — Fri, 14 Oct 2016 09:37:55 GMT

Hi Carles,

Thanks for your reply.

Can we get properties with different base types together in single infotable.

Re: History of a thing

CarlesColl — Fri, 14 Oct 2016 10:09:39 GMT

Hi Naveen,

To "join" on timestamp different logged properties from the same Thing, you have a helper method: QueryPropertyHistory -> Test it, I think it's what you are asking for.

Best Regards,

Carles.