Error: Query too complex - when running a query on attendance code count

Error: Query too complex. General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near ','. Native error: 102 [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near ','. Native error: 102

Occurs when running a student query and using Attendance code count as a field in 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 Student Query
2. Expand Attendance > Day Attendance > Day attendance code count
3. Fill out the number of codes to include and the information on the filters tab.
4. Run the query
5. Save and close the query
6. Open the saved query and select Run
7. Receive the error message.
 

Was this article helpful?