emacs-orgmode@gnu.org archives
 help / color / mirror / code / 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

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).