Seeing error message on incident search - Syntax Error or Access Rule Violation detected by database (Unknown column 'incident3.number' in 'field list')

[etchua627]

The following error message is being displayed when we select the Incident "Active records" or "All Records".  

Syntax Error or Access Rule Violation detected by database (Unknown column 'incident3.number' in 'field list')

[Andrew Saxton -]

I've seen this caused by an invalid field on the list view. Check either your personalized list layout, or customize the list layout and see if you see incident3.number in there, if you do, remove it from the selected column.

[etchua627 · Accepted solution]

Hi Andrew,

Thanks for the quick response.

Yes, this fixed the issue.  I found the Default view had the wrong columns and removed them.

This fixed the issue.

Thanks,

ED

[Andrew Saxton -]

Hey ED,

If my answer helped, please consider marking it as correct so that others searching for the same issue can more easily find the solution.

Thanks!

- Andrew S.