Communal Computer

Kind publication

Every entity whose kind fact carries the value publication — one row per entity, pivoted from the facts table at HEAD.

0entities
5attrs
Read path

This page calls Snapshot.entitiesOfKind(publication), which builds:

WITH kinds AS (
  SELECT entity, MIN(asserted_at) AS created_at, ... AS created_by
  FROM facts
  WHERE attribute = 'kind' AND value = 'publication'
  GROUP BY entity
)
SELECT k.entity, k.created_at, k.created_by,
       MAX(CASE WHEN cf.attribute='<attr>' THEN cf.value END) AS "<attr>",
       ...
FROM kinds k
LEFT JOIN current_facts cf ON cf.entity = k.entity
GROUP BY k.entity
HAVING "tombstoned" IS NULL
ORDER BY k.entity DESC

Entities 0 shown

No entities of this kind yet.