Winscribe - Exporter (Bug Fix) v5.0.1.9
Creating Exporter Rule - SQL Query incorrect syntax
In table dbo.Export Rules when a new exporter rule is created the incorrect syntax is written to the "Selection SQL" column
This needs to follow this format:
SELECT J_JNUMBER FROM Winscribe .. JOB WHERE (J_STATUS = 5 AND (J_EXPORTED = 0 OR J_EXPORTED IS NULL) ) AND J_DEPT = **
Add Dept ID where required or whatever identifying field exists in the AND statement