I am using SQL Server as my datasource. I have created an app to view customers and so far have a home page and a details page that is accessed by clicking a button (action) on the home page beside the customer record. When the button is selected though it is returning a SQL error with the query that is generated by Softre. Unable to fetch record with id=‘.EA TES’ for application with id=‘2c5b6336-d631-43e9-b7bd-627dd33809cf’ StatementCallback; uncategorized SQLException for SQL [SELECT * FROM (SELECT * FROM Integrations.dbo.[v_Crm_CustomerData]) AS inner_query WHERE inner_query.[Customer]=‘.EA TES’ OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY ]; SQL state [S0001]; error code [102]; Incorrect syntax near ‘OFFSET’.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ‘OFFSET’.
When I run this query in my SQL database it fails as well but when I remove the stuff after and including OFFSET it works. How can I get this working in Softre?