App Crashing with Lag and Lead

[rsnell]

If I have an application where the underlying SQL uses LAG or LEAD and I enable search, the application crashes :

image.png?

[robert.swanson]

Those functions cannot be used in a WHERE clause, hence the SQL error being thrown when you attempt to use it in that manner. We will adjust this in the next build to prevent attempting to search on such columns.

If you really need to filter on a LAG or LEAD column, you could put your SQL statement into a CTE (WITH clause) and then do your SELECT from that.