TJDB: Adding both FILTER and SORT conditions in the query throws error

[mansukh-tj]

Version Information

Version 2.38.0-ee2.15.28-cloud2.3.11

Environment

ToolJet Cloud

What is the expected behaviour?

The query should run smoothly with both conditions

What is the current behaviour?

If either of SORT or FILTER conditions are used, query works fine.
As soon as both of them are added it throws in error.

Screenshots or Screencast

Case 1

Case 2

[Sadaf-A]

Hey @mansukh-tj !
I would like to work on this issue

[mansukh-tj]

@Sadaf-A Assigned!

[akshaysasidrn]

@Sadaf-A Kindly let us know if you have already started working on it. This is in priority and we are planning to have it fixed sooner. If you haven't started with it, we'll pick this up internally.

[Sadaf-A]

@Sadaf-A Kindly let us know if you have already started working on it. This is in priority and we are planning to have it fixed sooner. If you haven't started with it, we'll pick this up internally.

Hey, I have started working on this and made some progress I will notify you if I'm not able to solve it on time
Thank You

[mansukh-tj]

@Sadaf-A Please let us know by today EOD. If not completed by today, we will be internally assigning it.

[Sadaf-A]

@Sadaf-A Please let us know by today EOD. If not completed by today, we will be internally assigning it.

Hey, I haven't been able to solve it yet

[akshaysasidrn]

@Sadaf-A Hope you understand the urgency. This is breaking and we need to resolve it promptly. Therefore taking this up internally.

[Sadaf-A]

@Sadaf-A Hope you understand the urgency. This is breaking and we need to resolve it promptly. Therefore taking this up internally.

Yes, I understand it took me a lot of time because I wasn't able to set up tooljet db locally initially