Setzlinge
::
Views
Default
Arbre
Pannellum
VK-slides
KuM-slides
Knoids
Presentation
Textrec
Recview
Repetitio
Bildung
Reveal
Impress
HTML ?
Axones
-
This will be filled with resources and bookmarks related to trees
-
-
-
with recursive tree as (
select obj,
sub,
array[obj] as all_ancestors,
array[knot_name] as ancestor_names
from bounds left join knots on obj=knot_id
where sub=1 and predicate='is_parent'
union all
select c.obj,
c.sub,
p.all_ancestors||c.obj,
p.ancestor_names || knot_name
from bounds c
join tree p
on c.sub = p.obj
and c.obj <> ALL (p.all_ancestors) -- avoids endless loops
left join knots on c.obj=knot_id
)
select all_ancestors,ancestor_names
from tree order by all_ancestors;
-
Zeitgeist Log
2020-04-16 14:36:47.269931 daniel-hromada@medienhaus.udk-berlin.de executed add_bound with variables "obj"=>"7661", "ord"=>"1", "sub"=>"7568", "bound_id"=>"19700", "predicate"=>"is_parent"
2020-04-16 14:36:47.272633 daniel-hromada@medienhaus.udk-berlin.de executed add_bound with variables "obj"=>"7661", "ord"=>"1", "sub"=>"2697", "bound_id"=>"19701", "predicate"=>"created_by"
2020-04-16 14:38:14.772707 paul-seidler@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-04-16 14:38:45.820835 paul-seidler@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-04-16 14:38:56.448809 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-04-20 09:09:56.791993 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-04-21 10:32:23.336672 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-04-21 10:33:32.343422 paul-seidler@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-05-12 13:12:43.625137 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-05-12 13:21:19.044305 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-05-12 13:35:01.302915 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-05-12 13:35:50.926032 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-05-12 13:36:07.019577 daniel-hromada@medienhaus.udk-berlin.de executed add_bound with variables "obj"=>"7811", "ord"=>"1", "sub"=>"7661", "bound_id"=>"19994", "predicate"=>"is_parent"
2020-05-12 13:46:19.596488 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-05-12 20:03:37.957293 paul-seidler@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-08 11:29:28.289768 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-08 11:29:43.423735 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-08 11:29:54.078711 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-08 11:30:59.944101 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-23 13:38:21.698275 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-23 13:38:55.210125 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-23 13:39:00.90926 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-23 13:39:37.994915 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-23 14:58:11.368398 daniel-hromada@medienhaus.udk-berlin.de executed add_bound with variables "obj"=>"8145", "ord"=>"1", "sub"=>"7661", "bound_id"=>"20650", "predicate"=>"is_parent"
2020-06-23 15:00:42.145302 daniel-hromada@medienhaus.udk-berlin.de executed /view/7661/ with variables
2020-06-29 10:20:08.62109 paul-seidler@medienhaus.udk-berlin.de executed /view/7661/ with variables