Demo:Timeline

Note: The data is stored in a number of entries annotated using SemanticMediaWiki (datetime) data structure.

Debug output SQLStore

ASK Query

[[Context::+]]

SQL Query

SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  `smw_object_ids` AS t0
INNER JOIN
  `smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.p_id=1391)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort DESC
LIMIT
  155
OFFSET
  0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ref	s_id, p_id, s_id_2, s_id_3	p_id	4	const	10		Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	my_wiki.t1.s_id	1		Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:1

Errors and Warnings

None

	Start datetime	Start at beginning
PKC Workflow/Stage 1	16 July 2021 08:00:00
Meeting with Prof. Surya	30 January 2022 06:47:08
Event:Project/HDX/2021,07,15	15 July 2021 12:30:00
Event:Project/EnterpriseForTheFuture/Stage 2	1 January 2022 00:00:01
Event:Project/EnterpriseForTheFuture/Stage 1	1 September 2021 00:00:01
Event:Project/Clean up dev.xlp.pub	16 July 2021 09:00:13
Event:Meeting/2021,07,15	15 July 2021 08:00:00
Event:Conference/2021,07,15	15 July 2021 07:50:08
Another contextualized event	29 November 2021 10:05:39
A new form	6 December 2021 10:04:56