Org-mode mailing list
 help / color / mirror / Atom feed
* database approach: extract from headers with properties different tables.
@ 2020-10-16 17:29 Uwe Brauer
  0 siblings, 0 replies; only message in thread
From: Uwe Brauer @ 2020-10-16 17:29 UTC (permalink / raw)
  To: emacs-orgmode


Hi 

I have the following example

* Group1
   :PROPERTIES:
   :COLUMNS:  %10Is(Sheet Nr) %10Ej(Exercise Nr) %7TODO(Status) %26TAGS(Which) %17Date(Date) %7STATUS(Status){X/} 
   :ID:       Issues
   :END:

** WAIT                                                            :Annu2021:
   :PROPERTIES:
   :ID:       Issue:1
   :Date:     <2020-07-26 Sun>
   :STATUS:   [X]
   :IS:       H1
   :EJ:       E1
   :END:

** WAIT                                                            :Annu2021:
   :PROPERTIES:
   :ID:       Issue:2
   :Date:     <2020-07-26 Sun>
   :STATUS:   [X]
   :IS:       H2
   :EJ:       E1
   :END:


That resuls in 

#+TBLNAME: grupo1
#+BEGIN: columnview :hlines 1 :indent nil :match "/-DONE"  :format "%50ITEM(Group) %5Is(Sheet) %5Ej(Exercise) %12TODO %8TAGS(Course) %12Date %7Status(Status){X/}"
| Group  | Sheet | Exercise | TODO | Course     | Date         | Status |
|--------+-------+----------+------+------------+--------------+--------|
| Group1 |       |          |      |            |              | [2/2]  |
|        | H1    | E1       | WAIT | :Annu2021: | <2020-07-26 Sun> | [X]    |
|        | H2    | E1       | WAIT | :Annu2021: | <2020-07-26 Sun> | [X]    |
#+END

* Group2
   :PROPERTIES:
   :COLUMNS:  %10Is(Sheet Nr) %10Ej(Exercise Nr) %7TODO(Status) %26TAGS(Which) %17Date(Date) %7STATUS(Status){X/} 
   :ID:       Issues
   :END:

** WAIT                                                            :Annu2021:
   :PROPERTIES:
   :ID:       Issue:1
   :Date:     <2020-07-26 Sun>
   :STATUS:   [X]
   :IS:       H1
   :EJ:       E2
   :END:

** WAIT                                                            :Annu2021:
   :PROPERTIES:
   :ID:       18c81241-5ccc-4e88-8f9e-ebe24ffbdf36
   :Date:     <2020-08-05 Wed>
   :Status:   [X]
   :IS:       H2
   :EJ:       E2
   :END:

Results in 



#+BEGIN: columnview :hlines 1 :indent nil :match "/-DONE"  :format "%50ITEM(Group) %5Is(Sheet) %5Ej(Exercise) %12TODO %8TAGS(Course) %12Date %7Status(Status){X/}"
#+TBLNAME: grupo2
| Group  | Sheet | Exercise | TODO | Course     | Date         | Status |
|--------+-------+----------+------+------------+--------------+--------|
| Group2 |       |          |      |            |              | [2/2]  |
|        | H1    | E2       | WAIT | :Annu2021: | <2020-07-26 Sun> | [X]    |
|        | H2    | E2       | WAIT | :Annu2021: | <2020-08-05 Wed> | [X]    |
#+END



Question: can I somehow extract a table only for sheet1 which contains
both groups?

Like 


| Sheet | Group  | Exercise | TODO | Course     | Date             | Status |
|-------+--------+----------+------+------------+------------------+--------|
| H1    |        |          |      |            |                  |        |
|       | Group1 | E1       | WAIT | :Annu2021: | <2020-07-26 Sun> | [X]    |
|       | Group2 | E2       | WAIT | :Annu2021: | <2020-08-05 Wed> | [X]    |




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

only message in thread, other threads:[~2020-10-16 17:31 UTC | newest]

Thread overview: (only message) (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2020-10-16 17:29 database approach: extract from headers with properties different tables 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