Can orders be deleted? Company's retention policy requires I find a way.

Discussions concerning general integration topics.

Moderator: Phil Barton

Post Reply
jtomoso
Posts: 3
Joined: Thu May 03, 2018 9:57 pm

Can orders be deleted? Company's retention policy requires I find a way.

Post by jtomoso » Tue May 08, 2018 10:19 pm

I saw that this question was asked back in 2014, but I haven't been able to find any other update since then, so I wanted to ask again and see if there has been a change. My company has a published data retention policy that requires the deletion of orders after 7 years. So far, records in SoftPro Select haven't been affected by this policy, but next year they will be. In order to stay ahead of our requirements, I'm starting my questions here in the hope that a method for order deletion already exists.

So the question: Either via the UI or the API, can orders be deleted from SoftPro Select? To clarify...this is an actual deletion, not marking a record as inactive/hidden/etc.

Thanks for your help!

BobRichards
Posts: 1007
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: Can orders be deleted? Company's retention policy requires I find a way.

Post by BobRichards » Wed May 09, 2018 11:23 am

Sorry but there is no mechanism to totally remove an order and its artifacts across all the tables. I will enter this as a suggestion in our requirements database.

The effort will require significant time in order to selectively remove data from potentially dozens of table and verify that no ill effects occur that might jeopardize the future stability of Select as a whole including searches, reports, etc.
Bob Richards, Software Developer, SoftPro

jtomoso
Posts: 3
Joined: Thu May 03, 2018 9:57 pm

Re: Can orders be deleted? Company's retention policy requires I find a way.

Post by jtomoso » Wed May 09, 2018 2:56 pm

Thanks, Bob!

Is there a reference number for that requirement that you can pass along? I'll likely need that in conversations with my account rep.

BobRichards
Posts: 1007
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: Can orders be deleted? Company's retention policy requires I find a way.

Post by BobRichards » Wed May 09, 2018 3:15 pm

Sug 462091: Add ability to totally remove an Order

Be aware that I don't know where this suggestion fits in the scheme of current development or future obligations. It is simply submitted for review at this time.
Bob Richards, Software Developer, SoftPro

jtomoso
Posts: 3
Joined: Thu May 03, 2018 9:57 pm

Re: Can orders be deleted? Company's retention policy requires I find a way.

Post by jtomoso » Fri May 11, 2018 10:24 pm

No problem. I completely understand competing priorities. I'm curious, though, if you know of anyone who tried to do the delete on their own? Understanding, of course, that something like that wouldn't be recommended and likely not supported.

BobRichards
Posts: 1007
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: Can orders be deleted? Company's retention policy requires I find a way.

Post by BobRichards » Mon May 14, 2018 9:42 am

No. I don't know of anyone who attempted this with an eye towards doing it on a production system. They were doing integration tests. I am not sure how successful they were.
Bob Richards, Software Developer, SoftPro

Post Reply