DECLARE @tsql VARCHAR(MAX) if exists (select * from sysobjects where id = object_id(N'vw_Indoo_template_0119a') and OBJECTPROPERTY(id, N'IsView') = 1) BEGIN drop view vw_Indoo_template_0119a end SET @tsql = 'CREATE VIEW vw_Indoo_template_0119a AS SELECT ''Module'' AS objectType, ModulePermission.ModuleID, TabModules.TabID, - 1 AS FolderID, ModulePermission.PermissionID, ModulePermission.AllowAccess, ModulePermission.RoleID, ModulePermission.UserID, Modules.PortalID FROM ModulePermission LEFT OUTER JOIN Modules ON ModulePermission.ModuleID = Modules.ModuleID FULL OUTER JOIN TabModules ON Modules.ModuleID = TabModules.ModuleID UNION SELECT ''Tab'' AS objectType, - 1 AS ModuleID, TabPermission.TabID, - 1 AS FolderID, TabPermission.PermissionID, TabPermission.AllowAccess, TabPermission.RoleID, TabPermission.UserID, Tabs.PortalID FROM TabPermission LEFT OUTER JOIN Tabs ON TabPermission.TabID = Tabs.TabID UNION SELECT ''Folder'' AS objectType, - 1 AS ModuleID, - 1 AS TabID, Folders.FolderID, Folders.PermissionID, Folders.AllowAccess, Folders.RoleID, Folders.UserID, Folders_1.PortalID FROM FolderPermission AS Folders LEFT OUTER JOIN Folders AS Folders_1 ON Folders.FolderID = Folders_1.FolderID ' EXEC (@tsql) GO DECLARE @tsql VARCHAR(MAX) if exists (select * from sysobjects where id = object_id(N'vw_Indoo_template_0119b') and OBJECTPROPERTY(id, N'IsView') = 1) BEGIN drop view vw_Indoo_template_0119b end SET @tsql = 'CREATE VIEW vw_Indoo_template_0119b AS SELECT vw_Indoo_template_0119a.objectType, Portals.PortalName AS Portals_PortalName, Modules.ModuleTitle AS Modules_ModuleTitle, Modules.AllTabs AS Modules_AllTabs, Modules.IsDeleted AS Modules_IsDeleted, ModuleDefinitions.FriendlyName AS ModuleDefinitions_FriendlyName, ModuleDefinitions.DesktopModuleID AS ModuleDefinitions_DesktopModuleID, ModuleDefinitions.ModuleDefID AS ModuleDefinitions_ModuleDefID, Tabs.TabName AS Tabs_TabName, vw_Indoo_template_0119a.ModuleID, vw_Indoo_template_0119a.TabID, vw_Indoo_template_0119a.FolderID, vw_Indoo_template_0119a.AllowAccess, vw_Indoo_template_0119a.RoleID, vw_Indoo_template_0119a.UserID, vw_Indoo_template_0119a.PortalID, Tabs.IsVisible AS Tabs_IsVisible, Tabs.Title AS Tabs_Title, Tabs.IsDeleted AS Tabs_IsDeleted, Tabs.IsSecure AS Tabs_IsSecure, Users.Username AS Users_username, Folders.IsProtected AS Folders_IsProtected, Folders.FolderPath AS Folders_FolderPath, Permission.PermissionName AS Permission_PermissionName, Roles.RoleName AS Roles_RoleName, Roles.AutoAssignment AS Roles_AutoAssignment FROM Folders RIGHT OUTER JOIN Roles RIGHT OUTER JOIN vw_Indoo_template_0119a INNER JOIN Portals ON vw_Indoo_template_0119a.PortalID = Portals.PortalID ON Roles.RoleID = vw_Indoo_template_0119a.RoleID LEFT OUTER JOIN Permission ON vw_Indoo_template_0119a.PermissionID = Permission.PermissionID LEFT OUTER JOIN Modules ON vw_Indoo_template_0119a.ModuleID = Modules.ModuleID ON Folders.FolderID = vw_Indoo_template_0119a.FolderID LEFT OUTER JOIN Users ON vw_Indoo_template_0119a.UserID = Users.UserID LEFT OUTER JOIN Tabs ON vw_Indoo_template_0119a.TabID = Tabs.TabID LEFT OUTER JOIN ModuleDefinitions ON Modules.ModuleDefID = ModuleDefinitions.ModuleDefID ' EXEC (@tsql) GO DECLARE @tsql VARCHAR(MAX) if exists (select * from sysobjects where id = object_id(N'vw_Indoo_template_0119c') and OBJECTPROPERTY(id, N'IsView') = 1) BEGIN drop view vw_Indoo_template_0119c end SET @tsql = 'CREATE VIEW vw_Indoo_template_0119c AS SELECT Portals.PortalName, Roles.RoleID, Roles.RoleName, Roles.RoleName + '' (pid:'' + CAST(Roles.PortalID AS nvarchar) +'', ''+ Portals.PortalName + '')'' AS pname FROM Roles LEFT OUTER JOIN Portals ON Roles.PortalID = Portals.PortalID ' EXEC (@tsql) binaryData.fileSytemDBPath gridView.recordcount 1 gridView.inlineEdit version 02.00.18 connectionType 0 connectionString tablename vw_Indoo_template_0119b tableKeyColumn moduleid showGridView on gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord 10,(20),100 showGridEdit on hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb on gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridview.sqlstatementquery gridView.gridDdlForm 0 alternateTablename alternateConnectionString gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader <script> if ('[numericquerystring:openuserid]'!='-1' && '[numericquerystring:openuserid]'!='' ){ document.location.href='default.aspx?[sqlQuery:SELECT '&tabid=' + CAST(TabModules.TabID AS nvarchar) + '&mid=' + CAST(Modules.ModuleID AS nvarchar) , userid FROM UserPortals INNER JOIN ModuleControls INNER JOIN Modules ON ModuleControls.ModuleDefID = Modules.ModuleDefID INNER JOIN TabModules ON Modules.ModuleID = TabModules.ModuleID ON UserPortals.PortalId = Modules.PortalID WHERE (ModuleControls.ControlSrc = N'Admin/Users/ManageUsers.ascx') AND (UserId = [numericquerystring:openuserid])]&userid=[numericquerystring:openuserid]&ctl=Edit&filter=All&currentpage=1' } </script> moduleFooter htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnUpdateFinishRecord sqlOnViewModule sqlOnViewRecord notSkipSqlOnImport on gridViewColumn.0.columnName objectType gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 3 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.isOther 0 gridViewColumn.9.columnName Portals_PortalName gridViewColumn.9.Visible on gridViewColumn.9.allowExport on gridViewColumn.9.allowEdit on gridViewColumn.9.allowFilter 1 gridViewColumn.9.allowSort on gridViewColumn.9.allowImport on gridViewColumn.9.isOther 0 gridViewColumn.11.columnName Modules_ModuleTitle gridViewColumn.11.Visible on gridViewColumn.11.allowExport on gridViewColumn.11.allowEdit on gridViewColumn.11.allowFilter 1 gridViewColumn.11.allowSort on gridViewColumn.11.allowImport on gridViewColumn.11.isOther 0 gridViewColumn.12.columnName Modules_AllTabs gridViewColumn.12.Visible on gridViewColumn.12.allowExport on gridViewColumn.12.allowEdit on gridViewColumn.12.allowFilter 1 gridViewColumn.12.allowSort on gridViewColumn.12.allowImport on gridViewColumn.12.isOther 0 gridViewColumn.13.columnName Modules_IsDeleted gridViewColumn.13.Visible on gridViewColumn.13.allowExport on gridViewColumn.13.allowEdit on gridViewColumn.13.allowFilter 1 gridViewColumn.13.allowSort on gridViewColumn.13.allowImport on gridViewColumn.13.isOther 0 gridViewColumn.14.columnName ModuleDefinitions_FriendlyName gridViewColumn.14.Visible on gridViewColumn.14.allowExport on gridViewColumn.14.allowEdit on gridViewColumn.14.allowFilter 3 gridViewColumn.14.allowSort on gridViewColumn.14.allowImport on gridViewColumn.14.isOther 0 gridViewColumn.15.columnName ModuleDefinitions_DesktopModuleID gridViewColumn.15.Visible on gridViewColumn.15.allowExport on gridViewColumn.15.allowEdit on gridViewColumn.15.allowFilter 1 gridViewColumn.15.allowSort on gridViewColumn.15.allowImport on gridViewColumn.15.isOther 0 gridViewColumn.16.columnName ModuleDefinitions_ModuleDefID gridViewColumn.16.Visible on gridViewColumn.16.allowExport on gridViewColumn.16.allowEdit on gridViewColumn.16.allowFilter 1 gridViewColumn.16.allowSort on gridViewColumn.16.allowImport on gridViewColumn.16.isOther 0 gridViewColumn.18.columnName Tabs_TabName gridViewColumn.18.Visible on gridViewColumn.18.allowExport on gridViewColumn.18.allowEdit on gridViewColumn.18.allowFilter 1 gridViewColumn.18.allowSort on gridViewColumn.18.allowImport on gridViewColumn.18.isOther 0 gridViewColumn.17.columnName TabID gridViewColumn.17.Visible on gridViewColumn.17.allowExport on gridViewColumn.17.allowEdit on gridViewColumn.17.allowFilter 1 gridViewColumn.17.allowSort on gridViewColumn.17.allowImport on gridViewColumn.17.isOther 0 gridViewColumn.23.columnName FolderID gridViewColumn.23.Visible on gridViewColumn.23.allowExport on gridViewColumn.23.allowEdit on gridViewColumn.23.allowFilter 1 gridViewColumn.23.allowSort on gridViewColumn.23.allowImport on gridViewColumn.23.isOther 0 gridViewColumn.2.columnName AllowAccess gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridViewColumn.2.isOther 0 gridViewColumn.5.columnName RoleID gridViewColumn.5.Visible on gridViewColumn.5.allowExport on gridViewColumn.5.allowEdit on gridViewColumn.5.allowFilter 3 gridViewColumn.5.allowSort on gridViewColumn.5.allowImport on gridViewColumn.5.isOther 0 gridViewColumn.3.columnName UserID gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridViewColumn.3.isOther 0 gridViewColumn.8.columnName PortalID gridViewColumn.8.Visible on gridViewColumn.8.allowExport on gridViewColumn.8.allowEdit on gridViewColumn.8.allowFilter 3 gridViewColumn.8.allowSort on gridViewColumn.8.allowImport on gridViewColumn.8.isOther 0 gridViewColumn.19.columnName Tabs_IsVisible gridViewColumn.19.Visible on gridViewColumn.19.allowExport on gridViewColumn.19.allowEdit on gridViewColumn.19.allowFilter 1 gridViewColumn.19.allowSort on gridViewColumn.19.allowImport on gridViewColumn.19.isOther 0 gridViewColumn.20.columnName Tabs_Title gridViewColumn.20.Visible on gridViewColumn.20.allowExport on gridViewColumn.20.allowEdit on gridViewColumn.20.allowFilter 1 gridViewColumn.20.allowSort on gridViewColumn.20.allowImport on gridViewColumn.20.isOther 0 gridViewColumn.21.columnName Tabs_IsDeleted gridViewColumn.21.Visible on gridViewColumn.21.allowExport on gridViewColumn.21.allowEdit on gridViewColumn.21.allowFilter 1 gridViewColumn.21.allowSort on gridViewColumn.21.allowImport on gridViewColumn.21.isOther 0 gridViewColumn.22.columnName Tabs_IsSecure gridViewColumn.22.Visible on gridViewColumn.22.allowExport on gridViewColumn.22.allowEdit on gridViewColumn.22.allowFilter 1 gridViewColumn.22.allowSort on gridViewColumn.22.allowImport on gridViewColumn.22.isOther 0 gridViewColumn.4.columnName Users_username gridViewColumn.4.Visible on gridViewColumn.4.allowExport on gridViewColumn.4.allowEdit on gridViewColumn.4.allowFilter 1 gridViewColumn.4.allowSort on gridViewColumn.4.allowImport on gridViewColumn.4.isOther 0 gridViewColumn.24.columnName Folders_IsProtected gridViewColumn.24.Visible on gridViewColumn.24.allowExport on gridViewColumn.24.allowEdit on gridViewColumn.24.allowFilter 1 gridViewColumn.24.allowSort on gridViewColumn.24.allowImport on gridViewColumn.24.isOther 0 gridViewColumn.25.columnName Folders_FolderPath gridViewColumn.25.Visible on gridViewColumn.25.allowExport on gridViewColumn.25.allowEdit on gridViewColumn.25.allowFilter 1 gridViewColumn.25.allowSort on gridViewColumn.25.allowImport on gridViewColumn.25.isOther 0 gridViewColumn.1.columnName Permission_PermissionName gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 3 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.isOther 0 gridViewColumn.0.caption Object gridViewColumn.9.caption PortalName gridViewColumn.11.caption ModuleTitle gridViewColumn.12.caption AllTabs gridViewColumn.13.caption IsDeleted gridViewColumn.14.caption FriendlyName gridViewColumn.15.caption DesktopModuleID gridViewColumn.16.caption ModuleDefID gridViewColumn.18.caption TabName (page) gridViewColumn.17.caption gridViewColumn.23.caption gridViewColumn.2.caption Access gridViewColumn.5.caption gridViewColumn.3.caption gridViewColumn.8.caption gridViewColumn.19.caption IsVisible gridViewColumn.20.caption Title gridViewColumn.21.caption IsDeleted gridViewColumn.22.caption IsSecure gridViewColumn.4.caption Username gridViewColumn.24.caption IsProtected gridViewColumn.25.caption FolderPath gridViewColumn.1.caption Permission gridViewColumn.10.Visible on gridViewColumn.10.allowExport on gridViewColumn.10.allowEdit on gridViewColumn.10.allowFilter 1 gridViewColumn.10.allowSort on gridViewColumn.10.allowImport on gridViewColumn.10.columnName ModuleID gridViewColumn.10.caption gridViewColumn.10.width gridViewColumn.10.defaultContent gridViewColumn.10.formatData gridViewColumn.10.importDefault gridViewColumn.10.filterAdditionalColumn gridViewColumn.10.defaultSortColumn gridViewColumn.10.isBoolean gridViewColumn.10.isLink gridViewColumn.10.isOther 0 gridViewColumn.10.isBinary gridViewColumn.10.isJoin gridViewColumn.10.isHtmlAttributes gridViewColumn.6.Visible on gridViewColumn.6.allowExport on gridViewColumn.6.allowEdit on gridViewColumn.6.allowFilter 1 gridViewColumn.6.allowSort on gridViewColumn.6.allowImport on gridViewColumn.6.columnName Roles_RoleName gridViewColumn.6.caption RoleName gridViewColumn.6.width gridViewColumn.6.defaultContent gridViewColumn.6.formatData gridViewColumn.6.importDefault gridViewColumn.6.filterAdditionalColumn gridViewColumn.6.defaultSortColumn gridViewColumn.6.isBoolean gridViewColumn.6.isLink gridViewColumn.6.isOther 0 gridViewColumn.6.isBinary gridViewColumn.6.isJoin gridViewColumn.6.isHtmlAttributes gridViewColumn.7.Visible on gridViewColumn.7.allowExport on gridViewColumn.7.allowEdit on gridViewColumn.7.allowFilter 1 gridViewColumn.7.allowSort on gridViewColumn.7.allowImport on gridViewColumn.7.columnName Roles_AutoAssignment gridViewColumn.7.caption Auto gridViewColumn.7.width gridViewColumn.7.defaultContent gridViewColumn.7.formatData gridViewColumn.7.importDefault gridViewColumn.7.filterAdditionalColumn gridViewColumn.7.defaultSortColumn gridViewColumn.7.isBoolean gridViewColumn.7.isLink gridViewColumn.7.isOther 0 gridViewColumn.7.isBinary gridViewColumn.7.isJoin gridViewColumn.7.isHtmlAttributes gridViewColumn.0.width gridViewColumn.0.defaultContent gridViewColumn.0.formatData gridViewColumn.0.importDefault gridViewColumn.0.filterAdditionalColumn gridViewColumn.0.defaultSortColumn gridViewColumn.0.isBoolean gridViewColumn.0.isLink gridViewColumn.0.isBinary gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.0.ddlType 2 gridViewColumn.0.filterAutoFire on gridViewColumn.0.ddlList Folder;Folder Module;Module Tab;Tab gridViewColumn.0.ddlDefaultValue gridViewColumn.0.ddlNullText gridViewColumn.0.ddlAllOption on gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isBinary gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.1.ddlType 1 gridViewColumn.1.filterAutoFire on gridViewColumn.1.ddlTable Permission gridViewColumn.1.ddlSQLWhere gridViewColumn.1.sourceValueColumnName PermissionName gridViewColumn.1.sourceTextColumnName PermissionName gridViewColumn.1.ddlDefaultValue gridViewColumn.1.ddlNullText gridViewColumn.1.ddlAllOption on gridViewColumn.5.width gridViewColumn.5.defaultContent gridViewColumn.5.formatData gridViewColumn.5.importDefault gridViewColumn.5.filterAdditionalColumn gridViewColumn.5.defaultSortColumn gridViewColumn.5.isBoolean gridViewColumn.5.isLink gridViewColumn.5.isBinary gridViewColumn.5.isJoin gridViewColumn.5.isHtmlAttributes gridViewColumn.5.ddlType 1 gridViewColumn.5.filterAutoFire on gridViewColumn.5.ddlTable vw_Indoo_template_0119c gridViewColumn.5.ddlSQLWhere gridViewColumn.5.sourceValueColumnName RoleID gridViewColumn.5.sourceTextColumnName pname gridViewColumn.5.ddlDefaultValue gridViewColumn.5.ddlNullText gridViewColumn.5.ddlAllOption on gridViewColumn.8.width gridViewColumn.8.defaultContent gridViewColumn.8.formatData gridViewColumn.8.importDefault gridViewColumn.8.filterAdditionalColumn gridViewColumn.8.defaultSortColumn gridViewColumn.8.isBoolean gridViewColumn.8.isLink gridViewColumn.8.isBinary gridViewColumn.8.isJoin gridViewColumn.8.isHtmlAttributes gridViewColumn.8.ddlType 1 gridViewColumn.8.filterAutoFire on gridViewColumn.8.ddlTable Portals gridViewColumn.8.ddlSQLWhere gridViewColumn.8.sourceValueColumnName PortalID gridViewColumn.8.sourceTextColumnName PortalName gridViewColumn.8.ddlDefaultValue gridViewColumn.8.ddlNullText gridViewColumn.8.ddlAllOption on gridViewColumn.14.width gridViewColumn.14.defaultContent gridViewColumn.14.formatData gridViewColumn.14.importDefault gridViewColumn.14.filterAdditionalColumn gridViewColumn.14.defaultSortColumn gridViewColumn.14.isBoolean gridViewColumn.14.isLink gridViewColumn.14.isBinary gridViewColumn.14.isJoin gridViewColumn.14.isHtmlAttributes gridViewColumn.14.ddlType 1 gridViewColumn.14.filterAutoFire on gridViewColumn.14.ddlTable ModuleDefinitions gridViewColumn.14.ddlSQLWhere gridViewColumn.14.sourceValueColumnName FriendlyName gridViewColumn.14.sourceTextColumnName FriendlyName gridViewColumn.14.ddlDefaultValue gridViewColumn.14.ddlNullText gridViewColumn.14.ddlAllOption on gridViewColumn.17.width gridViewColumn.17.defaultContent gridViewColumn.17.formatData gridViewColumn.17.importDefault gridViewColumn.17.filterAdditionalColumn gridViewColumn.17.defaultSortColumn gridViewColumn.17.isBoolean gridViewColumn.17.isLink gridViewColumn.17.isBinary gridViewColumn.17.isJoin gridViewColumn.17.isHtmlAttributes gridViewColumn.18.width gridViewColumn.18.defaultContent gridViewColumn.18.formatData gridViewColumn.18.importDefault gridViewColumn.18.filterAdditionalColumn gridViewColumn.18.defaultSortColumn gridViewColumn.18.isBoolean gridViewColumn.18.isLink on gridViewColumn.18.isBinary gridViewColumn.18.isJoin gridViewColumn.18.isHtmlAttributes gridViewColumn.18.navigateUrl gridViewColumn.18.navigateUrlParameterName tabid gridViewColumn.18.navigateUrlParameterColumn TabID gridViewColumn.18.navigateUrlTarget _blank gridViewColumn.18.urlAddCommand 0 gridViewColumn.18.navigateUrlIsButton gridViewColumn.4.width gridViewColumn.4.defaultContent gridViewColumn.4.formatData gridViewColumn.4.importDefault gridViewColumn.4.filterAdditionalColumn gridViewColumn.4.defaultSortColumn gridViewColumn.4.isBoolean gridViewColumn.4.isLink on gridViewColumn.4.isBinary gridViewColumn.4.isJoin gridViewColumn.4.isHtmlAttributes gridViewColumn.4.navigateUrl gridViewColumn.4.navigateUrlParameterName openuserid gridViewColumn.4.navigateUrlParameterColumn UserID gridViewColumn.4.navigateUrlTarget _blank gridViewColumn.4.urlAddCommand 0 gridViewColumn.4.navigateUrlIsButton binaryData.fileSytemDBPath |DataDirectory|indooGrid\ gridView.recordcount 1 gridView.inlineEdit version 02.00.18 connectionType 0 connectionString tablename vw_Indoo_template_0119b tableKeyColumn moduleid showGridView on gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord 10,(20),100 showGridEdit on hidegridviewonedit grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb on gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridview.sqlstatementquery gridView.gridDdlForm 0 alternateTablename alternateConnectionString gridView.ID gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader <script> if ('[numericquerystring:openuserid]'!='-1' && '[numericquerystring:openuserid]'!='' ){ document.location.href='default.aspx?[sqlQuery:SELECT '&tabid=' + CAST(TabModules.TabID AS nvarchar) + '&mid=' + CAST(Modules.ModuleID AS nvarchar) , userid FROM UserPortals INNER JOIN ModuleControls INNER JOIN Modules ON ModuleControls.ModuleDefID = Modules.ModuleDefID INNER JOIN TabModules ON Modules.ModuleID = TabModules.ModuleID ON UserPortals.PortalId = Modules.PortalID WHERE (ModuleControls.ControlSrc = N'Admin/Users/ManageUsers.ascx') AND (UserId = [numericquerystring:openuserid])]&userid=[numericquerystring:openuserid]&ctl=Edit&filter=All&currentpage=1' } </script> moduleFooter htmlHeadBlock startupScriptBlock onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnUpdateFinishRecord sqlOnViewModule sqlOnViewRecord notSkipSqlOnImport on gridViewColumn.0.columnName objectType gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 3 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridViewColumn.0.isOther 0 gridViewColumn.9.columnName Portals_PortalName gridViewColumn.9.Visible on gridViewColumn.9.allowExport on gridViewColumn.9.allowEdit on gridViewColumn.9.allowFilter 1 gridViewColumn.9.allowSort on gridViewColumn.9.allowImport on gridViewColumn.9.isOther 0 gridViewColumn.11.columnName Modules_ModuleTitle gridViewColumn.11.Visible on gridViewColumn.11.allowExport on gridViewColumn.11.allowEdit on gridViewColumn.11.allowFilter 1 gridViewColumn.11.allowSort on gridViewColumn.11.allowImport on gridViewColumn.11.isOther 0 gridViewColumn.12.columnName Modules_AllTabs gridViewColumn.12.Visible on gridViewColumn.12.allowExport on gridViewColumn.12.allowEdit on gridViewColumn.12.allowFilter 1 gridViewColumn.12.allowSort on gridViewColumn.12.allowImport on gridViewColumn.12.isOther 0 gridViewColumn.13.columnName Modules_IsDeleted gridViewColumn.13.Visible on gridViewColumn.13.allowExport on gridViewColumn.13.allowEdit on gridViewColumn.13.allowFilter 1 gridViewColumn.13.allowSort on gridViewColumn.13.allowImport on gridViewColumn.13.isOther 0 gridViewColumn.14.columnName ModuleDefinitions_FriendlyName gridViewColumn.14.Visible on gridViewColumn.14.allowExport on gridViewColumn.14.allowEdit on gridViewColumn.14.allowFilter 3 gridViewColumn.14.allowSort on gridViewColumn.14.allowImport on gridViewColumn.14.isOther 0 gridViewColumn.15.columnName ModuleDefinitions_DesktopModuleID gridViewColumn.15.Visible on gridViewColumn.15.allowExport on gridViewColumn.15.allowEdit on gridViewColumn.15.allowFilter 1 gridViewColumn.15.allowSort on gridViewColumn.15.allowImport on gridViewColumn.15.isOther 0 gridViewColumn.16.columnName ModuleDefinitions_ModuleDefID gridViewColumn.16.Visible on gridViewColumn.16.allowExport on gridViewColumn.16.allowEdit on gridViewColumn.16.allowFilter 1 gridViewColumn.16.allowSort on gridViewColumn.16.allowImport on gridViewColumn.16.isOther 0 gridViewColumn.18.columnName Tabs_TabName gridViewColumn.18.Visible on gridViewColumn.18.allowExport on gridViewColumn.18.allowEdit on gridViewColumn.18.allowFilter 1 gridViewColumn.18.allowSort on gridViewColumn.18.allowImport on gridViewColumn.18.isOther 0 gridViewColumn.17.columnName TabID gridViewColumn.17.Visible on gridViewColumn.17.allowExport on gridViewColumn.17.allowEdit on gridViewColumn.17.allowFilter 1 gridViewColumn.17.allowSort on gridViewColumn.17.allowImport on gridViewColumn.17.isOther 0 gridViewColumn.23.columnName FolderID gridViewColumn.23.Visible on gridViewColumn.23.allowExport on gridViewColumn.23.allowEdit on gridViewColumn.23.allowFilter 1 gridViewColumn.23.allowSort on gridViewColumn.23.allowImport on gridViewColumn.23.isOther 0 gridViewColumn.2.columnName AllowAccess gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridViewColumn.2.isOther 0 gridViewColumn.5.columnName RoleID gridViewColumn.5.Visible on gridViewColumn.5.allowExport on gridViewColumn.5.allowEdit on gridViewColumn.5.allowFilter 3 gridViewColumn.5.allowSort on gridViewColumn.5.allowImport on gridViewColumn.5.isOther 0 gridViewColumn.3.columnName UserID gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridViewColumn.3.isOther 0 gridViewColumn.8.columnName PortalID gridViewColumn.8.Visible on gridViewColumn.8.allowExport on gridViewColumn.8.allowEdit on gridViewColumn.8.allowFilter 3 gridViewColumn.8.allowSort on gridViewColumn.8.allowImport on gridViewColumn.8.isOther 0 gridViewColumn.19.columnName Tabs_IsVisible gridViewColumn.19.Visible on gridViewColumn.19.allowExport on gridViewColumn.19.allowEdit on gridViewColumn.19.allowFilter 1 gridViewColumn.19.allowSort on gridViewColumn.19.allowImport on gridViewColumn.19.isOther 0 gridViewColumn.20.columnName Tabs_Title gridViewColumn.20.Visible on gridViewColumn.20.allowExport on gridViewColumn.20.allowEdit on gridViewColumn.20.allowFilter 1 gridViewColumn.20.allowSort on gridViewColumn.20.allowImport on gridViewColumn.20.isOther 0 gridViewColumn.21.columnName Tabs_IsDeleted gridViewColumn.21.Visible on gridViewColumn.21.allowExport on gridViewColumn.21.allowEdit on gridViewColumn.21.allowFilter 1 gridViewColumn.21.allowSort on gridViewColumn.21.allowImport on gridViewColumn.21.isOther 0 gridViewColumn.22.columnName Tabs_IsSecure gridViewColumn.22.Visible on gridViewColumn.22.allowExport on gridViewColumn.22.allowEdit on gridViewColumn.22.allowFilter 1 gridViewColumn.22.allowSort on gridViewColumn.22.allowImport on gridViewColumn.22.isOther 0 gridViewColumn.4.columnName Users_username gridViewColumn.4.Visible on gridViewColumn.4.allowExport on gridViewColumn.4.allowEdit on gridViewColumn.4.allowFilter 1 gridViewColumn.4.allowSort on gridViewColumn.4.allowImport on gridViewColumn.4.isOther 0 gridViewColumn.24.columnName Folders_IsProtected gridViewColumn.24.Visible on gridViewColumn.24.allowExport on gridViewColumn.24.allowEdit on gridViewColumn.24.allowFilter 1 gridViewColumn.24.allowSort on gridViewColumn.24.allowImport on gridViewColumn.24.isOther 0 gridViewColumn.25.columnName Folders_FolderPath gridViewColumn.25.Visible on gridViewColumn.25.allowExport on gridViewColumn.25.allowEdit on gridViewColumn.25.allowFilter 1 gridViewColumn.25.allowSort on gridViewColumn.25.allowImport on gridViewColumn.25.isOther 0 gridViewColumn.1.columnName Permission_PermissionName gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 3 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridViewColumn.1.isOther 0 gridViewColumn.0.caption Object gridViewColumn.9.caption PortalName gridViewColumn.11.caption ModuleTitle gridViewColumn.12.caption AllTabs gridViewColumn.13.caption IsDeleted gridViewColumn.14.caption FriendlyName gridViewColumn.15.caption DesktopModuleID gridViewColumn.16.caption ModuleDefID gridViewColumn.18.caption TabName (page) gridViewColumn.17.caption gridViewColumn.23.caption gridViewColumn.2.caption Access gridViewColumn.5.caption gridViewColumn.3.caption gridViewColumn.8.caption gridViewColumn.19.caption IsVisible gridViewColumn.20.caption Title gridViewColumn.21.caption IsDeleted gridViewColumn.22.caption IsSecure gridViewColumn.4.caption Username gridViewColumn.24.caption IsProtected gridViewColumn.25.caption FolderPath gridViewColumn.1.caption Permission gridViewColumn.10.Visible on gridViewColumn.10.allowExport on gridViewColumn.10.allowEdit on gridViewColumn.10.allowFilter 1 gridViewColumn.10.allowSort on gridViewColumn.10.allowImport on gridViewColumn.10.columnName ModuleID gridViewColumn.10.caption gridViewColumn.10.width gridViewColumn.10.defaultContent gridViewColumn.10.formatData gridViewColumn.10.importDefault gridViewColumn.10.filterAdditionalColumn gridViewColumn.10.defaultSortColumn gridViewColumn.10.isBoolean gridViewColumn.10.isLink gridViewColumn.10.isOther 0 gridViewColumn.10.isBinary gridViewColumn.10.isJoin gridViewColumn.10.isHtmlAttributes gridViewColumn.6.Visible on gridViewColumn.6.allowExport on gridViewColumn.6.allowEdit on gridViewColumn.6.allowFilter 1 gridViewColumn.6.allowSort on gridViewColumn.6.allowImport on gridViewColumn.6.columnName Roles_RoleName gridViewColumn.6.caption RoleName gridViewColumn.6.width gridViewColumn.6.defaultContent gridViewColumn.6.formatData gridViewColumn.6.importDefault gridViewColumn.6.filterAdditionalColumn gridViewColumn.6.defaultSortColumn gridViewColumn.6.isBoolean gridViewColumn.6.isLink gridViewColumn.6.isOther 0 gridViewColumn.6.isBinary gridViewColumn.6.isJoin gridViewColumn.6.isHtmlAttributes gridViewColumn.7.Visible on gridViewColumn.7.allowExport on gridViewColumn.7.allowEdit on gridViewColumn.7.allowFilter 1 gridViewColumn.7.allowSort on gridViewColumn.7.allowImport on gridViewColumn.7.columnName Roles_AutoAssignment gridViewColumn.7.caption Auto gridViewColumn.7.width gridViewColumn.7.defaultContent gridViewColumn.7.formatData gridViewColumn.7.importDefault gridViewColumn.7.filterAdditionalColumn gridViewColumn.7.defaultSortColumn gridViewColumn.7.isBoolean gridViewColumn.7.isLink gridViewColumn.7.isOther 0 gridViewColumn.7.isBinary gridViewColumn.7.isJoin gridViewColumn.7.isHtmlAttributes gridViewColumn.0.width gridViewColumn.0.defaultContent gridViewColumn.0.formatData gridViewColumn.0.importDefault gridViewColumn.0.filterAdditionalColumn gridViewColumn.0.defaultSortColumn gridViewColumn.0.isBoolean gridViewColumn.0.isLink gridViewColumn.0.isBinary gridViewColumn.0.isJoin gridViewColumn.0.isHtmlAttributes gridViewColumn.0.ddlType 2 gridViewColumn.0.filterAutoFire on gridViewColumn.0.ddlList Folder;Folder Module;Module Tab;Tab gridViewColumn.0.ddlDefaultValue gridViewColumn.0.ddlNullText gridViewColumn.0.ddlAllOption on gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isBinary gridViewColumn.1.isJoin gridViewColumn.1.isHtmlAttributes gridViewColumn.1.ddlType 1 gridViewColumn.1.filterAutoFire on gridViewColumn.1.ddlTable Permission gridViewColumn.1.ddlSQLWhere gridViewColumn.1.sourceValueColumnName PermissionName gridViewColumn.1.sourceTextColumnName PermissionName gridViewColumn.1.ddlDefaultValue gridViewColumn.1.ddlNullText gridViewColumn.1.ddlAllOption on gridViewColumn.5.width gridViewColumn.5.defaultContent gridViewColumn.5.formatData gridViewColumn.5.importDefault gridViewColumn.5.filterAdditionalColumn gridViewColumn.5.defaultSortColumn gridViewColumn.5.isBoolean gridViewColumn.5.isLink gridViewColumn.5.isBinary gridViewColumn.5.isJoin gridViewColumn.5.isHtmlAttributes gridViewColumn.5.ddlType 1 gridViewColumn.5.filterAutoFire on gridViewColumn.5.ddlTable vw_Indoo_template_0119c gridViewColumn.5.ddlSQLWhere gridViewColumn.5.sourceValueColumnName RoleID gridViewColumn.5.sourceTextColumnName pname gridViewColumn.5.ddlDefaultValue gridViewColumn.5.ddlNullText gridViewColumn.5.ddlAllOption on gridViewColumn.8.width gridViewColumn.8.defaultContent gridViewColumn.8.formatData gridViewColumn.8.importDefault gridViewColumn.8.filterAdditionalColumn gridViewColumn.8.defaultSortColumn gridViewColumn.8.isBoolean gridViewColumn.8.isLink gridViewColumn.8.isBinary gridViewColumn.8.isJoin gridViewColumn.8.isHtmlAttributes gridViewColumn.8.ddlType 1 gridViewColumn.8.filterAutoFire on gridViewColumn.8.ddlTable Portals gridViewColumn.8.ddlSQLWhere gridViewColumn.8.sourceValueColumnName PortalID gridViewColumn.8.sourceTextColumnName PortalName gridViewColumn.8.ddlDefaultValue gridViewColumn.8.ddlNullText gridViewColumn.8.ddlAllOption on gridViewColumn.14.width gridViewColumn.14.defaultContent gridViewColumn.14.formatData gridViewColumn.14.importDefault gridViewColumn.14.filterAdditionalColumn gridViewColumn.14.defaultSortColumn gridViewColumn.14.isBoolean gridViewColumn.14.isLink gridViewColumn.14.isBinary gridViewColumn.14.isJoin gridViewColumn.14.isHtmlAttributes gridViewColumn.14.ddlType 1 gridViewColumn.14.filterAutoFire on gridViewColumn.14.ddlTable ModuleDefinitions gridViewColumn.14.ddlSQLWhere gridViewColumn.14.sourceValueColumnName FriendlyName gridViewColumn.14.sourceTextColumnName FriendlyName gridViewColumn.14.ddlDefaultValue gridViewColumn.14.ddlNullText gridViewColumn.14.ddlAllOption on gridViewColumn.17.width gridViewColumn.17.defaultContent gridViewColumn.17.formatData gridViewColumn.17.importDefault gridViewColumn.17.filterAdditionalColumn gridViewColumn.17.defaultSortColumn gridViewColumn.17.isBoolean gridViewColumn.17.isLink gridViewColumn.17.isBinary gridViewColumn.17.isJoin gridViewColumn.17.isHtmlAttributes gridViewColumn.18.width gridViewColumn.18.defaultContent gridViewColumn.18.formatData gridViewColumn.18.importDefault gridViewColumn.18.filterAdditionalColumn gridViewColumn.18.defaultSortColumn gridViewColumn.18.isBoolean gridViewColumn.18.isLink on gridViewColumn.18.isBinary gridViewColumn.18.isJoin gridViewColumn.18.isHtmlAttributes gridViewColumn.18.navigateUrl gridViewColumn.18.navigateUrlParameterName tabid gridViewColumn.18.navigateUrlParameterColumn TabID gridViewColumn.18.navigateUrlTarget _blank gridViewColumn.18.urlAddCommand 0 gridViewColumn.18.navigateUrlIsButton gridViewColumn.4.width gridViewColumn.4.defaultContent gridViewColumn.4.formatData gridViewColumn.4.importDefault gridViewColumn.4.filterAdditionalColumn gridViewColumn.4.defaultSortColumn gridViewColumn.4.isBoolean gridViewColumn.4.isLink on gridViewColumn.4.isBinary gridViewColumn.4.isJoin gridViewColumn.4.isHtmlAttributes gridViewColumn.4.navigateUrl gridViewColumn.4.navigateUrlParameterName openuserid gridViewColumn.4.navigateUrlParameterColumn UserID gridViewColumn.4.navigateUrlTarget _blank gridViewColumn.4.urlAddCommand 0 gridViewColumn.4.navigateUrlIsButton