12-03-2021 07:54 AM
Hoping someone can help me with the SQL to correct the error: Incorrect syntax near the keyword 'NULL'
I created the input parameters for the DateRange and DocumentType list and validated that SQL for the DocumentType list. But when I click "Next" I receive the error message. Any guidance would be appreciated.
SELECT
i.itemdate AS 'Scan Date',
k1.keyvaluesmall AS 'Employe EE #',
k2.keyvaluechar AS 'Employee First Name',
k4.keyvaluechar AS 'Employee Last Name',
k5.keyvaluechar AS 'Upload By',
k6.keyvaluechar AS 'Kofax Scan ID',
k7.keyvaluechar AS 'Kofax Validation ID'
FROM hsi.itemdata i
LEFT OUTER JOIN hsi.doctype d on d.itemtypenum = i.itemtypenum
LEFT OUTER JOIN hsi.itemtypegroup it on it.itemtypegroupnum = i.itemtypegroupnum
LEFT OUTER JOIN hsi.keyitem243 k1 on i.itemnum = k1.itemnum
LEFT OUTER JOIN hsi.keyitem245 k2 on i.itemnum = k2.itemnum
LEFT OUTER JOIN hsi.keyitem246 k4 on i.itemnum = k4.itemnum
LEFT OUTER JOIN hsi.keyitem501 k5 on i.itemnum = k5.itemnum
LEFT OUTER JOIN hsi.keyitem233 k6 on i.itemnum = k6.itemnum
LEFT OUTER JOIN hsi.keyitem234 k7 on i.itemnum = k7.itemnum
WHERE (d.itemtypenum @{DocumentType}) AND
(i.status <> '16') AND
(i.itemtypegroupnum = '109') AND
(i.itemdate BETWEEN @{DateRange})
ORDER BY i.itemdate DESC
Linda
12-03-2021 08:51 AM
Are you missing an "=" or other operator in "WHERE (d.itemtypenum @{DocumentType}) AND"?
12-03-2021 08:51 AM
Are you missing an "=" or other operator in "WHERE (d.itemtypenum @{DocumentType}) AND"?
12-03-2021 10:58 AM
Thank you!
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.