Community Tip - You can change your system assigned username to something more personal in your community settings. X
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
Solved! Go to Solution.
Hi @Nicolas_HORST.
It appears your issue was resolved via the case that was opened. Answers to some of your questions are as follows:
Please let us know if this can be considered the solution to your case or if additional information needs to be posted here for the benefit of others in the community.
Regards.
--Sharon
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.
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,
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?
Hi @Nicolas_HORST ,
Mention endDate as current time( var currentDate = new Date() ); Keep the start date as it is (undefined) .
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)
Hi @Nicolas_HORST ,
Create a custom service
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?
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
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
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
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
Hi @Nicolas_HORST.
It appears your issue was resolved via the case that was opened. Answers to some of your questions are as follows:
Please let us know if this can be considered the solution to your case or if additional information needs to be posted here for the benefit of others in the community.
Regards.
--Sharon