F
Filament2mo ago
arif

Pagination Error 'Incorrect syntax near OFFSET' using SQL Server

I am developing a project using Filament 3 and Laravel 11 with SQL Server as the database. I'm using the default table provided by Filament, and since the dataset is large, I tried implementing the default pagination. However, when I tested it, I encountered an error: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Incorrect syntax near 'OFFSET'. (Please refer to the attached screenshot for details.) Interestingly, if I don’t apply pagination and select 'All' to display all data, it works fine. However, this is not efficient for large datasets. Could you please help me understand why this error is happening and how to fix it?
No description
No description
No description
2 Replies
arif
arif2mo ago
up up
LeandroFerreira
LeandroFerreira2mo ago
Did you try to execute the same query in your sql server?
Want results from more Discord servers?
Add your server