emacs-orgmode
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]