cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot Purge Value Stream / Thing logged data

Nicolas_HORST
Regular Member

Cannot Purge Value Stream / Thing logged data

Hello,

 

I have some problems understanding / using the "PurgeAllPropertyHistory" of the Thing of which Iam trying to delete the logged data from.

 

The logged data are full numbers (1,2,3...)

 

What exactly is the startDate and the endDate? Does the "PurgeAllPropertyHistory" even care about which Date is being set here (It just has to be different I assume)?

 

Is it possible to delete ALL logged data without setting startDate and endDate?

 

I am trying to purge the data via a Mashup with a button that is connected to the "PurgeAllPropertyHistory" of my thing. I also tried to add startDate and endDate values per datePicker and the set it via Button

13 REPLIES 13

Re: Cannot Purge Value Stream / Thing logged data

Hello @Nicolas_HORST ,

 

Value Stream is dependent on its Thing.

Running a purge on a Thing, will only clear out that Thing.

 

There are 3 different purges available on the Thing - PurgeAllPropertyHistory, PurgePropertyHistory and PurgeSelectedPropertyHistory.

  • PurgeAllPropertyHistory - purges all logged properties on the Thing
  • PurgePropertyHistory - purges a property that is logged (you need to give the name of the property that is logged)
  • PurgeSelectedPropertyHistory - purges a list of properties on the Thing (takes an Infotable input of the properties you want to purge)

 

With that being said, you need to give a start and end date or it won't purge/ delete your data.

When you call service PurgeAllPropertyHistory to remove all the data entries from a Thing using the Value Stream, make sure you also select the startDate and endDate, and also make sure the startDate is on the bottom and endDate is on the top.

 

Hope it helps,

 

Re: Cannot Purge Value Stream / Thing logged data

Hello @Ciprian-Traian ,

 

Thank you for your reply.

 

I already tried every combination of start and end Dates that I can think of.. do I have to clear the Thing or the ValueStream? I think I tried clearing both but It seems like the data is still available (I am using a graph to see if its still there or not)

 

Would startDate be the date that is today and endDate is the date that I want to delete to or is it reversed?

 

Is there a way I can manually delete / see the data? Where exactly is it saved in the msql database?

Re: Cannot Purge Value Stream / Thing logged data

Hi @Nicolas_HORST ,

Mention endDate as current time( var currentDate = new Date() ); Keep the start date as it is (undefined) .

Tags (1)

Re: Cannot Purge Value Stream / Thing logged data

Hello @Ashritha ,

 

Thank you for your answer.

 

How do I set the current date as that variable? I am using the DatePicker tool from Mashup menu.

And how do I run it?

 

I have linked a button to "PurgeAllPropertyHistory"

endDate is given by datepicker via ViewMashup (date Today)

startDate is empty (undefined)

 

Ive attached a picture of the bond between those things

 

I am connected to ThingWorx Industrial Connectivity 8 (TW Foundation)

 

 

Re: Cannot Purge Value Stream / Thing logged data

Hi @Nicolas_HORST ,

 

Create a custom service

  • current time as variable
    • var variableDate = new Date();
    • Call PurgeAllPropertyHistory and provide the above variable as endDate

Re: Cannot Purge Value Stream / Thing logged data

Hello @Ashritha  ,

 

Thank you for you reply.

 

I created a new Service in the thing as seen as in the picture "2021-01-05_PTC-Community_PurgeAllPropertyHistory_3"

 

In picture "2021-01-05_PTC-Community_PurgeAllPropertyHistory_2" you can see that ive added the service to the thing inside the mashup view but i cant seem to connect those two..

 

Is there anything that Im missing?

 

 

Re: Cannot Purge Value Stream / Thing logged data

Hi @Nicolas_HORST.

 

There are 2 options for binding the service:

 

1) Drag and drop, but this can be tricky if you have several services in the mashup

2) Use the configure service button

       a) Select currentTimeDate service from the Data pane in the mashup builder

       b) Click the Data Properties tab below

       c) In the upper right corner of that window, click the configure selected entity button (button with split arrow)

       d) In the configure bindings windows on the left, locate the date field that is returned by your service

       e) Click the drop-down arrow to the right of the field

       f) Select Add Target

       g) In the right window pane, click the Data tab at the top of the screen

       h) Locate PurgeAllPropertyHistory

        i) Expand the parameters section of the service if it isn't already expanded

        j) Place a check next to the endDate parameter

        k) Click Next

        l) Click Done

 

If you still have issues, I recommend that we open a case.  I will be happy to open one on your behalf if you desire.

 

Regards.

 

--Sharon

 

Re: Cannot Purge Value Stream / Thing logged data

Hi @Nicolas_HORST.

 

If you were able to resolve your issue with help from one of the previous posts, please mark the appropriate one as the Accepted Solution for the benefit of others in the community.

 

Regards.

 

--Sharon

Re: Cannot Purge Value Stream / Thing logged data

Hello @slangley ,

 

I am sorry for the late reply.

I already tried the first step (dragging and dropping the service (PurgeAllPropertyHistory) the thing of which I want to delete the data from. I linked it to a button and a date time picker but it didn't work...

 

Could you provide me with a pictured guide if there is any available? Maybe I did something wrong in setting the service / thing up..

 

 

Best regards

 

 

Re: Cannot Purge Value Stream / Thing logged data

Hi @Nicolas_HORST.

 

I think it would be best to open a support case to work through the issues you're having.  I will be happy to open one on your behalf with your approval.

 

Regards.

 

--Sharon

Re: Cannot Purge Value Stream / Thing logged data

Hi @slangley, Thank you for your answer. If a support case would be the best choice then I would be happy if you'd open one for me. Best regards Nicolas HORST

Re: Cannot Purge Value Stream / Thing logged data

Hi @Nicolas_HORST.

 

Case 15740886 has been opened on your behalf.

 

Regards.

 

--Sharon

Re: Cannot Purge Value Stream / Thing logged data

Hello @slangley 

 

Thank you very much

 

Best regards

Nicolas HORST

Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.