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

Syntax Error (Unknown column 'sys_user0.email' in 'where clause') appearing when trying to search in a reference field on a record producer Issue  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 references a field of , 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.