Grouping By dueDate

[702573N]

I am trying to build a timeline that lists all uncompleted tasks and groups them by dueDate. The grouping heading should be output with the dueDate in the format "YYYY-MM-DD".

WHERE status->indicator <> 'x'
GROUP BY dueDate

I have already tried the following:

WHERE status->indicator <> 'x'
GROUP BY moment(dueDate)->[format]('YYYY-MM-DD')

[sytone]

The grouping is not a good as I want it to be yet. The formatting of the header is not a configuration item as I want to think about the date format all up as not everyone wants to have YYYY-MM-DD and it should be abstracted from the task as a display property.

The query you have should be like below. use != not <>

```task-sql
WHERE status->indicator != 'x'
GROUP BY dueDate
```

[sytone]

@702573N did that resolve your issue?

[702573N]

<> or != Booth works perfectly well.

My main issue is to change the date format of grouping headers. This problem isn't solved. Further more I would like to combine two grouping rules, which also didn't work.

GROUP BY dueDate AND precedingHeader

[sytone]

OK. That makes sense. The rendering uses the existing tasks model which is hard coded. Internally there is an array of groups and the associated tasks. I am looking at having a separate rending pipe for this data which allows the user to specify the formatting of the group in a more flexible way.

[sytone]

Also for a group by it is column, column and not column AND column