VOS.NorthWindREFExample9

  • Topic
  • Discussion
  • VOS.NorthWindREFExample9(Last) -- DAVWikiAdmin? , 2017-06-29 07:34:51 Edit WebDAV System Administrator 2017-06-29 02:34:51

    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)