---++eCRM SPARQL Reference
%TOC%
---+++Key eCRM Data Space to eCRM schema Mappings
|Key|eCRM|Sample Value|
|Class|Product|ecrm:Order|
|Property|productName|ecrm:productName|
|Property|unitPrice|ecrm:unitPrice|
|Attribute|has_category|ecrm:has_category|
|Attribute|has_supplier|ecrm:has_supplier|
---++++List of eCRM classes
PREFIX rdf:
SELECT distinct ?class
FROM
WHERE
{
?o rdf:type ?class
}
---+++++Sample Data (Live Query Results)
* View Query Results [[http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%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)]]
* View Query Results [[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)]]
* View Query Editor [[http://demo.openlinksw.com/isparql/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%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)]]
---++++List of eCRM Countries
PREFIX rdf:
PREFIX ecrm:
PREFIX geo:
PREFIX owl:
SELECT *
FROM
WHERE
{
?cnt rdf:type ecrm:Country .
OPTIONAL{?cnt a geo:SpatialThing} .
OPTIONAL{?cnt owl:sameAs ?sameas} .
}
---+++++Sample Data (Live Query Results)
* View Query Results [[http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+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)]]
* View Query Results [[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)]]
* View Query Editor [[http://demo.openlinksw.com/isparql/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%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)]]
---++++List of eCRM Provinces
PREFIX rdf:
PREFIX ecrm:
PREFIX geo:
PREFIX owl:
SELECT *
FROM
WHERE
{
?prv rdf:type ecrm:Province .
OPTIONAL{?prv a geo:SpatialThing }.
OPTIONAL{?prv ecrm:provinceID ?provinceID }.
OPTIONAL{?prv ecrm:provinceName ?provinceName }.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+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)]]
* View Query Results [[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)]]
* View Query Editor [[http://demo.openlinksw.com/isparql/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%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)]]
---++++Dump of all Sales Quotas
PREFIX ecrm:
SELECT *
FROM
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 }.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Companies
PREFIX ecrm:
PREFIX foaf:
SELECT *
FROM
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 }.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Custom Fields Definitions
PREFIX ecrm:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Custom Fields
PREFIX ecrm:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump all Notes
PREFIX ecrm:
SELECT ?descr
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Company & Contacts Dump
PREFIX rdf:
PREFIX ecrm:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+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)]]
* View Query Results [[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)]]
* View Query Editor [[http://demo.openlinksw.com/isparql/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%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)]]
---++++Dump of all Contacts
PREFIX ecrm:
PREFIX foaf:
PREFIX sioc:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump all Leads
PREFIX ecrm:
PREFIX foaf:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump all Opportunities
PREFIX ecrm:
PREFIX foaf:
PREFIX cal:
PREFIX sioc:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Cases
PREFIX ecrm:
PREFIX cal:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Activities
PREFIX rdf:
PREFIX ecrm:
PREFIX cal:
SELECT *
FROM
WHERE
{
?ac a ecrm:Activity .
?ac a cal:Vevent.
OPTIONAL{?cs ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cs ecrm:owner ?owner}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[http://demo.openlinksw.com/sparql?default-graph-uri=&should-sponge=&query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+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)]]
* View Query Results [[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)]]
* View Query Editor [[http://demo.openlinksw.com/isparql/?query=PREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%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)]]
---++++Dump of all Mail Messages
PREFIX ecrm:
SELECT *
FROM
WHERE
{
?cmp a ecrm:MailMessage .
OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cmp ecrm:owner ?owner}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Documents
PREFIX ecrm:
PREFIX foaf:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Influencers
PREFIX ecrm:
PREFIX foaf:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Teams
PREFIX ecrm:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Competitors
PREFIX ecrm:
PREFIX foaf:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of all Issues
PREFIX ecrm:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump of Orders with details for customers, company name, country, etc.
PREFIX ecrm:
SELECT *
FROM
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}.
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump all Countries containing in their name "Aus".
PREFIX ecrm:
PREFIX geo:
SELECT ?name ?code
FROM
WHERE
{
?cnt a ecrm:Country .
?cnt a geo:SpatialThing .
?cnt ecrm:countryName ?name .
?cnt ecrm:isoCode ?code .
FILTER REGEX(str(?name), "^Aus") .
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++Dump all Provinces starting with "B"
PREFIX ecrm:
PREFIX geo:
SELECT ?name
FROM
WHERE
{
?cnt a ecrm:Province .
?cnt a geo:SpatialThing .
?cnt ecrm:provinceName ?name .
FILTER REGEX(str(?name), "^B") .
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++All Orders made by customer "General Motors"
PREFIX ecrm:
SELECT COUNT(*)
FROM
WHERE
{
?ord a ecrm:Order.
?ord ecrm:companyName ?scompany FILTER (?scompany like '%Motor%') .
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++All Contacts associated with "New Way"
PREFIX ecrm:
SELECT COUNT(*)
FROM
WHERE
{
?ord a ecrm:Employment.
?ord ecrm:has_contact ?scontact .
?ord ecrm:has_company ?scompany FILTER (?scompany like '%New%') .
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++ Count of Orders from Russia
PREFIX ecrm:
SELECT COUNT(*)
FROM
WHERE
{
?ord a ecrm:Order.
?ord ecrm:shipCountry ?scountry FILTER (?scountry like '%Russia%') .
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++All Leads containing "Lead from" in their subject
PREFIX ecrm:
SELECT *
FROM
WHERE
{
?st a ecrm:Lead .
?st ecrm:subject ?subject FILTER (?subject like '%Lead from%') .
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++All Lost Opportunities
PREFIX ecrm:
PREFIX foaf:
PREFIX cal:
PREFIX sioc:
SELECT COUNT(*)
FROM
WHERE
{
?st a ecrm:Opportunity.
?st ecrm:status ?status FILTER (?status like '%Lost%') .
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---++++All Cases after 2006
PREFIX cal:
PREFIX ecrm:
SELECT *
FROM
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")).
}
---+++++Sample Data (Live Query Results)
* View Query Results [[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)]]
* View Query Results [[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)]]
* View Query Editor [[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)]]
---+++References
* [[http://ods.openlinksw.com/wiki/ODS/ODSeCRMGoodRelationsRef][eCRM SPARQL GoodRelations Reference]]
* [[VirtRDFViewODSeCRM][eCRM RDF Views]]