[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
columnview, match and status include all open status
From: |
Uwe Brauer |
Subject: |
columnview, match and status include all open status |
Date: |
Fri, 08 Jan 2021 09:12:11 +0100 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- columnview, match and status include all open status,
Uwe Brauer <=