Hi Chris,
There is one way that doesn't involve direct SQL updates.
You can get a process using a system action to set any status to "incomplete" , you can then update this.
Unfortunately unapproved is not a valid state once submitted for approval. (you can't go back)
Here's how....
Create a new process
- Link to idea object
- Create a system action to set to incomplete
- Set up start step to go to finish
- Validate
Create an action in the idea object
Add to the list view
Go to the idea list and select the idea to "unconvert", run the action from the "actions menu" this will now set it to "incomplete"