Project

General

Profile

Actions

Feature #539

closed

Network graph visualisation

Added by Stefan Eichert over 8 years ago. Updated about 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 #1

Updated by Stefan Eichert over 8 years ago

  • Description updated (diff)
Actions #2

Updated by Stefan Eichert over 8 years ago

  • Description updated (diff)
Actions #3

Updated by Stefan Eichert over 8 years ago

  • Description updated (diff)
Actions #4

Updated by Stefan Eichert over 8 years ago

  • Description updated (diff)
Actions #5

Updated by Stefan Eichert over 8 years ago

  • Description updated (diff)
Actions #6

Updated by Stefan Eichert over 8 years ago

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

Actions #7

Updated by Alexander Watzinger about 8 years ago

  • Status changed from New to Assigned
Actions #8

Updated by Alexander Watzinger over 7 years ago

  • Target version set to Wishlist
Actions #9

Updated by Alexander Watzinger over 7 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?

Actions #10

Updated by Alexander Watzinger about 7 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.

Actions #11

Updated by Alexander Watzinger about 7 years ago

  • Status changed from In Progress to Closed
Actions

Also available in: Atom PDF