database approach: extract from headers with properties different tables.

database approach: extract from headers with properties different tables.

[Uwe Brauer]

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]    |