I want to make saved views of the data my contractor has edited in SQL Server Management Studio so I can delegate watching a contractor's progress to a person who can just see it in front of them easily. The contractor's data is in a child version. I can seem to make a query that works but not a view that I can save within the database. This is the sql query that works:
USE [DatabaseName]
GO
EXEC dbo.set_current_version'UserNameValueHere.VersionNameValueHere'
SELECT *
FROM [dbo].[StormwaterPipe_evw]
WHERE (created_user = 'UserNameValueHere' or last_edited_user = 'UserNameValueHere') AND (created_date >= '2018-02-01' or last_edited_date >= '2018-02-01')
ORDER BY created_date
GO
