[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
database approach: extract from headers with properties different tables
From: |
Uwe Brauer |
Subject: |
database approach: extract from headers with properties different tables. |
Date: |
Fri, 16 Oct 2020 19:29:36 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) |
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] |
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- database approach: extract from headers with properties different tables.,
Uwe Brauer <=