Diversity projects

Download

Additional query column Hierarchy
Additional query options for presence of agent, license, reference, resource and descriptor
Archive: AgentRole included, Bugfix getting table data, several bugfixes restoring archive
Table editors: ProjectSettings included and bugfix for editing data
Database updates
- 02.01.25: ProjectArchive etc.: Missing permissions; ProjectUser: Adding ReadOnly for locking a project; ProjectHierarchyAll for listing projects including hierarchy; View_ProjectHierarchyAll: Content of function ProjectHierarchyAll;

SQL Server 2016

For this version you need SQL Server 2016 or higher

New table JsonCache containing the data related to a project as JSON. In the menu accessible via Administration → Json cache … or in the header click on the Show JsonCache button to see the json cache for the current project.
Database updates
- 02.01.26: Table JsonCache; Views JsonCache_FullAccess and JsonCache_Public; procFillJsonCache; setting Project in function ProjectParents to nvarchar(255); setting Project in function ProjectHierarchy to nvarchar(255); setting Project in function ProjectChildNodes to nvarchar(255);

02.01.24: Disabling Regulation in ProjectType_Enum; setting Project.ProjectDescription to nvarchar(MAX); setting ProjectDescription in function ProjectParents to nvarchar(MAX); setting ProjectDescription in function ProjectHierarchy to nvarchar(MAX); setting ProjectDescription in function ProjectChildNodes to nvarchar(MAX);

02.01.23: Missing Descriptions; View_ProjectDescriptor and View_ProjectSetting for query; Generic SetUserProjects; ProjectAgentRole_Enum - Data Owner and Source Institution if missing; new function ProjectDataLastChanges; Set types if missing;