In addition to: https://forum.solidworks.com/thread/225454
I tried to change query for searching of failures in Settings:
- for the current Vault:
SELECT Users.Username, Users.UserID, Settings.VarID, Settings.Value
FROM Users
INNER JOIN Settings ON Users.UserID = Settings.UserID
WHERE (Settings.VarID <44) AND (Users.Enabled = 1) AND (Settings.Value IS NULL)
- for the specified Vault:
SELECT Users.Username, Users.UserID, Settings.VarID, Settings.Value
FROM [Test].[dbo].[Users]
INNER JOIN Settings ON Users.UserID = Settings.UserID
WHERE (Settings.VarID <44) AND (Users.Enabled = 1) AND (Settings.Value IS NULL)
For check I wrote down NULL value. Everything works.
How it is necessary to change query that showed only empty cells?
And it is even better - only empty cells in all Vaults?
SolidworksSolidworks Pdm/enterprise Pdm