SQL Script is invalid
SmartList Builder: When adding the select * from v_dd_invalid_timesheets I get “SQL script is invalid”
And this is in your “add sql script”, not a calculation?
Don’t see why it shouldn’t work for you if the name is valid. Or I guess if there isn’t a problem in the view itself that throws an error. You should turn on the dexsql.log and test this. Then look in the log to see the statement and the error. Pay attention to the context – you’ll see a “use” statement above the query to know what DB it should run in. By default it should run in your current company db
If you would like to submit an answer or comment, please sign in to the eOne portal.