Query language issue - illegal token error

🧩 Low-Code Development Workflows
#1

Can anyone tell me why this query works for an iterator event:

"memberID = " + record.recordID

but this one does not:

"memberID = " + record.recordID + " AND awardDateOfAward > " + record.values.memberCurrentAppointmentDate

I get a “found an illegal token” error when I add the date comparison.

1 Like
#2

I’d imagine you’d have to do "memberID = " + record.recordID + " AND awardDateOfAward > '" + record.values.memberCurrentAppointmentDate + "'" (notice single quotes); might do the trick.
You might also have to wrap the timestamp with DATE()

1 Like
#3

That worked. Thanks.

1 Like
#4