AnsweredAssumed Answered

Query for searching Empty Settings

Question asked by Sam Sam on Oct 18, 2018
Latest reply on Oct 18, 2018 by Sam Sam

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?

Outcomes