Feature #539
Updated by Stefan Eichert about 9 years ago
A nice feature would be to visualise an entities relation to other entities in the browser for example with http://visjs.org/
Easy to use js library. Easy to implement.
To do:
(recursive) Query for central node and related nodes with some iterations - in ajax/php and push to js
create network graph with vis.js
style, format etc...
Examples:
http://visjs.org/network_examples.html
Query draft nodes:
SELECT uid AS id, entity_name_uri as label, classes_uid as group FROM openatlas.tbl_entities WHERE uid in
(
with recursive links (uid_from, uid_to) AS (
Select links_entity_uid_from, links_entity_uid_to
FROM openatlas.tbl_links
WHERE links_entity_uid_from = 5684
UNION
Select uid_to, links_entity_uid_to
FROM openatlas.tbl_links, links
WHERE links_entity_uid_from = uid_to
)
SELECT distinct uid_from FROM links ORDER BY uid_from)
Query draft links:
with recursive links (uid_from, uid_to) AS (
Select links_entity_uid_from, links_entity_uid_to
FROM openatlas.tbl_links
WHERE links_entity_uid_from = 5684
UNION
Select uid_to, links_entity_uid_to
FROM openatlas.tbl_links, links
WHERE links_entity_uid_from = uid_to
)
SELECT distinct uid_from as from, uid_to AS to FROM links ORDER BY uid_from