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

Any idea why this doesn't work through my JDBC Connection?

```select EXTRACT (year FROM t."trandate")
from "TimeBill" t;```
I can use the EXTRACT function inside searches and workbooks..

It's my IDE (DataGrip) something to do with introspect settings

it let's me run queries without the quotes, but IntelliJ code completion wont pick up schema information/ etc. etc