Error: Query too Complex. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'username' to data type int. Native error:245

Error: Query too Complex. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'username' to data type int. Native error:245

Occurs when running a student query and using Attendance Last changed By.... as a criteria.
This is currently being addressed by our programmers and we will update this article when we have more information. If you encounter this error please Contact Support and reference this article.

Steps to Duplicate

1. Create a New Stduent Query
2. Expand Attendance > Class Attendance > Academic Year
3. Pick a year that has attendance
4. Expand Class Attendance > Class Attendance Properties > Last Changed By...
5. Operator is Does Not Equal
6. Pick any user.
7. Run the query

Was this article helpful?