Skip to content
English
  • There are no suggestions because the search field is empty.

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