Hi, Is it possible to create an rdf attribute as a manipulation of 1 or more columns from a table or does this have to be done in a sql view prior to the rdf view? I attempted to perform a concat like the one below but got the error - SQ074: Line 46: SP031: SPARQL compiler: Table alias name is not specified for column concat.
Eg SPARQL prefix Demo: <http://localhost:8890/schemas/Demo/> prefix demo-stat: <http://localhost:8890/Demo/stat#> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix void: <http://rdfs.org/ns/void#> prefix scovo: <http://purl.org/NET/scovo#> prefix aowl: <http://bblfish.net/work/atom-owl/2006-06-06/> prefix iron: <http://purl.org/ontology/iron#> alter quad storage virtrdf:DefaultQuadStorage from "Demo"."demo"."Employees" as employees_s from "Demo"."demo"."Orders" as orders_s where (^{orders_s.}^."EmployeeID" = ^{employees_s.}^."EmployeeID") { create Demo:qm-employees as graph iri ("http://^{URIQADefaultHost}^/Demo#") { # Maps from columns of "Demo.demo.Employees" Demo:employees (employees_s."EmployeeID") a Demo:Employees ; Demo:employeeid employees_s."EmployeeID" as Demo:demo-employees-employeeid ; Demo:lastname employees_s."LastName" as Demo:demo-employees-lastname ; Demo:firstname employees_s."FirstName" as Demo:demo-employees-firstname ; * iron:prefLabel concat(employees_s."FirstName", ' ', employees."LastName") as iron:demo-employees-prefLabel ;* Demo:title employees_s."Title" as Demo:demo-employees-title ; Demo:titleofcourtesy employees_s."TitleOfCourtesy" as Demo:demo-employees-titleofcourtesy ; Demo:birthdate employees_s."BirthDate" as Demo:demo-employees-birthdate ; Demo:hiredate employees_s."HireDate" as Demo:demo-employees-hiredate ; Demo:address employees_s."Address" as Demo:demo-employees-address ; Demo:city employees_s."City" as Demo:demo-employees-city ; Demo:region employees_s."Region" as Demo:demo-employees-region ; Demo:postalcode employees_s."PostalCode" as Demo:demo-employees-postalcode ; Demo:country employees_s."Country" as Demo:demo-employees-country ; Demo:countrycode employees_s."CountryCode" as Demo:demo-employees-countrycode ; Demo:homephone employees_s."HomePhone" as Demo:demo-employees-homephone ; Demo:extension employees_s."Extension" as Demo:demo-employees-extension ; Demo:photo Demo:employees_photo (employees_s."EmployeeID") as Demo:demo-employees-photo ; Demo:notes employees_s."Notes" as Demo:demo-employees-notes ; Demo:reportsto employees_s."ReportsTo" as Demo:demo-employees-reportsto ; # Maps from foreign-key relations of "Demo.demo.Employees" Demo:employees_of Demo:orders (orders_s."OrderID") as Demo:employees_orders_of . Demo:employees_photo (employees_s."EmployeeID") a aowl:Content ; aowl:body employees_s."Photo" as Demo:demo-employees-photo-content ; aowl:type "application/octet-stream" . } } ; cheers Mark