problem with columnview and the match option

[Uwe Brauer]

Hi

Please look at this example

#+begin_src lisp
* Sheets                                                           :noexport:
  :PROPERTIES:
  :COLUMNS:  %10SSheet(Sheet Nr) %10Ex(Exercise Nr)  %17Date(Date) 
%7STATUS(Status){X/}
  :ID2:       Sheet1
  :END:

** DONE G1                                                               :H1:G1:
    :PROPERTIES:
    :ID:       G1
    :User1:    John
    :email1: john@gmail.com
    :Start:    <2021-02-16 mar>
    :End:      <2021-05-24 lun>
    :STATUS:   [ ]
    :ST1:      [ ]
    :Sheet:    H1
    :Ex:       E1
    :END:

** DONE G2                                                            :H1:G2:
    :PROPERTIES:
    :ID:       G2
    :Usuario1: Jane
    :email1:   jane@gmail.com
    :Start:    <2020-07-26 Sun>
    :End:      <2020-11-22 dom>
    :STATUS:   [X]
    :ST1:      [X]
    :Sheet:    H1
    :Ex:       E3
    :END:

** TODO  G3                                                           :G3:H2:
    :PROPERTIES:
    :Id:       G3
    :Usuario1: Fritz
    :Start:    <2020-07-26 Sun>
    :End:      <2020-11-22 dom>
    :ST2:      [X]
    :STATUS:   [X]
    :Sheet:     H2
    :Ex:       E2
    :END:


    - State "TODO"       from "WAIT"       [2021-10-17 dom 08:30]
    - State "WAIT"       from "DONE"       [2021-10-16 sáb 21:55]


** All groups
#+BEGIN: columnview :hlines 2 :match "H1"   :maxlevel 2 :skip-empty-rows t 
:indent nil :format  "%5TODO(Status) %5Id(Group) %5Ex(Exercise) %5Sheet(Sheet) 
%7ST1(Status){X/}"
| Status | Group | Exercise | Sheet | Status |
|--------+-------+----------+-------+--------|
|        |       |          |       | [1/2]  |
|--------+-------+----------+-------+--------|
| DONE   | G1    | E1       | H1    | [ ]    |
|--------+-------+----------+-------+--------|
| DONE   | G2    | E3       | H1    | [X]    |
|--------+-------+----------+-------+--------|
| TODO   | G3    | E2       | H2    |        |
#+END
I don't understand why the line 
| TODO   | G3    | E2       | H2    |        | 
appears in the table, it does not fit condition

I deleted the maxlevel condition


#+BEGIN: columnview :hlines 2 :match "H1"    :skip-empty-rows t :indent nil 
:format  "%5TODO(Status) %5Id(Group) %5Ex(Exercise) %5Sheet(Sheet) 
%7ST1(Status){X/}"
| Status | Group | Exercise | Sheet | Status |
|--------+-------+----------+-------+--------|
| DONE   | G1    | E1       | H1    | [ ]    |
|--------+-------+----------+-------+--------|
| DONE   | G2    | E3       | H1    | [X]    |
#+END

But now the row

|        |       |          |       | [1/2]  |

Is missing. I am confused, I thought maybe exclude-tags could help

#+BEGIN: columnview :hlines 2 :exclude-tags  (H2)    :skip-empty-rows t :indent 
nil :format  "%5TODO(Status) %5Id(Group) %5Ex(Exercise) %5Sheet(Sheet) 
%7ST1(Status){X/}"
| Status | Group | Exercise | Sheet | Status |
|--------+-------+----------+-------+--------|
|        |       |          |       | [1/2]  |
|--------+-------+----------+-------+--------|
| DONE   | G1    | E1       | H1    | [ ]    |
|--------+-------+----------+-------+--------|
| DONE   | G2    | E3       | H1    | [X]    |
|--------+-------+----------+-------+--------|
| TODO   | G3    | E2       | H2    |        |
#+END

But not really, help would be appreciated.


#+end_src