deleting and renaming Projects

lturner

Hello! Wondering if I'm missing something simple. Is there a way to delete projects? How about rename them? Thank you!

Version 8.21.1.73155

Andrew_Decisions

Hello!

Thank you for using the Decisions forum!

There is no direct way to rename a project in Decisions. You can create a new project with the new name and move elements into that new project. Alternatively, you can change the name of a project using the Query Editor. It is recommended to take a database backup before making any changes to the database.

Here is our documentation regarding the Query Editor.

https://documentation.decisions.com/v8/docs/query-editor#accessing-the-query-editor

The projects are in the table module_resource, so if you want to see it a query like: 

SELECT * FROM module_resource WHERE module_name = 'name of your project'

To change the name, simply use a query to change the module_name like so:

UPDATE module_resource 

SET module_name = 'New Name' 

WHERE module_name = 'Original Name';

Restart services after the queries and the changes should be reflected in the Decisions UI.

Do you have a Repository setup for your environment?

If you have a Repository setup, you can right-click the project in the Repository and select "Delete Project." Confirm the deletion by clicking "YES." For more details, you can refer to the Using The Repository documentation below.

https://documentation.decisions.com/docs/using-the-repository

If you do not have a Repository setup you should be able to right click the project and select "Manage" and the delete action should be there.

If there is no way to delete the project from the UI then you can utilize the Query Editor to delete a project. To reiterate, taking a database backup before making any database changes is recommended. The query to delete a project is below:

DELETE FROM entity_folder WHERE folder_id = <project_folder_id>

Make sure to take proper backups and test queries inside a test environment first before utilizing them in a production environment.

Thank you again for using the forums!

Best regards,

Andrew || Decisions Support

lturner

Thank you!