This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone know why I can’t do a `WHERE user = &lt;number&gt;` in a `SELECT * FROM loginaudit` ?

That is odd, and I'm seeing that, too.

What you can do - and I have no idea why this works - is something like this...
```SELECT TOP 10
	LoginAudit.*
FROM
	LoginAudit
	INNER JOIN Employee ON
		( Employee.ID = LoginAudit.User )
WHERE
	Employee.ID = &lt;number&gt;```

I’ll just get my desired user’s email addresses first and filter on that instead