Project

General

Profile

Feature #539

Network graph visualisation

Added by Stefan Eichert over 7 years ago. Updated almost 6 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/

History

#1

Updated by Stefan Eichert over 7 years ago

  • Description updated (diff)
#2

Updated by Stefan Eichert over 7 years ago

  • Description updated (diff)
#3

Updated by Stefan Eichert over 7 years ago

  • Description updated (diff)
#4

Updated by Stefan Eichert over 7 years ago

  • Description updated (diff)
#5

Updated by Stefan Eichert over 7 years ago

  • Description updated (diff)
#6

Updated by Stefan Eichert about 7 years ago

Ready to be implemented.
tbd together: queries to get data from db...
Alexander Watzinger: Worksession in 2016?

#7

Updated by Alexander Watzinger almost 7 years ago

  • Status changed from New to Assigned
#8

Updated by Alexander Watzinger over 6 years ago

  • Target version set to Wishlist
#9

Updated by Alexander Watzinger about 6 years ago

  • Status changed from Assigned to Acknowledged
  • Assignee deleted (Stefan Eichert)

Already implemented in Demo Version with vis.js but is too slow for a generalized implementation in the main version. Maybe look for a faster library?

#10

Updated by Alexander Watzinger about 6 years ago

  • Category set to UI
  • Status changed from Acknowledged to In Progress
  • Assignee set to Alexander Watzinger
  • Target version changed from Wishlist to 2.4.0
  • Estimated time set to 16.00 h

Found 3d.js which is faster and testing at the moment with MEDCON data.

#11

Updated by Alexander Watzinger almost 6 years ago

  • Status changed from In Progress to Closed

Also available in: Atom PDF