I have created a simple MSSQL Custom view as follows -
SELECT txddate, idno, request FROM TRANSACTION
Which is working fine with the ListPage and the Search also.
SELECT txddate, idno AS accountid, request FROM TRANSACTION
Working fine with the ListPage but when I perform External search on “accountid”
it got an error as - [SQL Server]Invalid column name ‘accountid’.
As my txddate has a date value in “d/m/y” I use the following code to convert the date
3)SELECT CONVERT(datetime,txddate,3) AS reqdate, idno, request FROM TRANSACTION
Working fine with the ListPage and the external search to “idno” also working
But when I perform external search on “reqdate”
it got an error as - [SQL Server]Invalid column name ‘reqdate’
The above Custom View was working fine with the previous version PHPMaker 2019
But it is not working in the new version 2020.
from the debug mode I have got the following error in sql
Bishu wrote:
SELECT txddate, idno AS accountid, request FROM TRANSACTION
Working fine with the ListPage but when I perform External search on “accountid”
it got an error as - [SQL Server]Invalid column name ‘accountid’.
At the end of the sql - WHERE [accountid] = 1056
AS there is no [accountid] in the table it is showing as Invalid Column
3)SELECT CONVERT(datetime,txddate,3) AS reqdate, idno, request FROM TRANSACTION
Working fine with the ListPage and the external search to “idno” also working
But when I perform external search on “reqdate”
it got an error as - [SQL Server]Invalid column name ‘reqdate’
At the end of the sql - WHERE [reqdate] = “24/05/2020”
AS there is no [reqdate] in the table it is showing as Invalid Column