OpenAtlas

Feature #539

Updated by Stefan Eichert over 8 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 


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

Back