How To Move Hidden Items To Another Project

benji

How do I move all the hidden items in a project to another project in bulk? If I have hundreds of hidden items, I cannot simply select all of them because it is tedious.

kairo_Decisions

*We recommend taking a database backup before running queries*

Here is a sample query that will do this:

UPDATE module_resource

SET 

  module_name = @NEWPROJECTNAME

where entity_id in

(

SELECT id

FROM entity_header_data

where hidden = 'True'

)

and module_name = @ORIGINALPROJECTNAME

In the event that you do want to select the items in the Decisions UI, you can copy designer projects and simply choose what items to exclude. https://documentation.decisions.com/docs/creating-a-designer-folder#copy-a-designer-project