Syntax Error (Unknown column 'sys_user0.email' in 'where clause') appearing when trying to search in a reference field on a record producer.
Jakarta Patch 6a+
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.
The attributes on the variable must reference valid columns on the referenced table.
Failure to do so will yield the aforementioned syntax errors.