ECRMRefeCRM SPARQL Reference Key eCRM Data Space to eCRM schema Mappings <tgroup><thead /><tbody> <row><entry>Key</entry><entry>eCRM</entry><entry>Sample Value</entry></row> <row><entry>Class</entry><entry>Product</entry><entry>ecrm:Order</entry></row> <row><entry>Property</entry><entry>productName</entry><entry>ecrm:productName</entry></row> <row><entry>Property</entry><entry>unitPrice</entry><entry>ecrm:unitPrice</entry></row> <row><entry>Attribute</entry><entry>has_category</entry><entry>ecrm:has_category</entry></row> <row><entry>Attribute</entry><entry>has_supplier</entry><entry>ecrm:has_supplier</entry></row> </tbody></tgroup></table> <bridgehead class="http://www.w3.org/1999/xhtml:h4">List of eCRM classes</bridgehead> <programlisting>PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> SELECT distinct ?class FROM <http://demo.openlinksw.com/ecrm> WHERE { ?o rdf:type ?class } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="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%0ASELECT+distinct+%3Fclass+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E+%0D%0AWHERE+%0D%0A++%7B+%0D%0A++++%3Fo+rdf%3Atype+%3Fclass+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0ASELECT%20distinct%20%3Fclass%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%20%0AWHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3Fo%20rdf%3Atype%20%3Fclass%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0ASELECT%20distinct%20%3Fclass%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%20%0AWHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3Fo%20rdf%3Atype%20%3Fclass%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h4">List of eCRM Countries</bridgehead> <programlisting>PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> PREFIX owl: <http://www.w3.org/2002/07/owl#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cnt rdf:type ecrm:Country . OPTIONAL{?cnt a geo:SpatialThing} . OPTIONAL{?cnt owl:sameAs ?sameas} . } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="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+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+geo%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0ASELECT+*%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E+%0D%0AWHERE+%0D%0A++%7B+%0D%0A++++%3Fcnt+rdf%3Atype+ecrm%3ACountry++.%0D%0A++++OPTIONAL%7B%3Fcnt+a+geo%3ASpatialThing%7D+.%0D%0A++++OPTIONAL%7B%3Fcnt+owl%3AsameAs+%3Fsameas%7D+.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0APREFIX%20owl%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0ASELECT%20*%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%20%0AWHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3Fcnt%20rdf%3Atype%20ecrm%3ACountry%20%20.%0A%20%20%20%20OPTIONAL%7B%3Fcnt%20a%20geo%3ASpatialThing%7D%20.%0A%20%20%20%20OPTIONAL%7B%3Fcnt%20owl%3AsameAs%20%3Fsameas%7D%20.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="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%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0APREFIX%20owl%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0ASELECT%20*%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%20%0AWHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3Fcnt%20rdf%3Atype%20ecrm%3ACountry%20%20.%0A%20%20%20%20OPTIONAL%7B%3Fcnt%20a%20geo%3ASpatialThing%7D%20.%0A%20%20%20%20OPTIONAL%7B%3Fcnt%20owl%3AsameAs%20%3Fsameas%7D%20.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">List of eCRM Provinces</bridgehead> <programlisting>PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> PREFIX owl: <http://www.w3.org/2002/07/owl#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?prv rdf:type ecrm:Province . OPTIONAL{?prv a geo:SpatialThing }. OPTIONAL{?prv ecrm:provinceID ?provinceID }. OPTIONAL{?prv ecrm:provinceName ?provinceName }. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="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+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+geo%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0ASELECT+*%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E+%0D%0AWHERE+%0D%0A++%7B+%0D%0A++++%3Fprv+rdf%3Atype+ecrm%3AProvince++.%0D%0A++++OPTIONAL%7B%3Fprv+a+geo%3ASpatialThing+%7D.%0D%0A++++OPTIONAL%7B%3Fprv+ecrm%3AprovinceID+%3FprovinceID+%7D.%0D%0A++++OPTIONAL%7B%3Fprv+ecrm%3AprovinceName+%3FprovinceName+%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0APREFIX%20owl%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0ASELECT%20*%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%20%0AWHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3Fprv%20rdf%3Atype%20ecrm%3AProvince%20%20.%0A%20%20%20%20OPTIONAL%7B%3Fprv%20a%20geo%3ASpatialThing%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Fprv%20ecrm%3AprovinceID%20%3FprovinceID%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Fprv%20ecrm%3AprovinceName%20%3FprovinceName%20%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="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%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0APREFIX%20owl%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0ASELECT%20*%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%20%0AWHERE%20%0A%20%20%7B%20%0A%20%20%20%20%3Fprv%20rdf%3Atype%20ecrm%3AProvince%20%20.%0A%20%20%20%20OPTIONAL%7B%3Fprv%20a%20geo%3ASpatialThing%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Fprv%20ecrm%3AprovinceID%20%3FprovinceID%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Fprv%20ecrm%3AprovinceName%20%3FprovinceName%20%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Sales Quotas</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cmp a ecrm:SalesQuota . OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?cmp ecrm:has_user ?has_user}. OPTIONAL{?cmp ecrm:owner ?owner }. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fcmp+a+ecrm%3ASalesQuota+.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_user+%3Fhas_user%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Aowner+%3Fowner+%7D.+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ASalesQuota%20.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_user%20%3Fhas_user%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Aowner%20%3Fowner%20%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ASalesQuota%20.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_user%20%3Fhas_user%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Aowner%20%3Fowner%20%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Companies</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cmp a ecrm:Company. ?cmp a foaf:Organization. OPTIONAL{ ?cmp ecrm:has_ecrm_organization ?hasorg }. OPTIONAL{ ?cmp ecrm:owner ?owner }. OPTIONAL{ ?cmp ecrm:FREETEXT_ID ?FREETEXT_ID }. OPTIONAL{ ?cmp foaf:name ?name }. OPTIONAL{ ?cmp ecrm:industry ?industry }. OPTIONAL{ ?cmp foaf:homepage ?homepage }. OPTIONAL{ ?cmp foaf:phone ?phone }. OPTIONAL{ ?cmp ecrm:phoneExtension ?phoneExtension }. OPTIONAL{ ?cmp ecrm:faxNumber ?faxNumber }. OPTIONAL{ ?cmp ecrm:faxExtension ?faxExtension }. OPTIONAL{ ?cmp ecrm:mobileNumber ?mobileNumber }. OPTIONAL{ ?cmp foaf:mbox ?mbox }. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fcmp+a+ecrm%3ACompany.%0D%0A++++%3Fcmp+a+foaf%3AOrganization.%0D%0A++++OPTIONAL%7B+%3Fcmp+ecrm%3Ahas_ecrm_organization+%3Fhasorg+%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+ecrm%3Aowner+%3Fowner++%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+ecrm%3AFREETEXT_ID+%3FFREETEXT_ID+%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+foaf%3Aname+%3Fname+%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+ecrm%3Aindustry+%3Findustry++%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+foaf%3Ahomepage+%3Fhomepage++%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+foaf%3Aphone+%3Fphone++%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+ecrm%3AphoneExtension+%3FphoneExtension++%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+ecrm%3AfaxNumber+%3FfaxNumber++%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+ecrm%3AfaxExtension+%3FfaxExtension++%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+ecrm%3AmobileNumber+%3FmobileNumber++%7D.%0D%0A++++OPTIONAL%7B+%3Fcmp+foaf%3Ambox+%3Fmbox++%7D.%0D%0A%0D%0A+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ACompany.%0A%20%20%20%20%3Fcmp%20a%20foaf%3AOrganization.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhasorg%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3Aowner%20%3Fowner%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20foaf%3Aname%20%3Fname%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3Aindustry%20%3Findustry%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20foaf%3Ahomepage%20%3Fhomepage%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20foaf%3Aphone%20%3Fphone%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AphoneExtension%20%3FphoneExtension%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AfaxNumber%20%3FfaxNumber%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AfaxExtension%20%3FfaxExtension%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AmobileNumber%20%3FmobileNumber%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20foaf%3Ambox%20%3Fmbox%20%20%7D.%0A%0A%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ACompany.%0A%20%20%20%20%3Fcmp%20a%20foaf%3AOrganization.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhasorg%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3Aowner%20%3Fowner%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20foaf%3Aname%20%3Fname%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3Aindustry%20%3Findustry%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20foaf%3Ahomepage%20%3Fhomepage%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20foaf%3Aphone%20%3Fphone%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AphoneExtension%20%3FphoneExtension%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AfaxNumber%20%3FfaxNumber%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AfaxExtension%20%3FfaxExtension%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20ecrm%3AmobileNumber%20%3FmobileNumber%20%20%7D.%0A%20%20%20%20OPTIONAL%7B%20%3Fcmp%20foaf%3Ambox%20%3Fmbox%20%20%7D.%0A%0A%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Custom Fields Definitions</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cmp a ecrm:CustomFieldDefs. OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_organization}. OPTIONAL{?cmp ecrm:has_class ?has_class}. OPTIONAL{?cmp ecrm:fieldName ?fieldName}. OPTIONAL{?cmp ecrm:fieldType ?fieldType}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fcmp+a+ecrm%3ACustomFieldDefs.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_ecrm_organization+%3Fhas_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_class+%3Fhas_class%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AfieldName+%3FfieldName%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AfieldType+%3FfieldType%7D.+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ACustomFieldDefs.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_class%20%3Fhas_class%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AfieldName%20%3FfieldName%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AfieldType%20%3FfieldType%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ACustomFieldDefs.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_class%20%3Fhas_class%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AfieldName%20%3FfieldName%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AfieldType%20%3FfieldType%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Custom Fields</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cmp a ecrm:CustomField OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_organization}. OPTIONAL{?cmp ecrm:has_field ?has_field}. OPTIONAL{?cmp ecrm:fieldValue ?fieldValue}. } </programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fcmp+a+ecrm%3ACustomField%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_ecrm_organization+%3Fhas_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_field+%3Fhas_field%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AfieldValue+%3FfieldValue%7D.+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ACustomField%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_field%20%3Fhas_field%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AfieldValue%20%3FfieldValue%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ACustomField%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_field%20%3Fhas_field%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AfieldValue%20%3FfieldValue%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump all Notes</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT ?descr FROM <http://demo.openlinksw.com/ecrm> WHERE { ?nt a ecrm:Note . OPTIONAL{?nt ecrm:has_ecrm_organization ?hasorg}. OPTIONAL{?nt ecrm:owner ?owner}. OPTIONAL{?nt ecrm:FREETEXT_ID ?FREETEXT_ID}. OPTIONAL{?nt ecrm:DESCRIPTION ?descr}. } </programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+%3Fdescr%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE%0D%0A++%7B+%0D%0A++++%3Fnt+a+ecrm%3ANote+.%0D%0A++++OPTIONAL%7B%3Fnt+ecrm%3Ahas_ecrm_organization+%3Fhasorg%7D.%0D%0A++++OPTIONAL%7B%3Fnt+ecrm%3Aowner+%3Fowner%7D.%0D%0A++++OPTIONAL%7B%3Fnt+ecrm%3AFREETEXT_ID+%3FFREETEXT_ID%7D.%0D%0A++++OPTIONAL%7B%3Fnt+ecrm%3ADESCRIPTION+%3Fdescr%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20%3Fdescr%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fnt%20a%20ecrm%3ANote%20.%0A%20%20%20%20OPTIONAL%7B%3Fnt%20ecrm%3Ahas_ecrm_organization%20%3Fhasorg%7D.%0A%20%20%20%20OPTIONAL%7B%3Fnt%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%20%20OPTIONAL%7B%3Fnt%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fnt%20ecrm%3ADESCRIPTION%20%3Fdescr%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20%3Fdescr%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fnt%20a%20ecrm%3ANote%20.%0A%20%20%20%20OPTIONAL%7B%3Fnt%20ecrm%3Ahas_ecrm_organization%20%3Fhasorg%7D.%0A%20%20%20%20OPTIONAL%7B%3Fnt%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%20%20OPTIONAL%7B%3Fnt%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fnt%20ecrm%3ADESCRIPTION%20%3Fdescr%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Company & Contacts Dump</bridgehead> <programlisting>PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?ctr a ecrm:Employment. OPTIONAL{?ctr ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?ctr ecrm:has_company ?has_company}. OPTIONAL{?ctr ecrm:has_contact ?has_contact}. OPTIONAL{?ctr ecrm:owner ?owner}. OPTIONAL{?ctr ecrm:department ?department}. OPTIONAL{?ctr ecrm:title ?title}. OPTIONAL{?ctr ecrm:phoneNumber ?phoneNumber}. OPTIONAL{?ctr ecrm:phoneExtension ?phoneExtension}. OPTIONAL{?ctr ecrm:faxNumber ?faxNumber}. OPTIONAL{?ctr ecrm:faxExtension ?faxExtension}. OPTIONAL{?ctr ecrm:mobileNumber ?mobileNumber}. OPTIONAL{?ctr ecrm:email ?email}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="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+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT++*%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fctr+a+ecrm%3AEmployment.++++%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3Ahas_company+%3Fhas_company%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3Ahas_contact+%3Fhas_contact%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3Aowner+%3Fowner%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3Adepartment+%3Fdepartment%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3Atitle+%3Ftitle%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3AphoneNumber+%3FphoneNumber%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3AphoneExtension+%3FphoneExtension%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3AfaxNumber+%3FfaxNumber%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3AfaxExtension+%3FfaxExtension%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3AmobileNumber+%3FmobileNumber%7D.%0D%0A++++OPTIONAL%7B%3Fctr+ecrm%3Aemail+%3Femail%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20%20*%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fctr%20a%20ecrm%3AEmployment.%20%20%20%20%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Ahas_contact%20%3Fhas_contact%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Adepartment%20%3Fdepartment%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Atitle%20%3Ftitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AphoneNumber%20%3FphoneNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AphoneExtension%20%3FphoneExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AfaxNumber%20%3FfaxNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AfaxExtension%20%3FfaxExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AmobileNumber%20%3FmobileNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Aemail%20%3Femail%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="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%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20%20*%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fctr%20a%20ecrm%3AEmployment.%20%20%20%20%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Ahas_contact%20%3Fhas_contact%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Adepartment%20%3Fdepartment%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Atitle%20%3Ftitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AphoneNumber%20%3FphoneNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AphoneExtension%20%3FphoneExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AfaxNumber%20%3FfaxNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AfaxExtension%20%3FfaxExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3AmobileNumber%20%3FmobileNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fctr%20ecrm%3Aemail%20%3Femail%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Contacts</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX sioc: <http://rdfs.org/sioc/ns#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cn a ecrm:Contact . ?cn a foaf:Person. OPTIONAL{?cn ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?cn ecrm:FREETEXT_ID ?FREETEXT_ID}. OPTIONAL{?cn foaf:title ?title}. OPTIONAL{?cn foaf:firstName ?firstName}. OPTIONAL{?cn foaf:givenname ?givenname}. OPTIONAL{?cn foaf:surname ?surname}. OPTIONAL{?cn foaf:birthday ?birthDate}. OPTIONAL{?cn ecrm:contactType ?contactType}. OPTIONAL{?cn ecrm:manager ?manager}. OPTIONAL{?cn sioc:User ?User}. OPTIONAL{?cn ecrm:business ?business}. OPTIONAL{?cn foaf:interest ?interest}. OPTIONAL{?cn ecrm:sourceTitle ?sourceTitle}. OPTIONAL{?cn foaf:phone ?phone}. OPTIONAL{?cn ecrm:phoneExtension ?phoneExtension}. OPTIONAL{?cn ecrm:phone2Number ?phone2Number}. OPTIONAL{?cn ecrm:phone2Extension ?phone2Extension}. OPTIONAL{?cn ecrm:faxNumber ?faxNumber}. OPTIONAL{?cn ecrm:faxExtension ?faxExtension}. OPTIONAL{?cn ecrm:mobileNumber ?mobileNumber}. OPTIONAL{?cn foaf:mbox ?mbox}. OPTIONAL{?cn ecrm:country ?country}. OPTIONAL{?cn ecrm:province ?province}. OPTIONAL{?cn ecrm:city ?city}. OPTIONAL{?cn ecrm:postalCode ?postalCode}. OPTIONAL{?cn ecrm:address1 ?address1}. OPTIONAL{?cn ecrm:address2 ?address2}. OPTIONAL{?cn ecrm:description ?description}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+sioc%3A+%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE%0D%0A++%7B+%0D%0A++++%3Fcn+a+ecrm%3AContact+.%0D%0A++++%3Fcn+a+foaf%3APerson.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3AFREETEXT_ID+%3FFREETEXT_ID%7D.%0D%0A++++OPTIONAL%7B%3Fcn+foaf%3Atitle+%3Ftitle%7D.%0D%0A++++OPTIONAL%7B%3Fcn+foaf%3AfirstName+%3FfirstName%7D.%0D%0A++++OPTIONAL%7B%3Fcn+foaf%3Agivenname+%3Fgivenname%7D.%0D%0A++++OPTIONAL%7B%3Fcn+foaf%3Asurname+%3Fsurname%7D.%0D%0A++++OPTIONAL%7B%3Fcn+foaf%3Abirthday+%3FbirthDate%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3AcontactType+%3FcontactType%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Amanager+%3Fmanager%7D.%0D%0A++++OPTIONAL%7B%3Fcn+sioc%3AUser+%3FUser%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Abusiness+%3Fbusiness%7D.%0D%0A++++OPTIONAL%7B%3Fcn+foaf%3Ainterest+%3Finterest%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3AsourceTitle+%3FsourceTitle%7D.%0D%0A++++OPTIONAL%7B%3Fcn+foaf%3Aphone+%3Fphone%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3AphoneExtension+%3FphoneExtension%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Aphone2Number+%3Fphone2Number%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Aphone2Extension+%3Fphone2Extension%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3AfaxNumber+%3FfaxNumber%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3AfaxExtension+%3FfaxExtension%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3AmobileNumber+%3FmobileNumber%7D.%0D%0A++++OPTIONAL%7B%3Fcn+foaf%3Ambox+%3Fmbox%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Acountry+%3Fcountry%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Aprovince+%3Fprovince%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Acity+%3Fcity%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3ApostalCode+%3FpostalCode%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Aaddress1+%3Faddress1%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Aaddress2+%3Faddress2%7D.%0D%0A++++OPTIONAL%7B%3Fcn+ecrm%3Adescription+%3Fdescription%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20sioc%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fcn%20a%20ecrm%3AContact%20.%0A%20%20%20%20%3Fcn%20a%20foaf%3APerson.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Atitle%20%3Ftitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3AfirstName%20%3FfirstName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Agivenname%20%3Fgivenname%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Asurname%20%3Fsurname%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Abirthday%20%3FbirthDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AcontactType%20%3FcontactType%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Amanager%20%3Fmanager%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20sioc%3AUser%20%3FUser%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Abusiness%20%3Fbusiness%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Ainterest%20%3Finterest%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AsourceTitle%20%3FsourceTitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Aphone%20%3Fphone%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AphoneExtension%20%3FphoneExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aphone2Number%20%3Fphone2Number%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aphone2Extension%20%3Fphone2Extension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AfaxNumber%20%3FfaxNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AfaxExtension%20%3FfaxExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AmobileNumber%20%3FmobileNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Ambox%20%3Fmbox%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Acountry%20%3Fcountry%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aprovince%20%3Fprovince%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Acity%20%3Fcity%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3ApostalCode%20%3FpostalCode%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aaddress1%20%3Faddress1%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aaddress2%20%3Faddress2%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Adescription%20%3Fdescription%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20sioc%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fcn%20a%20ecrm%3AContact%20.%0A%20%20%20%20%3Fcn%20a%20foaf%3APerson.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Atitle%20%3Ftitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3AfirstName%20%3FfirstName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Agivenname%20%3Fgivenname%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Asurname%20%3Fsurname%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Abirthday%20%3FbirthDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AcontactType%20%3FcontactType%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Amanager%20%3Fmanager%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20sioc%3AUser%20%3FUser%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Abusiness%20%3Fbusiness%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Ainterest%20%3Finterest%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AsourceTitle%20%3FsourceTitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Aphone%20%3Fphone%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AphoneExtension%20%3FphoneExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aphone2Number%20%3Fphone2Number%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aphone2Extension%20%3Fphone2Extension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AfaxNumber%20%3FfaxNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AfaxExtension%20%3FfaxExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3AmobileNumber%20%3FmobileNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20foaf%3Ambox%20%3Fmbox%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Acountry%20%3Fcountry%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aprovince%20%3Fprovince%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Acity%20%3Fcity%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3ApostalCode%20%3FpostalCode%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aaddress1%20%3Faddress1%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Aaddress2%20%3Faddress2%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcn%20ecrm%3Adescription%20%3Fdescription%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump all Leads</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?st a ecrm:Lead . ?st a foaf:Person . OPTIONAL{?st ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?st ecrm:FREETEXT_ID ?FREETEXT_ID}. OPTIONAL{?st ecrm:subject ?subject}. OPTIONAL{?st foaf:title ?title }. OPTIONAL{?st foaf:firstName ?firstName}. OPTIONAL{?st foaf:givenname ?givenname}. OPTIONAL{?st foaf:surname ?surname}. OPTIONAL{?st ecrm:company ?company}. OPTIONAL{?st ecrm:has_company ?has_company}. OPTIONAL{?st ecrm:leadTitle ?leadtitle }. OPTIONAL{?st ecrm:status ?status}. OPTIONAL{?st ecrm:rating ?rating}. OPTIONAL{?st foaf:phone ?phone}. OPTIONAL{?st ecrm:phoneExtension ?phoneExtension}. OPTIONAL{?st ecrm:mobileNumber ?mobileNumber}. OPTIONAL{?st ecrm:faxNumber ?faxNumber}. OPTIONAL{?st ecrm:faxExtension ?faxExtension}. OPTIONAL{?st foaf:mbox ?mbox}. OPTIONAL{?st ecrm:country ?country}. OPTIONAL{?st ecrm:province ?province}. OPTIONAL{?st ecrm:city ?city}. OPTIONAL{?st ecrm:postalCode ?postalCode}. OPTIONAL{?st ecrm:address1 ?address1}. OPTIONAL{?st ecrm:address2 ?address2}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE%0D%0A++%7B+%0D%0A++++%3Fst+a+ecrm%3ALead+.%0D%0A++++%3Fst+a+foaf%3APerson+.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AFREETEXT_ID+%3FFREETEXT_ID%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Asubject+%3Fsubject%7D.%0D%0A++++OPTIONAL%7B%3Fst+foaf%3Atitle+%3Ftitle+%7D.+++%0D%0A++++OPTIONAL%7B%3Fst+foaf%3AfirstName+%3FfirstName%7D.%0D%0A++++OPTIONAL%7B%3Fst+foaf%3Agivenname+%3Fgivenname%7D.%0D%0A++++OPTIONAL%7B%3Fst+foaf%3Asurname+%3Fsurname%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Acompany+%3Fcompany%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Ahas_company+%3Fhas_company%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AleadTitle+%3Fleadtitle+%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Astatus+%3Fstatus%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Arating+%3Frating%7D.%0D%0A++++OPTIONAL%7B%3Fst+foaf%3Aphone+%3Fphone%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AphoneExtension+%3FphoneExtension%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AmobileNumber+%3FmobileNumber%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AfaxNumber+%3FfaxNumber%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AfaxExtension+%3FfaxExtension%7D.%0D%0A++++OPTIONAL%7B%3Fst+foaf%3Ambox+%3Fmbox%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Acountry+%3Fcountry%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Aprovince+%3Fprovince%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Acity+%3Fcity%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3ApostalCode+%3FpostalCode%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Aaddress1+%3Faddress1%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Aaddress2+%3Faddress2%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fst%20a%20ecrm%3ALead%20.%0A%20%20%20%20%3Fst%20a%20foaf%3APerson%20.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Asubject%20%3Fsubject%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Atitle%20%3Ftitle%20%7D.%20%20%20%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3AfirstName%20%3FfirstName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Agivenname%20%3Fgivenname%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Asurname%20%3Fsurname%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acompany%20%3Fcompany%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AleadTitle%20%3Fleadtitle%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Astatus%20%3Fstatus%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Arating%20%3Frating%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Aphone%20%3Fphone%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AphoneExtension%20%3FphoneExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AmobileNumber%20%3FmobileNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AfaxNumber%20%3FfaxNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AfaxExtension%20%3FfaxExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Ambox%20%3Fmbox%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acountry%20%3Fcountry%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Aprovince%20%3Fprovince%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acity%20%3Fcity%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3ApostalCode%20%3FpostalCode%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Aaddress1%20%3Faddress1%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Aaddress2%20%3Faddress2%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fst%20a%20ecrm%3ALead%20.%0A%20%20%20%20%3Fst%20a%20foaf%3APerson%20.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Asubject%20%3Fsubject%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Atitle%20%3Ftitle%20%7D.%20%20%20%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3AfirstName%20%3FfirstName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Agivenname%20%3Fgivenname%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Asurname%20%3Fsurname%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acompany%20%3Fcompany%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AleadTitle%20%3Fleadtitle%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Astatus%20%3Fstatus%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Arating%20%3Frating%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Aphone%20%3Fphone%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AphoneExtension%20%3FphoneExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AmobileNumber%20%3FmobileNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AfaxNumber%20%3FfaxNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AfaxExtension%20%3FfaxExtension%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20foaf%3Ambox%20%3Fmbox%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acountry%20%3Fcountry%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Aprovince%20%3Fprovince%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acity%20%3Fcity%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3ApostalCode%20%3FpostalCode%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Aaddress1%20%3Faddress1%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Aaddress2%20%3Faddress2%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump all Opportunities</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX cal: <http://www.w3.org/2002/12/cal/ical#> PREFIX sioc: <http://rdfs.org/sioc/ns#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?st a ecrm:Opportunity. ?st a cal:Vevent. OPTIONAL{?st ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?st ecrm:FREETEXT_ID ?FREETEXT_ID}. OPTIONAL{?st ecrm:opportunityName ?opportunityName}. OPTIONAL{?st sioc:User ?user}. OPTIONAL{?st ecrm:manager ?manager}. OPTIONAL{?st ecrm:company ?company}. OPTIONAL{?st ecrm:has_company ?has_company}. OPTIONAL{?st ecrm:has_contact ?has_contact}. OPTIONAL{?st ecrm:contactName ?contactName}. OPTIONAL{?st ecrm:forecast ?forecast}. OPTIONAL{?st ecrm:estimateClose ?estimateClose}. OPTIONAL{?st cal:dtstart ?dtstart}. OPTIONAL{?st ecrm:startDate ?startDate}. OPTIONAL{?st ecrm:status ?status}. OPTIONAL{?st ecrm:code ?code}. OPTIONAL{?st ecrm:stageTitle ?stageTitle}. OPTIONAL{?st ecrm:sourceTitle ?sourceTitle}. OPTIONAL{?st ecrm:closedAmount ?closedAmount}. OPTIONAL{?st cal:dtend ?dtend}. OPTIONAL{?st ecrm:closedDate ?closedDate}. OPTIONAL{?st ecrm:propability ?propability}. OPTIONAL{?st ecrm:potential ?potential}. } </programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+cal%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0D%0APREFIX+sioc%3A+%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE%0D%0A++%7B+%0D%0A++++%3Fst+a+ecrm%3AOpportunity.%0D%0A++++%3Fst+a+cal%3AVevent.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AFREETEXT_ID+%3FFREETEXT_ID%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AopportunityName+%3FopportunityName%7D.%0D%0A++++OPTIONAL%7B%3Fst+sioc%3AUser+%3Fuser%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Amanager+%3Fmanager%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Acompany+%3Fcompany%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Ahas_company+%3Fhas_company%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Ahas_contact+%3Fhas_contact%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AcontactName+%3FcontactName%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Aforecast+%3Fforecast%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AestimateClose+%3FestimateClose%7D.%0D%0A++++OPTIONAL%7B%3Fst+cal%3Adtstart+%3Fdtstart%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AstartDate+%3FstartDate%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Astatus+%3Fstatus%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Acode+%3Fcode%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AstageTitle+%3FstageTitle%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AsourceTitle+%3FsourceTitle%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AclosedAmount+%3FclosedAmount%7D.%0D%0A++++OPTIONAL%7B%3Fst+cal%3Adtend+%3Fdtend%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3AclosedDate+%3FclosedDate%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Apropability+%3Fpropability%7D.%0D%0A++++OPTIONAL%7B%3Fst+ecrm%3Apotential+%3Fpotential%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0APREFIX%20sioc%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fst%20a%20ecrm%3AOpportunity.%0A%20%20%20%20%3Fst%20a%20cal%3AVevent.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AopportunityName%20%3FopportunityName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20sioc%3AUser%20%3Fuser%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Amanager%20%3Fmanager%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acompany%20%3Fcompany%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_contact%20%3Fhas_contact%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AcontactName%20%3FcontactName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Aforecast%20%3Fforecast%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AestimateClose%20%3FestimateClose%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20cal%3Adtstart%20%3Fdtstart%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AstartDate%20%3FstartDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Astatus%20%3Fstatus%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acode%20%3Fcode%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AstageTitle%20%3FstageTitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AsourceTitle%20%3FsourceTitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AclosedAmount%20%3FclosedAmount%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20cal%3Adtend%20%3Fdtend%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AclosedDate%20%3FclosedDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Apropability%20%3Fpropability%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Apotential%20%3Fpotential%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0APREFIX%20sioc%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fst%20a%20ecrm%3AOpportunity.%0A%20%20%20%20%3Fst%20a%20cal%3AVevent.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AFREETEXT_ID%20%3FFREETEXT_ID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AopportunityName%20%3FopportunityName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20sioc%3AUser%20%3Fuser%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Amanager%20%3Fmanager%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acompany%20%3Fcompany%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Ahas_contact%20%3Fhas_contact%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AcontactName%20%3FcontactName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Aforecast%20%3Fforecast%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AestimateClose%20%3FestimateClose%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20cal%3Adtstart%20%3Fdtstart%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AstartDate%20%3FstartDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Astatus%20%3Fstatus%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Acode%20%3Fcode%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AstageTitle%20%3FstageTitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AsourceTitle%20%3FsourceTitle%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AclosedAmount%20%3FclosedAmount%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20cal%3Adtend%20%3Fdtend%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3AclosedDate%20%3FclosedDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Apropability%20%3Fpropability%7D.%0A%20%20%20%20OPTIONAL%7B%3Fst%20ecrm%3Apotential%20%3Fpotential%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Cases</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX cal: <http://www.w3.org/2002/12/cal/ical#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cs a ecrm:Case . ?cs a cal:Vevent. OPTIONAL{?cs ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?cs ecrm:summary ?summary}. OPTIONAL{?cs ecrm:status ?status}. OPTIONAL{?cs ecrm:priority ?priority}. OPTIONAL{?cs cal:dtstart ?dtstart}. OPTIONAL{?cs ecrm:openDate ?openDate}. OPTIONAL{?cs cal:dtclose ?dtclose}. OPTIONAL{?cs ecrm:lastActionDate ?lastActionDate}. OPTIONAL{?cs ecrm:daysOld ?daysOld}. OPTIONAL{?cs ecrm:has_company ?has_company}. OPTIONAL{?cs ecrm:company ?company}. OPTIONAL{?cs ecrm:has_contact ?has_contact}. OPTIONAL{?cs ecrm:contactName ?contactName}. OPTIONAL{?cs cal:url ?url}. OPTIONAL{?cs ecrm:application ?application}. OPTIONAL{?cs ecrm:appVer ?appVer}. OPTIONAL{?cs ecrm:phoneNumber ?phoneNumber}. OPTIONAL{?cs ecrm:relationship ?relationship}. OPTIONAL{?cs ecrm:email ?email}. OPTIONAL{?cs ecrm:client ?client}. OPTIONAL{?cs ecrm:clientVersion ?clientVersion}. OPTIONAL{?cs ecrm:office ?office}. OPTIONAL{?cs ecrm:consultant ?consultant}. OPTIONAL{?cs ecrm:dbVer ?dbVer}. OPTIONAL{?cs ecrm:misTsID ?misTsID}. OPTIONAL{?cs ecrm:oplClient ?oplClient}. OPTIONAL{?cs ecrm:oplVer ?oplVer}. OPTIONAL{?cs ecrm:server ?server}. OPTIONAL{?cs ecrm:serverVersion ?serverVersion}. OPTIONAL{?cs ecrm:downloadDate ?downloadDate}. OPTIONAL{?cs ecrm:jobTitle ?jobTitle}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+cal%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fcs+a+ecrm%3ACase+.%0D%0A++++%3Fcs+a+cal%3AVevent.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Asummary+%3Fsummary%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Astatus+%3Fstatus%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Apriority+%3Fpriority%7D.%0D%0A++++OPTIONAL%7B%3Fcs+cal%3Adtstart+%3Fdtstart%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AopenDate+%3FopenDate%7D.%0D%0A++++OPTIONAL%7B%3Fcs+cal%3Adtclose+%3Fdtclose%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AlastActionDate+%3FlastActionDate%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AdaysOld+%3FdaysOld%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Ahas_company+%3Fhas_company%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Acompany+%3Fcompany%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Ahas_contact+%3Fhas_contact%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AcontactName+%3FcontactName%7D.%0D%0A++++OPTIONAL%7B%3Fcs+cal%3Aurl+%3Furl%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Aapplication+%3Fapplication%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AappVer+%3FappVer%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AphoneNumber+%3FphoneNumber%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Arelationship+%3Frelationship%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Aemail+%3Femail%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Aclient+%3Fclient%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AclientVersion+%3FclientVersion%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Aoffice+%3Foffice%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Aconsultant+%3Fconsultant%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AdbVer+%3FdbVer%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AmisTsID+%3FmisTsID%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AoplClient+%3FoplClient%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AoplVer+%3FoplVer%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Aserver+%3Fserver%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AserverVersion+%3FserverVersion%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AdownloadDate+%3FdownloadDate%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3AjobTitle+%3FjobTitle%7D.+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcs%20a%20ecrm%3ACase%20.%0A%20%20%20%20%3Fcs%20a%20cal%3AVevent.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Asummary%20%3Fsummary%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Astatus%20%3Fstatus%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Apriority%20%3Fpriority%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20cal%3Adtstart%20%3Fdtstart%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AopenDate%20%3FopenDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20cal%3Adtclose%20%3Fdtclose%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AlastActionDate%20%3FlastActionDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AdaysOld%20%3FdaysOld%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Acompany%20%3Fcompany%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_contact%20%3Fhas_contact%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AcontactName%20%3FcontactName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20cal%3Aurl%20%3Furl%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aapplication%20%3Fapplication%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AappVer%20%3FappVer%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AphoneNumber%20%3FphoneNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Arelationship%20%3Frelationship%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aemail%20%3Femail%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aclient%20%3Fclient%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AclientVersion%20%3FclientVersion%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aoffice%20%3Foffice%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aconsultant%20%3Fconsultant%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AdbVer%20%3FdbVer%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AmisTsID%20%3FmisTsID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AoplClient%20%3FoplClient%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AoplVer%20%3FoplVer%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aserver%20%3Fserver%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AserverVersion%20%3FserverVersion%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AdownloadDate%20%3FdownloadDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AjobTitle%20%3FjobTitle%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcs%20a%20ecrm%3ACase%20.%0A%20%20%20%20%3Fcs%20a%20cal%3AVevent.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Asummary%20%3Fsummary%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Astatus%20%3Fstatus%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Apriority%20%3Fpriority%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20cal%3Adtstart%20%3Fdtstart%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AopenDate%20%3FopenDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20cal%3Adtclose%20%3Fdtclose%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AlastActionDate%20%3FlastActionDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AdaysOld%20%3FdaysOld%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Acompany%20%3Fcompany%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_contact%20%3Fhas_contact%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AcontactName%20%3FcontactName%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20cal%3Aurl%20%3Furl%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aapplication%20%3Fapplication%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AappVer%20%3FappVer%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AphoneNumber%20%3FphoneNumber%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Arelationship%20%3Frelationship%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aemail%20%3Femail%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aclient%20%3Fclient%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AclientVersion%20%3FclientVersion%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aoffice%20%3Foffice%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aconsultant%20%3Fconsultant%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AdbVer%20%3FdbVer%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AmisTsID%20%3FmisTsID%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AoplClient%20%3FoplClient%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AoplVer%20%3FoplVer%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aserver%20%3Fserver%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AserverVersion%20%3FserverVersion%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AdownloadDate%20%3FdownloadDate%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3AjobTitle%20%3FjobTitle%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Activities</bridgehead> <programlisting>PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX cal: <http://www.w3.org/2002/12/cal/ical#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?ac a ecrm:Activity . ?ac a cal:Vevent. OPTIONAL{?cs ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?cs ecrm:owner ?owner}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="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+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+cal%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fac+a+ecrm%3AActivity+.%0D%0A++++%3Fac+a+cal%3AVevent.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Aowner+%3Fowner%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fac%20a%20ecrm%3AActivity%20.%0A%20%20%20%20%3Fac%20a%20cal%3AVevent.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="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%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fac%20a%20ecrm%3AActivity%20.%0A%20%20%20%20%3Fac%20a%20cal%3AVevent.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Mail Messages</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cmp a ecrm:MailMessage . OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?cmp ecrm:owner ?owner}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fcmp+a+ecrm%3AMailMessage+.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Aowner+%3Fowner%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3AMailMessage%20.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3AMailMessage%20.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Documents</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?doc a ecrm:Document. ?doc a foaf:Document. OPTIONAL{?doc ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?doc ecrm:owner ?owner}. OPTIONAL{?doc ecrm:item ?item}. OPTIONAL{?doc ecrm:reference ?reference}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fdoc+a+ecrm%3ADocument.%0D%0A++++%3Fdoc+a+foaf%3ADocument.%0D%0A++++OPTIONAL%7B%3Fdoc+ecrm%3Ahas_ecrm_organization++%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fdoc+ecrm%3Aowner+%3Fowner%7D.%0D%0A++++OPTIONAL%7B%3Fdoc+ecrm%3Aitem+%3Fitem%7D.%0D%0A++++OPTIONAL%7B%3Fdoc+ecrm%3Areference+%3Freference%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fdoc%20a%20ecrm%3ADocument.%0A%20%20%20%20%3Fdoc%20a%20foaf%3ADocument.%0A%20%20%20%20OPTIONAL%7B%3Fdoc%20ecrm%3Ahas_ecrm_organization%20%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fdoc%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%20%20OPTIONAL%7B%3Fdoc%20ecrm%3Aitem%20%3Fitem%7D.%0A%20%20%20%20OPTIONAL%7B%3Fdoc%20ecrm%3Areference%20%3Freference%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fdoc%20a%20ecrm%3ADocument.%0A%20%20%20%20%3Fdoc%20a%20foaf%3ADocument.%0A%20%20%20%20OPTIONAL%7B%3Fdoc%20ecrm%3Ahas_ecrm_organization%20%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fdoc%20ecrm%3Aowner%20%3Fowner%7D.%0A%20%20%20%20OPTIONAL%7B%3Fdoc%20ecrm%3Aitem%20%3Fitem%7D.%0A%20%20%20%20OPTIONAL%7B%3Fdoc%20ecrm%3Areference%20%3Freference%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Influencers</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?inf a ecrm:Influencer . ?inf a foaf:Person. OPTIONAL{?inf ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?inf ecrm:has_opportunity ?has_opportunity}. OPTIONAL{?inf ecrm:has_company ?has_company}. OPTIONAL{?inf ecrm:contactName ?contactName}. OPTIONAL{?inf foaf:title ?title}. OPTIONAL{?inf ecrm:IROLE ?IROLE}. OPTIONAL{?inf ecrm:responseMode ?responseMode}. } </programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Finf+a+ecrm%3AInfluencer+.%0D%0A++++%3Finf+a+foaf%3APerson.%0D%0A++++OPTIONAL%7B%3Finf+ecrm%3Ahas_ecrm_organization++%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Finf+ecrm%3Ahas_opportunity+%3Fhas_opportunity%7D.+%0D%0A++++OPTIONAL%7B%3Finf+ecrm%3Ahas_company+%3Fhas_company%7D.+%0D%0A++++OPTIONAL%7B%3Finf+ecrm%3AcontactName++%3FcontactName%7D.%0D%0A++++OPTIONAL%7B%3Finf+foaf%3Atitle+%3Ftitle%7D.+%0D%0A++++OPTIONAL%7B%3Finf+ecrm%3AIROLE+%3FIROLE%7D.+%0D%0A++++OPTIONAL%7B%3Finf+ecrm%3AresponseMode+%3FresponseMode%7D.+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Finf%20a%20ecrm%3AInfluencer%20.%0A%20%20%20%20%3Finf%20a%20foaf%3APerson.%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3Ahas_ecrm_organization%20%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3Ahas_opportunity%20%3Fhas_opportunity%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3Ahas_company%20%3Fhas_company%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3AcontactName%20%20%3FcontactName%7D.%0A%20%20%20%20OPTIONAL%7B%3Finf%20foaf%3Atitle%20%3Ftitle%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3AIROLE%20%3FIROLE%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3AresponseMode%20%3FresponseMode%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Finf%20a%20ecrm%3AInfluencer%20.%0A%20%20%20%20%3Finf%20a%20foaf%3APerson.%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3Ahas_ecrm_organization%20%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3Ahas_opportunity%20%3Fhas_opportunity%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3Ahas_company%20%3Fhas_company%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3AcontactName%20%20%3FcontactName%7D.%0A%20%20%20%20OPTIONAL%7B%3Finf%20foaf%3Atitle%20%3Ftitle%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3AIROLE%20%3FIROLE%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Finf%20ecrm%3AresponseMode%20%3FresponseMode%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Teams</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?tm a ecrm:Team. OPTIONAL{?tm ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?tm ecrm:has_opportunity ?has_opportunity}. OPTIONAL{?tm ecrm:has_contact ?has_contact}. OPTIONAL{?tm ecrm:title ?title }. OPTIONAL{?tm ecrm:department ?department}. OPTIONAL{?tm ecrm:TROLE ?TROLE}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Ftm+a+ecrm%3ATeam.%0D%0A++++OPTIONAL%7B%3Ftm+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Ftm+ecrm%3Ahas_opportunity+%3Fhas_opportunity%7D.%0D%0A++++OPTIONAL%7B%3Ftm+ecrm%3Ahas_contact+%3Fhas_contact%7D.+%0D%0A++++OPTIONAL%7B%3Ftm+ecrm%3Atitle+%3Ftitle+%7D.+%0D%0A++++OPTIONAL%7B%3Ftm+ecrm%3Adepartment+%3Fdepartment%7D.+%0D%0A++++OPTIONAL%7B%3Ftm+ecrm%3ATROLE+%3FTROLE%7D.+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ftm%20a%20ecrm%3ATeam.%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Ahas_opportunity%20%3Fhas_opportunity%7D.%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Ahas_contact%20%3Fhas_contact%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Atitle%20%3Ftitle%20%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Adepartment%20%3Fdepartment%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3ATROLE%20%3FTROLE%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ftm%20a%20ecrm%3ATeam.%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Ahas_opportunity%20%3Fhas_opportunity%7D.%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Ahas_contact%20%3Fhas_contact%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Atitle%20%3Ftitle%20%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3Adepartment%20%3Fdepartment%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Ftm%20ecrm%3ATROLE%20%3FTROLE%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Competitors</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cmp a ecrm:Competitor . ?cmp a foaf:Organization. OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?cmp ecrm:has_opportunity ?has_opportunity}. OPTIONAL{?cmp ecrm:has_company ?has_company}. OPTIONAL{?cmp ecrm:has_product ?has_product }. OPTIONAL{?cmp foaf:name ?name}. OPTIONAL{?cmp ecrm:productName ?productName}. OPTIONAL{?cmp ecrm:Strengths ?Strengths}. OPTIONAL{?cmp ecrm:Weakness ?Weakness}. OPTIONAL{?cmp ecrm:Rating ?Rating}. OPTIONAL{?cmp ecrm:Status ?Status}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fcmp+a+ecrm%3ACompetitor+.%0D%0A++++%3Fcmp+a+foaf%3AOrganization.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_opportunity+%3Fhas_opportunity%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_company+%3Fhas_company%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_product+%3Fhas_product+%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+foaf%3Aname+%3Fname%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AproductName+%3FproductName%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AStrengths+%3FStrengths%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AWeakness+%3FWeakness%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3ARating+%3FRating%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AStatus+%3FStatus%7D.+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ACompetitor%20.%0A%20%20%20%20%3Fcmp%20a%20foaf%3AOrganization.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_opportunity%20%3Fhas_opportunity%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_company%20%3Fhas_company%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_product%20%3Fhas_product%20%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20foaf%3Aname%20%3Fname%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AproductName%20%3FproductName%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AStrengths%20%3FStrengths%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AWeakness%20%3FWeakness%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3ARating%20%3FRating%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AStatus%20%3FStatus%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3ACompetitor%20.%0A%20%20%20%20%3Fcmp%20a%20foaf%3AOrganization.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_opportunity%20%3Fhas_opportunity%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_company%20%3Fhas_company%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_product%20%3Fhas_product%20%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20foaf%3Aname%20%3Fname%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AproductName%20%3FproductName%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AStrengths%20%3FStrengths%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AWeakness%20%3FWeakness%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3ARating%20%3FRating%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AStatus%20%3FStatus%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of all Issues</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cmp a ecrm:Issue. OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?cmp ecrm:has_opportunity ?has_opportunity}. OPTIONAL{?cmp ecrm:subject ?subject}. OPTIONAL{?cmp ecrm:reference ?reference }. OPTIONAL{?cmp ecrm:priority ?priority}. OPTIONAL{?cmp ecrm:issueDate ?issueDate}. OPTIONAL{?cmp ecrm:status ?status}. OPTIONAL{?cmp ecrm:userName ?userName}. OPTIONAL{?cmp ecrm:docTitle ?docTitle}. } </programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fcmp+a+ecrm%3AIssue.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_ecrm_organization++%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Ahas_opportunity+%3Fhas_opportunity%7D.%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Asubject+%3Fsubject%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Areference+%3Freference+%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Apriority+%3Fpriority%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AissueDate+%3FissueDate%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3Astatus+%3Fstatus%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AuserName+%3FuserName%7D.+%0D%0A++++OPTIONAL%7B%3Fcmp+ecrm%3AdocTitle+%3FdocTitle%7D.+%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3AIssue.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_opportunity%20%3Fhas_opportunity%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Asubject%20%3Fsubject%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Areference%20%3Freference%20%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Apriority%20%3Fpriority%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AissueDate%20%3FissueDate%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Astatus%20%3Fstatus%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AuserName%20%3FuserName%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AdocTitle%20%3FdocTitle%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcmp%20a%20ecrm%3AIssue.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_ecrm_organization%20%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Ahas_opportunity%20%3Fhas_opportunity%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Asubject%20%3Fsubject%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Areference%20%3Freference%20%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Apriority%20%3Fpriority%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AissueDate%20%3FissueDate%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3Astatus%20%3Fstatus%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AuserName%20%3FuserName%7D.%20%0A%20%20%20%20OPTIONAL%7B%3Fcmp%20ecrm%3AdocTitle%20%3FdocTitle%7D.%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump of Orders with details for customers, company name, country, etc.</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?ord a ecrm:Order. OPTIONAL{?ord ecrm:has_ecrm_organization ?org }. OPTIONAL{?ord ecrm:has_company ?has_company}. OPTIONAL{?ord ecrm:companyName ?company }. OPTIONAL{?ord ecrm:contactName ?contact}. OPTIONAL{?ord ecrm:year ?year}. OPTIONAL{?ord ecrm:month ?month}. OPTIONAL{?ord ecrm:quarter ?quarter}. OPTIONAL{?ord ecrm:financialYear ?financialYear}. } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Ford+a+ecrm%3AOrder.%0D%0A++++OPTIONAL%7B%3Ford+ecrm%3Ahas_ecrm_organization+%3Forg+%7D.%0D%0A++++OPTIONAL%7B%3Ford+ecrm%3Ahas_company+%3Fhas_company%7D.%0D%0A++++OPTIONAL%7B%3Ford+ecrm%3AcompanyName+%3Fcompany+%7D.%0D%0A++++OPTIONAL%7B%3Ford+ecrm%3AcontactName+%3Fcontact%7D.+++%0D%0A++++OPTIONAL%7B%3Ford+ecrm%3Ayear+%3Fyear%7D.%0D%0A++++OPTIONAL%7B%3Ford+ecrm%3Amonth+%3Fmonth%7D.%0D%0A++++OPTIONAL%7B%3Ford+ecrm%3Aquarter+%3Fquarter%7D.%0D%0A++++OPTIONAL%7B%3Ford+ecrm%3AfinancialYear+%3FfinancialYear%7D.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ford%20a%20ecrm%3AOrder.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Ahas_ecrm_organization%20%3Forg%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3AcompanyName%20%3Fcompany%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3AcontactName%20%3Fcontact%7D.%20%20%20%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Ayear%20%3Fyear%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Amonth%20%3Fmonth%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Aquarter%20%3Fquarter%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3AfinancialYear%20%3FfinancialYear%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ford%20a%20ecrm%3AOrder.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Ahas_ecrm_organization%20%3Forg%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Ahas_company%20%3Fhas_company%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3AcompanyName%20%3Fcompany%20%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3AcontactName%20%3Fcontact%7D.%20%20%20%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Ayear%20%3Fyear%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Amonth%20%3Fmonth%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3Aquarter%20%3Fquarter%7D.%0A%20%20%20%20OPTIONAL%7B%3Ford%20ecrm%3AfinancialYear%20%3FfinancialYear%7D.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump all Countries containing in their name "Aus". </bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> SELECT ?name ?code FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cnt a ecrm:Country . ?cnt a geo:SpatialThing . ?cnt ecrm:countryName ?name . ?cnt ecrm:isoCode ?code . FILTER REGEX(str(?name), "^Aus") . } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+geo%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0D%0ASELECT+%3Fname+%3Fcode+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE%0D%0A++%7B+%0D%0A++++%3Fcnt+a+ecrm%3ACountry+.+%0D%0A++++%3Fcnt+a+geo%3ASpatialThing+.%0D%0A++++%3Fcnt+ecrm%3AcountryName+%3Fname+.%0D%0A++++%3Fcnt+ecrm%3AisoCode+%3Fcode+.%0D%0A++++FILTER+REGEX%28str%28%3Fname%29%2C+%22%5EAus%22%29++++.++%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0ASELECT%20%3Fname%20%3Fcode%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fcnt%20a%20ecrm%3ACountry%20.%20%0A%20%20%20%20%3Fcnt%20a%20geo%3ASpatialThing%20.%0A%20%20%20%20%3Fcnt%20ecrm%3AcountryName%20%3Fname%20.%0A%20%20%20%20%3Fcnt%20ecrm%3AisoCode%20%3Fcode%20.%0A%20%20%20%20FILTER%20REGEX(str(%3Fname)%2C%20%22%5EAus%22)%20%20%20%20.%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0ASELECT%20%3Fname%20%3Fcode%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fcnt%20a%20ecrm%3ACountry%20.%20%0A%20%20%20%20%3Fcnt%20a%20geo%3ASpatialThing%20.%0A%20%20%20%20%3Fcnt%20ecrm%3AcountryName%20%3Fname%20.%0A%20%20%20%20%3Fcnt%20ecrm%3AisoCode%20%3Fcode%20.%0A%20%20%20%20FILTER%20REGEX(str(%3Fname)%2C%20%22%5EAus%22)%20%20%20%20.%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">Dump all Provinces starting with "B"</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> SELECT ?name FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cnt a ecrm:Province . ?cnt a geo:SpatialThing . ?cnt ecrm:provinceName ?name . FILTER REGEX(str(?name), "^B") . } </programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+geo%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0D%0ASELECT+%3Fname+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE%0D%0A++%7B+%0D%0A++++%3Fcnt+a+ecrm%3AProvince+.%0D%0A++++%3Fcnt+a+geo%3ASpatialThing+.%0D%0A++++%3Fcnt+ecrm%3AprovinceName+%3Fname+.%0D%0A++++FILTER+REGEX%28str%28%3Fname%29%2C+%22%5EB%22%29+.++%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0ASELECT%20%3Fname%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fcnt%20a%20ecrm%3AProvince%20.%0A%20%20%20%20%3Fcnt%20a%20geo%3ASpatialThing%20.%0A%20%20%20%20%3Fcnt%20ecrm%3AprovinceName%20%3Fname%20.%0A%20%20%20%20FILTER%20REGEX(str(%3Fname)%2C%20%22%5EB%22)%20.%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20geo%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0ASELECT%20%3Fname%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fcnt%20a%20ecrm%3AProvince%20.%0A%20%20%20%20%3Fcnt%20a%20geo%3ASpatialThing%20.%0A%20%20%20%20%3Fcnt%20ecrm%3AprovinceName%20%3Fname%20.%0A%20%20%20%20FILTER%20REGEX(str(%3Fname)%2C%20%22%5EB%22)%20.%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h4">All Orders made by customer "General Motors"</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT COUNT(*) FROM <http://demo.openlinksw.com/ecrm> WHERE { ?ord a ecrm:Order. ?ord ecrm:companyName ?scompany FILTER (?scompany like '%Motor%') . } </programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+COUNT%28*%29%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Ford+a+ecrm%3AOrder.%0D%0A++++%3Ford+ecrm%3AcompanyName+%3Fscompany+FILTER+%28%3Fscompany+like+%27%25Motor%25%27%29+.++++%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20COUNT(*)%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ford%20a%20ecrm%3AOrder.%0A%20%20%20%20%3Ford%20ecrm%3AcompanyName%20%3Fscompany%20FILTER%20(%3Fscompany%20like%20%27%25Motor%25%27)%20.%20%20%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20COUNT(*)%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ford%20a%20ecrm%3AOrder.%0A%20%20%20%20%3Ford%20ecrm%3AcompanyName%20%3Fscompany%20FILTER%20(%3Fscompany%20like%20%27%25Motor%25%27)%20.%20%20%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">All Contacts associated with "New Way"</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT COUNT(*) FROM <http://demo.openlinksw.com/ecrm> WHERE { ?ord a ecrm:Employment. ?ord ecrm:has_contact ?scontact . ?ord ecrm:has_company ?scompany FILTER (?scompany like '%New%') . } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+COUNT%28*%29%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Ford+a+ecrm%3AEmployment.%0D%0A++++%3Ford+ecrm%3Ahas_contact+%3Fscontact+.%0D%0A++++%3Ford+ecrm%3Ahas_company+%3Fscompany+FILTER+%28%3Fscompany+like+%27%25New%25%27%29+.++%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20COUNT(*)%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ford%20a%20ecrm%3AEmployment.%0A%20%20%20%20%3Ford%20ecrm%3Ahas_contact%20%3Fscontact%20.%0A%20%20%20%20%3Ford%20ecrm%3Ahas_company%20%3Fscompany%20FILTER%20(%3Fscompany%20like%20%27%25New%25%27)%20.%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20COUNT(*)%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ford%20a%20ecrm%3AEmployment.%0A%20%20%20%20%3Ford%20ecrm%3Ahas_contact%20%3Fscontact%20.%0A%20%20%20%20%3Ford%20ecrm%3Ahas_company%20%3Fscompany%20FILTER%20(%3Fscompany%20like%20%27%25New%25%27)%20.%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4"> Count of Orders from Russia</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT COUNT(*) FROM <http://demo.openlinksw.com/ecrm> WHERE { ?ord a ecrm:Order. ?ord ecrm:shipCountry ?scountry FILTER (?scountry like '%Russia%') . } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+COUNT%28*%29+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Ford+a+ecrm%3AOrder.%0D%0A++++%3Ford+ecrm%3AshipCountry+%3Fscountry+FILTER+%28%3Fscountry+like+%27%25Russia%25%27%29+.++++%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20COUNT(*)%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ford%20a%20ecrm%3AOrder.%0A%20%20%20%20%3Ford%20ecrm%3AshipCountry%20%3Fscountry%20FILTER%20(%3Fscountry%20like%20%27%25Russia%25%27)%20.%20%20%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20COUNT(*)%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Ford%20a%20ecrm%3AOrder.%0A%20%20%20%20%3Ford%20ecrm%3AshipCountry%20%3Fscountry%20FILTER%20(%3Fscountry%20like%20%27%25Russia%25%27)%20.%20%20%20%20%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">All Leads containing "Lead from" in their subject</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?st a ecrm:Lead . ?st ecrm:subject ?subject FILTER (?subject like '%Lead from%') . } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE%0D%0A++%7B+%0D%0A++++%3Fst+a+ecrm%3ALead+.%0D%0A++++%3Fst+ecrm%3Asubject+%3Fsubject+FILTER+%28%3Fsubject+like+%27%25Lead+from%25%27%29+.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fst%20a%20ecrm%3ALead%20.%0A%20%20%20%20%3Fst%20ecrm%3Asubject%20%3Fsubject%20FILTER%20(%3Fsubject%20like%20%27%25Lead%20from%25%27)%20.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fst%20a%20ecrm%3ALead%20.%0A%20%20%20%20%3Fst%20ecrm%3Asubject%20%3Fsubject%20FILTER%20(%3Fsubject%20like%20%27%25Lead%20from%25%27)%20.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h4">All Lost Opportunities</bridgehead> <programlisting>PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX cal: <http://www.w3.org/2002/12/cal/ical#> PREFIX sioc: <http://rdfs.org/sioc/ns#> SELECT COUNT(*) FROM <http://demo.openlinksw.com/ecrm> WHERE { ?st a ecrm:Opportunity. ?st ecrm:status ?status FILTER (?status like '%Lost%') . } </programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+cal%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0D%0APREFIX+sioc%3A+%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0D%0ASELECT+COUNT%28*%29%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE%0D%0A++%7B+%0D%0A++++%3Fst+a+ecrm%3AOpportunity.%0D%0A++++%3Fst+ecrm%3Astatus+%3Fstatus++FILTER+%28%3Fstatus++like+%27%25Lost%25%27%29+.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0APREFIX%20sioc%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0ASELECT%20COUNT(*)%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fst%20a%20ecrm%3AOpportunity.%0A%20%20%20%20%3Fst%20ecrm%3Astatus%20%3Fstatus%20%20FILTER%20(%3Fstatus%20%20like%20%27%25Lost%25%27)%20.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0APREFIX%20sioc%3A%20%3Chttp%3A%2F%2Frdfs.org%2Fsioc%2Fns%23%3E%0ASELECT%20COUNT(*)%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%0A%20%20%7B%20%0A%20%20%20%20%3Fst%20a%20ecrm%3AOpportunity.%0A%20%20%20%20%3Fst%20ecrm%3Astatus%20%3Fstatus%20%20FILTER%20(%3Fstatus%20%20like%20%27%25Lost%25%27)%20.%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h4">All Cases after 2006</bridgehead> <programlisting>PREFIX cal: <http://www.w3.org/2002/12/cal/ical#> PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#> SELECT * FROM <http://demo.openlinksw.com/ecrm> WHERE { ?cs a ecrm:Case . ?cs a cal:Vevent. OPTIONAL{?cs ecrm:has_ecrm_organization ?has_ecrm_organization}. OPTIONAL{?cs ecrm:owner ?owner}. OPTIONAL{?cs ecrm:summary ?summary}. OPTIONAL{?cs ecrm:status ?status}. OPTIONAL{?cs ecrm:priority ?priority}. OPTIONAL{?cs cal:dtstart ?dtstart}. FILTER (xsd:dateTime (?dtstart) > xsd:dateTime ("2001-01-01T00:00:00Z")). } </programlisting><para> </para> <bridgehead class="http://www.w3.org/1999/xhtml:h5">Sample Data (Live Query Results)</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem>View Query Results <ulink url="http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+cal%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0D%0APREFIX+ecrm%3A+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0D%0ASELECT+*+%0D%0AFROM+%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0D%0AWHERE+%0D%0A++%7B%0D%0A++++%3Fcs+a+ecrm%3ACase+.%0D%0A++++%3Fcs+a+cal%3AVevent.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Ahas_ecrm_organization+%3Fhas_ecrm_organization%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Aowner++%3Fowner%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Asummary+%3Fsummary%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Astatus+%3Fstatus%7D.%0D%0A++++OPTIONAL%7B%3Fcs+ecrm%3Apriority+%3Fpriority%7D.%0D%0A++++OPTIONAL%7B%3Fcs+cal%3Adtstart+%3Fdtstart%7D.%0D%0A++++FILTER+%28xsd%3AdateTime+%28%3Fdtstart%29+%3E+xsd%3AdateTime+%28%222001-01-01T00%3A00%3A00Z%22%29%29.%0D%0A++%7D&format=text%2Fhtml&timeout=">(via SPARQL Protocol URL)</ulink> </listitem> <listitem>View Query Results <ulink url="http://demo.openlinksw.com/isparql/view/?query=PREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0APREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcs%20a%20ecrm%3ACase%20.%0A%20%20%20%20%3Fcs%20a%20cal%3AVevent.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aowner%20%20%3Fowner%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Asummary%20%3Fsummary%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Astatus%20%3Fstatus%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Apriority%20%3Fpriority%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20cal%3Adtstart%20%3Fdtstart%7D.%0A%20%20%20%20FILTER%20(xsd%3AdateTime%20(%3Fdtstart)%20%3E%20xsd%3AdateTime%20(%222001-01-01T00%3A00%3A00Z%22)).%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Results URL)</ulink> </listitem> <listitem>View Query Editor <ulink url="http://demo.openlinksw.com/isparql/?query=PREFIX%20cal%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F12%2Fcal%2Fical%23%3E%0APREFIX%20ecrm%3A%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fschemas%2Fecrm%23%3E%0ASELECT%20*%20%0AFROM%20%3Chttp%3A%2F%2Fdemo.openlinksw.com%2Fecrm%3E%0AWHERE%20%0A%20%20%7B%0A%20%20%20%20%3Fcs%20a%20ecrm%3ACase%20.%0A%20%20%20%20%3Fcs%20a%20cal%3AVevent.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Ahas_ecrm_organization%20%3Fhas_ecrm_organization%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Aowner%20%20%3Fowner%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Asummary%20%3Fsummary%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Astatus%20%3Fstatus%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20ecrm%3Apriority%20%3Fpriority%7D.%0A%20%20%20%20OPTIONAL%7B%3Fcs%20cal%3Adtstart%20%3Fdtstart%7D.%0A%20%20%20%20FILTER%20(xsd%3AdateTime%20(%3Fdtstart)%20%3E%20xsd%3AdateTime%20(%222001-01-01T00%3A00%3A00Z%22)).%0A%20%20%7D&endpoint=/sparql&maxrows=50&default-graph-uri=">(via iSPARQL Visual Query Editor URL)</ulink></listitem> </itemizedlist><bridgehead class="http://www.w3.org/1999/xhtml:h3">References</bridgehead> <itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="http://ods.openlinksw.com/wiki/ODS/ODSeCRMGoodRelationsRef">eCRM SPARQL GoodRelations Reference</ulink> </listitem> <listitem><ulink url="VirtRDFViewODSeCRM">eCRM RDF Views</ulink> </listitem> </itemizedlist></section></docbook>