View: dbo.Payroll_Check_Payroll_Item_Distribution_View | |||
View definition | |||
-- ATM: I had a schema cleanup item that I checked in to the Dev branch on 8/26/2014 (changeset 1988860) which involved dropping the -- Payroll_Check_Tax_Item_Distribution and Payroll_Check_Payroll_Item_Distribution views. This was done because those views were -- not offering any additional functionality aside from access to their respective base tables. Apparently this caused issues with -- users who had set Department specific report filter options prior to that check in. Some of the report metadata is stored as an -- xml blob that contains tables/views that the filter option utilizes. In this case, the Department filter option was storing data -- that referred to the Payroll_Check_Payroll_Item_Distribution_View db object. This of course would cause issues since the views -- would be removed after my update was applied but the xml metadata for the filter would remain unchanged. One short term workaround -- option would be to remove and then re add the Department filter, which would update the xml metadata. The other option -- (which this update implements) just puts the PCPID view back. CREATE VIEW dbo.Payroll_Check_Payroll_Item_Distribution_View AS SELECT dbo.Payroll_Check_Payroll_Item_Distribution.* FROM dbo.Payroll_Check_Payroll_Item_Distribution | |||