Skip to main content
Solved

Maintenance Survey Answers

  • March 28, 2023
  • 2 replies
  • 208 views

Forum|alt.badge.img+7
  • Sidekick (Customer)

Hi All,

Would you kindly advise if there is any possibility to clear Test Maintenance Survey answers stored from the MWO App on E-forms. Many thanks.
 

 

Best answer by anmise

You’ve done testing with a survey in mWO and would like to remove the records from the table?

From the client, it’s not possible, but I suppose you could setup a migration job to delete the records. 

If you use procedure Jt_Task_Survey_Answers_API.Remove__ you should be able to delete the records. 
I do not know what would happen with pictures and signatures if any, if you use this method, you may end up with orphan data.

 

 

2 replies

  • Superhero (Employee)
  • Answer
  • March 28, 2023

You’ve done testing with a survey in mWO and would like to remove the records from the table?

From the client, it’s not possible, but I suppose you could setup a migration job to delete the records. 

If you use procedure Jt_Task_Survey_Answers_API.Remove__ you should be able to delete the records. 
I do not know what would happen with pictures and signatures if any, if you use this method, you may end up with orphan data.

 

 


Forum|alt.badge.img+7
  • Author
  • Sidekick (Customer)
  • March 28, 2023

Hi @anmise actually you are correct. My intention was to see if there is any option to clear the Test Survey answers in the system in a Functional method in the Survey Answer page in Aurena. I guess based on your suggestion the only possible option would be setting up a Migration job to delete the records from the table. Thanks.