Creating new folder in workspace with SQL query

ItayZohar

Hi

I have a client who needs to add folders and sub folder dynamically after creating the WorkSpace.

Since the creation of the folders is dynamically' I need to add any folder with SQL query. As I checked, I need to add a line to PROJECTS table which describe the folder and connect it to the workspace or to the parent folder. I also need to increase the parameter in the table DOCNUMDB.

Do I have to do some other operation and queries to create the folder with queries?

Can you suggest a more safe way to create dynamic folders?

Thank you in advanced

Itay Zohar

Migrateduser

Hi, In my opinion, to add a subfolder is not as easy as you tell in your message, you don't have to update the the docnumdb table, because the only containers with docnum are the workspaces, they have a related xml file.

You have to check and update the sid_table, to get the prj_id correctly, and regarding with the projects table you have to update the left and right visit fields not only for the new line in projects, you will have to check for all the containers in the workspace.

Also take care with projects_nvps table if the folder needs to have a profile (custom1, custom2, ...)

Finally, I'm sure I'm forgetting places in which you should update the data, I think it would be better to use the API with a .NET function than using sql.

Regards
Javi