Re: [Virtuoso-users] Select from group graph in SQL

2013-04-14 Thread Dimitris Kontokostas
Hi Hugh, Thanks for the tips. I finally took some time to do this but I followed the lazy approach (with the minimum changes) for now :) This is what I did select distinct P as PRED from DB.DBA.RDF_QUAD where S = _S and *G in ( select RGGM_MEMBER_IID FROM DB.DBA.RDF_GRAPH_GROUP_MEMBER where RGGM

Re: [Virtuoso-users] Select from group graph in SQL

2012-12-13 Thread Hugh Williams
Hi Dimitris, The way it can be done is to use theVirtuoso sparql_to_sql_text() function (http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html) to determine the SQL query the query including the graph group is translated to ie sparql_to_sql_text ('select * from { ?s ?p ?o }'), then l

Re: [Virtuoso-users] Select from group graph in SQL

2012-12-11 Thread Dimitris Kontokostas
Hi Hugh, I hardcoded the gragh with the most triples for now (live.nl.dbpedia.org) to have something to show, so it is not fixed yet. Any suggestions? Best, Dimitris On Tue, Dec 11, 2012 at 7:28 PM, Hugh Williams wrote: > Hi Dimitris, > > Have your resolved or worked around this issue as I no

Re: [Virtuoso-users] Select from group graph in SQL

2012-12-11 Thread Hugh Williams
Hi Dimitris, Have your resolved or worked around this issue as I not the link in [2] is returning a HTML description of the resource and not an empty page as indicated ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Webl

[Virtuoso-users] Select from group graph in SQL

2012-12-11 Thread Dimitris Kontokostas
Hi, I am trying to adapt the DBpedia plugin to work with graph groups in http://live.nl.dbpedia.org Right now I have the "http://nl.dbpedia.org"; as a group graph that contains the "http://live.nl.dbpedia.org"; and "http://static.nl.dbpedia.org"; The problem is that the description page is render