2. PHPRunner General questions
  3. Order By NOT WORKING with 'Create Custom View'
This topic is locked

Order By NOT WORKING with 'Create Custom View'

 		11/29/2022 10:32:14
PHPRunner General questions
P
 ppradhan@live.com author

I realize ORDERY BY is not working with the query that is created as 'Create Custom View'. Has anyone experienced this issue?

Later, in the 'List Page : Before SQL Query' event, I even tried adding this '$strOrderBy = "ORDER BY date DESC"; still does not work.

Please advice.
Sergey Kornilov admin 11/29/2022

It should work either way. There is something that is getting in the way.

P
 		ppradhan@live.com author 11/29/2022

@admin,
thank you for your quick response.
I tried creating 3 different 'Create Custom View'. Same issue with all of them.
I'm using the latest PhpRunner 10.8 build: 39925.

Also for such Custom View, there seems filter not working correctly for Between condtion in date.
eg: if I choose to filter date using BETWEEN condition, the result does not include the starting date. When I select Dates between 11/01/2022 and 11/29/2022, the result is shown starting from 11/02/2022 till 11/29/2022. Is this something with the software I'm not sure, but facing such issue.