how to group by select tags?

[midas0441]

I'd like some help writing a dataview query.

I use many tags (aaa, bbb,... zzz) on my tasks. Some tags are particularly special (qqq and www).

I want to group tasks by tags qqq and www. Tasks that have neither special tag will be listed among the ungrouped.

Example:

- [ ] first task #aaa #qqq
- [ ] second task #bbb #ccc
- [ ] third task #bbb #www
- [ ] fourth task #ccc #qqq
- [ ] fifth task #www #qqq #aaa

The above would be grouped as:

(ungrouped):
- [ ] second task #bbb #ccc

qqq:
- [ ] first task #aaa #qqq
- [ ] fourth task #ccc #qqq
- [ ] fifth task #www #qqq #aaa

www:
- [ ] third task #bbb #www
- [ ] fifth task #www #qqq #aaa

[midas0441]

I think I've figured out an answer to my own question, but now I wonder if the experts here can point me to a more elegant method. Here is what I cooked up for a TASK query:

GROUP BY choice(contains(tags, "www") OR contains(file.tags, "www"), "www", choice(contains(tags, "qqq") OR contains(file.tags, "qqq"), "qqq","other"))

The idea is to group tasks with inline tags (or file-level tags) that match www, and then do it again for qqq, and finally for tasks that don't meet either condition, place them in the other group.

The clunky part is the nested choice functions. Imagine that I have 5 or 6 such "special" tags that I want to group by. The GROUP statement becomes quite ugly.

Is there a more elegant solution?

[AB1908]

There is. Check out s-blu's example vault for an example that uses IIFEs. Look specifically for custom sorting examples.