Org-mode mailing list
 help / color / mirror / Atom feed
* columnview, match and status include all open status
@ 2021-01-08  8:12 Uwe Brauer
  0 siblings, 0 replies; only message in thread
From: Uwe Brauer @ 2021-01-08  8:12 UTC (permalink / raw)
  To: emacs-orgmode


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



^ permalink raw reply	[flat|nested] only message in thread

only message in thread, other threads:[~2021-01-08  8:12 UTC | newest]

Thread overview: (only message) (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2021-01-08  8:12 columnview, match and status include all open status Uwe Brauer

Org-mode mailing list

This inbox may be cloned and mirrored by anyone:

	git clone --mirror https://orgmode.org/list/0 list/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 list list/ https://orgmode.org/list \
		emacs-orgmode@gnu.org
	public-inbox-index list

Example config snippet for mirrors.
Newsgroups are available over NNTP:
	nntp://news.yhetil.org/yhetil.emacs.orgmode
	nntp://news.gmane.io/gmane.emacs.orgmode


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git