Re: [Virtuoso-users] specific graph stored datas problem with virtuoso 7

2014-06-13 Thread Ivan Mikhailov
Hello Christophe, I've re-tested everything on smaller graphs and it looks quite ok. The probable reason of your trouble is a confusion between graphs and graph groups. When a query contains FROM it deals with data from that graph group, ignoring a graph if it shares an iri with a graph group. Mo

[Virtuoso-users] Create view as sparql with incremental identity

2014-06-13 Thread Ricardo Mendes
Hi, How can I create a view as sparql with incremental identity? I tried the following, but it always return 0. CREATE VIEW I4M.Dimensions.Dim_Equipment AS SPARQL { SELECT bif:row_count() AS ?incrementalID ?some_value FROM Regards --

[Virtuoso-users] SQL query inside SPARQL query

2014-06-13 Thread Ricardo Mendes
Hi, Can I have SQL query inside a SPARQL query? Exist any function to provide that? bif:(SELECT ContractID FROM I4M.Dimensions.Dim_Contract WHERE ContractorFiscalID = '000') AS ?ContractID CREATE VIEW I4M.Dimensions.Dim_Equipment AS SPARQL { SELECT bif:row_count() AS ?EquipmentID ?E