VOS.NorthWindREFExample9

Dump all OrderLines including order date timestamps accurate to the second (as opposed to millisecond) and quantity expression.

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ndw:<http://demo.openlinksw.com/schemas/northwind#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?o_date ?p_name ?o_uprice ?quantity ?discount
WHERE
  { 
    ?ol rdf:type ndw:OrderLine .
    ?ol ndw:has_order_id ?oid .
    ?oid rdf:type ndw:Order .
    ?oid ndw:orderDate ?o_date .
    ?ol ndw:has_product_id ?pid .
    ?pid rdf:type ndw:Product .
    ?pid ndw:productName ?p_name . 
    ?ol ndw:unitPrice ?o_uprice.
    ?ol ndw:quantity ?quantity.
    ?ol ndw:discount ?discount.
    FILTER (xsd:integer(?quantity) > xsd:integer("15")) .
    FILTER (xsd:dateTime (?o_date) > xsd:dateTime  ("1996-01-01T10:00:00Z")) .   
  }

Sample Data (Live Query Results)

• View Query Results (via SPARQL Protocol URL)
• View Query Results (via iSPARQL Results URL)
• View Query Editor (via iSPARQL Visual Query Editor URL)