Project

General

Profile

Actions

Feature #539

closed

Network graph visualisation

Added by Stefan Eichert almost 9 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Category:
UI
Target version:
Start date:
2015-10-13
Estimated time:
16.00 h

Description

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

draft example:
http://homepage.univie.ac.at/stefan.eichert/networkgraph/

Actions

Also available in: Atom PDF