columnview, match and status include all open status

columnview, match and status include all open status

[Uwe Brauer]

Hi 

I have the following problem:

#+begin_src 
,* Sheet1                                                                 
  :PROPERTIES:
  :COLUMNS:  %10Sheet(Sheet Nr) %10Ej(Exercise Nr)  %17Date(Date) %7STATUS(Status){X/}
  :END:

,** Group1                                                             :in:G1:
   :PROPERTIES:
   :ID:       G1
   :Grp1:     1
   :Gr:       Group-1
   :STATUS:   [X]
   :Sheet:    H1
   :Ej:       E1
   :END:

,** Group1                                                             :in:G1:
   :PROPERTIES:
   :ID:       G1
   :Grp1:     1
   :Gr:       Group-1
   :STATUS:   [X]
   :Sheet:    H1
   :Ej:       E4
   :END:


,** Group2                                                               :out:
   :PROPERTIES:
   :ID:       G2
   :Grp1:     2
   :Gr:       Group-2
   :STATUS:   [X]
   :Sheet:     H1
   :Ej:       E2
   :END:

,** Group3                                                               :out:
   :PROPERTIES:
   :ID:       G3
   :Grp1:     3
   :Gr:       Group-3
   :STATUS:   [X]
   :Sheet:     H1
   :Ej:       E3
   :END:


,** List of all group members


,#+TBLNAME: Sheet1
,#+BEGIN: columnview   :hlines 2 :skip-empty-rows t :indent nil  :format "%5Sheet(Sheet) %5Grp1(Group)  %5Ej(Exercise) %7STATUS(Status){X/}"
| Sheet | Group | Exercise | Status |
|-------+-------+----------+--------|
|       |       |          | [4/4]  |
|-------+-------+----------+--------|
| H1    |     1 | E1       | [X]    |
|-------+-------+----------+--------|
| H1    |     1 | E4       | [X]    |
|-------+-------+----------+--------|
| H1    |     2 | E2       | [X]    |
|-------+-------+----------+--------|
| H1    |     3 | E3       | [X]    |
,#+END

Now I only want a table with the tag G1

,#+TBLNAME: Group1
,#+BEGIN: columnview   :hlines 2 :skip-empty-rows t :indent nil  :match "G1" :format "%5Sheet(Sheet) %5Grp1(Group)  %5Ej(Exercise) %7STATUS(Status){X/}"
| Sheet | Group | Exercise | Status |
|-------+-------+----------+--------|
| H1    |     1 | E1       | [X]    |
|-------+-------+----------+--------|
| H1    |     1 | E4       | [X]    |
,#+END


But I would like to have 

,#+TBLNAME: Sheet1
,#+BEGIN: columnview   :hlines 2 :skip-empty-rows t :indent nil  :format "%5Sheet(Sheet) %5Grp1(Group)  %5Ej(Exercise) %7STATUS(Status){X/}"
| Sheet | Group | Exercise | Status |
|-------+-------+----------+--------|
|       |       |          | [2/2]  |
|-------+-------+----------+--------|
| H1    |     1 | E1       | [X]    |
|-------+-------+----------+--------|
| H1    |     1 | E4       | [X]    |
,#+END


That seems impossible?

regards

Uwe Brauer 
#+end_src