Not logged in : Login

About: NorthWindREFExample9     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : atom:Entry, within Data Space : ods.openlinksw.com associated with source document(s)

AttributesValues
type
Date Created
Date Modified
label
  • NorthWindREFExample9
maker
Title
  • NorthWindREFExample9
isDescribedUsing
has creator
content
  • ---++++Dump all <nowiki>OrderLines</nowiki> including order date timestamps accurate to the second (as opposed to millisecond) and quantity expression. <verbatim> 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")) . } </verbatim> ---++++Sample Data (Live Query Results) * View Query Results [[http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+ndw%3A%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fnorthwind%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0ASELECT+%3Fo_date+%3Fp_name+%3Fo_uprice+%3Fquantity+%3Fdiscount%0D%0AWHERE%0D%0A++%7B+%0D%0A++++%3Fol+rdf%3Atype+ndw%3AOrderLine+.%0D%0A++++%3Fol+ndw%3Ahas_order_id+%3Foid+.%0D%0A++++%3Foid+rdf%3Atype+ndw%3AOrder+.%0D%0A++++%3Foid+ndw%3AorderDate+%3Fo_date+.%0D%0A++++%3Fol+ndw%3Ahas_product_id+%3Fpid+.%0D%0A++++%3Fpid+rdf%3Atype+ndw%3AProduct+.%0D%0A++++%3Fpid+ndw%3AproductName+%3Fp_name+.+%0D%0A++++%3Fol+ndw%3AunitPrice+%3Fo_uprice.%0D%0A++++%3Fol+ndw%3Aquantity+%3Fquantity.%0D%0A++++%3Fol+ndw%3Adiscount+%3Fdiscount.%0D%0A++++FILTER+%28xsd%3Ainteger%28%3Fquantity%29+%3E+xsd%3Ainteger%28%2215%22%29%29+.%0D%0A++++FILTER+%28xsd%3AdateTime+%28%3Fo_date%29+%3E+xsd%3AdateTime++%28%221996-01-01T10%3A00%3A00Z%22%29%29+.+++%0D%0A++%7D&format=text%2Fhtml&debug=on][(via SPARQL Protocol URL)]] * View Query Results [[http://demo.openlinksw.com/view/?format=application%2Frdf%2Bxml&maxrows=50&query=%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20ndw%3A%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fnorthwind%23%3E%0APREFIX%20xsd%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0ASELECT%20%3Fo_date%20%3Fp_name%20%3Fo_uprice%20%3Fquantity%20%3Fdiscount%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fol%20rdf%3Atype%20ndw%3AOrderLine%20.%0A%20%20%20%20%3Fol%20ndw%3Ahas_order_id%20%3Foid%20.%0A%20%20%20%20%3Foid%20rdf%3Atype%20ndw%3AOrder%20.%0A%20%20%20%20%3Foid%20ndw%3AorderDate%20%3Fo_date%20.%0A%20%20%20%20%3Fol%20ndw%3Ahas_product_id%20%3Fpid%20.%0A%20%20%20%20%3Fpid%20rdf%3Atype%20ndw%3AProduct%20.%0A%20%20%20%20%3Fpid%20ndw%3AproductName%20%3Fp_name%20.%20%0A%20%20%20%20%3Fol%20ndw%3AunitPrice%20%3Fo_uprice.%0A%20%20%20%20%3Fol%20ndw%3Aquantity%20%3Fquantity.%0A%20%20%20%20%3Fol%20ndw%3Adiscount%20%3Fdiscount.%0A%20%20%20%20FILTER%20(xsd%3Ainteger(%3Fquantity)%20%3E%20xsd%3Ainteger(%2215%22))%20.%0A%20%20%20%20FILTER%20(xsd%3AdateTime%20(%3Fo_date)%20%3E%20xsd%3AdateTime%20%20(%221996-01-01T10%3A00%3A00Z%22))%20.%20%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=][(via iSPARQL Results URL)]] * View Query Editor [[http://demo.openlinksw.com/isparql/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20ndw%3A%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fnorthwind%23%3E%0APREFIX%20xsd%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0ASELECT%20%3Fo_date%20%3Fp_name%20%3Fo_uprice%20%3Fquantity%20%3Fdiscount%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fol%20rdf%3Atype%20ndw%3AOrderLine%20.%0A%20%20%20%20%3Fol%20ndw%3Ahas_order_id%20%3Foid%20.%0A%20%20%20%20%3Foid%20rdf%3Atype%20ndw%3AOrder%20.%0A%20%20%20%20%3Foid%20ndw%3AorderDate%20%3Fo_date%20.%0A%20%20%20%20%3Fol%20ndw%3Ahas_product_id%20%3Fpid%20.%0A%20%20%20%20%3Fpid%20rdf%3Atype%20ndw%3AProduct%20.%0A%20%20%20%20%3Fpid%20ndw%3AproductName%20%3Fp_name%20.%20%0A%20%20%20%20%3Fol%20ndw%3AunitPrice%20%3Fo_uprice.%0A%20%20%20%20%3Fol%20ndw%3Aquantity%20%3Fquantity.%0A%20%20%20%20%3Fol%20ndw%3Adiscount%20%3Fdiscount.%0A%20%20%20%20FILTER%20(xsd%3Ainteger(%3Fquantity)%20%3E%20xsd%3Ainteger(%2215%22))%20.%0A%20%20%20%20FILTER%20(xsd%3AdateTime%20(%3Fo_date)%20%3E%20xsd%3AdateTime%20%20(%221996-01-01T10%3A00%3A00Z%22))%20.%20%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=][(via iSPARQL Visual Query Editor URL)]]
id
  • 3b36cc036b11980439d2fc3a74e046bd
link
has container
http://rdfs.org/si...ices#has_services
atom:title
  • NorthWindREFExample9
links to
atom:source
atom:author
atom:published
  • 2017-06-13T05:36:29Z
atom:updated
  • 2017-06-13T05:36:29Z
topic
is made of
is container of of
is link of
is http://rdfs.org/si...vices#services_of of
is links to of
is creator of of
is atom:entry of
is atom:contains of
Faceted Search & Find service v1.17_git132 as of May 12 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3332 as of Sep 11 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (15 GB total memory, 1 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software