How can i add group by statement on list page (data directly coming from database table not from database view) i am adding custom field for count,sum etc its working fine but i also need group by.
I am getting my desired result by creating database view and its working fine on my localhost but on live web server, its not linking to custom database view as i created on live web server
As per my understanding,try to create database view/Custom View for each company and use group by company name. and then create list/view/edit pages Apologies in advance if i am wrong because i am also a learner Best regards,
1st: I have created a custom database view for counted and group by output, its working fine but when i add search box its not searching any thing.
2nd: on a regular database table based list page, searching is working fine but search by date field(its on a page filter component) its not searching date in this format 23-09-2018 but wen i add date like this in database 2018-09-23 its working fine .
please let me know how to change date searching property in this date searching functionality from YYYY-MM-DD to DD-MM-YYYY.
