Skip to Content
0
May 27, 2014 at 08:35 PM

Auto Refresh for FMS not working

165 Views

I have created an FMS for an existing field on an add-on to be triggered by change of an existing column, but while the column changes, the only way to get the FMS to activate is to click on the magnifying glass. Any ideas?

Here is the FMS Query...

SELECT CAST(CAST(DATEPART(YYYY,GETDATE()) as Nvarchar(30))

+ CASE

WHEN CAST(DatePart(MM,GETDATE()) as NVARCHAR(30)) < 10

THEN '0' + CAST(DatePart(MM,GETDATE()) as NVARCHAR(30))

ELSE CAST(DatePart(MM,GETDATE()) as NVARCHAR(30))

END + CASE

WHEN CAST(DatePart(DD,GETDATE()) as NVARCHAR(30)) < 10

THEN '0' + CAST(DatePart(DD,GETDATE()) as NVARCHAR(30))

ELSE CAST(DatePart(DD,GETDATE()) as NVARCHAR(30))

END as NVARCHAR(8)) AS UpdateDate

FOR BROWSE

And attached is a screenshot of the FMS setup...

Any help is greatly appreciated.