asked on January 18, 2022
Hi team,
We are using The Flexmonster data server 2.9.16 and ng-flexmonster 2.9.16.
Azure data base is used fetch the data from database for FM data server .
Below type of index query is not supported
select * from table1 as T1, (select * from table2) as T2 where T1.Id=T2.Id
Kindly check and update this is working in some of the versions sometime.
⋅ January 19, 2022
Hello, Nil!
Thank you for raising a ticket.
It looks like Flexmonster Data Server is struggling with this query because of two same names of columns (T1.Id=T2.Id). We are going to fix this, ETA Feb 7th. Meanwhile, we suggest renaming the Id column in one of the tables as a temporary workaround. Also, you can try creating an alias for one of the Id columns (select *, Id as Id_2 from table2).
Please let us know if the suggested above works fine for you.
Best Regards,
Maksym
⋅ January 20, 2022
Thanks for support, please let us know when your team fix it.
We have used the with clause as of now
⋅ February 8, 2022
Hello, Nil!
We are happy to let you know that the issue with loading data from the database when columns have identical names was fixed.
This is provided in the 2.9.18 version of Flexmonster Data Server: https://www.flexmonster.com/release-notes/.
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Please let us know if everything works fine for you.
Best Regards,
Maksym
⋅ February 16, 2022
Hi, Nil!
We were wondering if the fix has helped you to solve the issue
Best Regards,
Maksym
⋅ February 23, 2022
Hi, Nil!
Just checking in to ask if you've had a chance to try out if our fix worked for you.
Regards,
Maksym
