Hi,
Can I have SQL query inside a SPARQL query?
Exist any function to provide that?
bif:<function>(SELECT ContractID FROM I4M.Dimensions.Dim_Contract WHERE
ContractorFiscalID = '00000000000') AS ?ContractID
CREATE VIEW I4M.Dimensions.Dim_Equipment AS SPARQL {
SELECT bif:row_count() AS ?EquipmentID ?EquipmentCode ?Name ?Class ?Purpose
?Type ?SubType bif: <function>(SELECT ContractID FROM
I4M.Dimensions.Dim_Contract WHERE ContractorFiscalID = '00000000000') AS
?ContractID ?AddressID
FROM <http://i4m.izone.pt/registry/citymeta#>
WHERE {
?equipment <http://i4m.izone.pt/registry/ontology#hasAddress> ?address .
?equipment <http://i4m.izone.pt/registry/ontology#feedByElectricityMeter>
?electricityMeter .
?electricityMeter <http://i4m.izone.pt/registry/ontology#hasMeterNumber>
?EquipmentCode .
?equipment <http://i4m.izone.pt/registry/ontology#hasName> ?Name .
?equipment <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> ?facility .
?facility <http://www.w3.org/2000/01/rdf-schema#label> ?Purpose .
?facility <http://www.w3.org/2000/01/rdf-schema#subClassOf> ?class .
?class <http://www.w3.org/2000/01/rdf-schema#label> ?Class .
?electricityMeter <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
?mtype .
?mtype <http://www.w3.org/2000/01/rdf-schema#label> ?SubType .
?mtype <http://www.w3.org/2000/01/rdf-schema#subClassOf> ?meter .
?meter <http://www.w3.org/2000/01/rdf-schema#label> ?Type .
}
}
Regards
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
