|Re: Reporting on current orders only
Akshat Kapoor <firstname.lastname@example.org>
|Mon, 12 Feb 2024 19:33:39 +0530
Good Evening Craig,
> Thanks for the help I have been able to get it to filter using the Where clause. I have also used the Order By clause to order the the report alphabetically.
> For the orders though we don't just want to sort them alphabetically but we want to group the orders that have a due date and those that don't. Then have these each sorted alphabetically. This is so that they are grouped together. I have tries to use the Group sql clause but I can't get that to work.
select * from tableA order by due_date,name
You can add where clause to the above statement.
This will sort according to due date and then by name if the due date is
Further grouping will have to be done in the report.