31 views

Symptoms


Syntax Error (Unknown column 'sys_user0.email' in 'where clause') appearing when trying to search in a reference field on a record producer.

Release


Jakarta Patch 6a+

Cause


Syntax-related search errors can be caused by improper table references.

If a variable of <type_x> references a field of <type_y>, there is a large chance that the search will result in an error.

Resolution


The attributes on the variable must reference valid columns on the referenced table.

Failure to do so will yield the aforementioned syntax errors.

 

Article Information

Last Updated:2018-06-14 08:26:20
Published:2018-06-14