【纯净版】组织-组织维护 about xms HOT 4 OPEN

db文件夹中的更新脚本执行一下

from xms.

db中的脚本执行了，打开还是报错，是不是查询的地方需要修改，但是我找不到查询的地方

from xms.

我也是 把 ModifiedBy 改成modifiedbyname 又提示我 ModifiedBy 错了

from xms.

我都改成 [ModifiedByName]了 ALTER VIEW [dbo].[OrganizationView] AS SELECT [Organization].[BaseCurrencyId], [Organization].[CreatedBy], [Organization].[CreatedOn], [Organization].[DataAccountName], [Organization].[DataBaseName], [Organization].[DataLogEnabled], [Organization].[DataPassword], [Organization].[DataServerName], [Organization].[Description], [Organization].[EmailSettings], [Organization].[LanguageId], [Organization].[ManagerId], [Organization].[ModifiedByName], [Organization].[ModifiedOn], [Organization].[Name], [Organization].[OrganizationId], [Organization].[SmsSettings], [Organization].[StateCode], [Organization].[StatusCode], [Organization].[UniqueName], [lk_Organization_BaseCurrencyId].[Name] AS BaseCurrencyIdName FROM [Organization] WITH(NOLOCK) LEFT JOIN [Currency] AS [lk_Organization_BaseCurrencyId] WITH(NOLOCK) ON [Organization].[BaseCurrencyId]=[lk_Organization_BaseCurrencyId].[CurrencyId] GO

from xms.