eCRM SPARQL Reference
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: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
SELECT distinct ?class
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?o rdf:type ?class
}
Sample Data (Live Query Results)
List of eCRM Countries
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cnt rdf:type ecrm:Country .
OPTIONAL{?cnt a geo:SpatialThing} .
OPTIONAL{?cnt owl:sameAs ?sameas} .
}
Sample Data (Live Query Results)
List of eCRM Provinces
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX owl: <http://www.w3.org/2002/07/owl#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?prv rdf:type ecrm:Province .
OPTIONAL{?prv a geo:SpatialThing }.
OPTIONAL{?prv ecrm:provinceID ?provinceID }.
OPTIONAL{?prv ecrm:provinceName ?provinceName }.
}
Sample Data (Live Query Results)
Dump of all Sales Quotas
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cmp a ecrm:SalesQuota .
OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cmp ecrm:has_user ?has_user}.
OPTIONAL{?cmp ecrm:owner ?owner }.
}
Sample Data (Live Query Results)
Dump of all Companies
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cmp a ecrm:Company.
?cmp a foaf:Organization.
OPTIONAL{ ?cmp ecrm:has_ecrm_organization ?hasorg }.
OPTIONAL{ ?cmp ecrm:owner ?owner }.
OPTIONAL{ ?cmp ecrm:FREETEXT_ID ?FREETEXT_ID }.
OPTIONAL{ ?cmp foaf:name ?name }.
OPTIONAL{ ?cmp ecrm:industry ?industry }.
OPTIONAL{ ?cmp foaf:homepage ?homepage }.
OPTIONAL{ ?cmp foaf:phone ?phone }.
OPTIONAL{ ?cmp ecrm:phoneExtension ?phoneExtension }.
OPTIONAL{ ?cmp ecrm:faxNumber ?faxNumber }.
OPTIONAL{ ?cmp ecrm:faxExtension ?faxExtension }.
OPTIONAL{ ?cmp ecrm:mobileNumber ?mobileNumber }.
OPTIONAL{ ?cmp foaf:mbox ?mbox }.
}
Sample Data (Live Query Results)
Dump of all Custom Fields Definitions
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cmp a ecrm:CustomFieldDefs.
OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_organization}.
OPTIONAL{?cmp ecrm:has_class ?has_class}.
OPTIONAL{?cmp ecrm:fieldName ?fieldName}.
OPTIONAL{?cmp ecrm:fieldType ?fieldType}.
}
Sample Data (Live Query Results)
Dump of all Custom Fields
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cmp a ecrm:CustomField
OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_organization}.
OPTIONAL{?cmp ecrm:has_field ?has_field}.
OPTIONAL{?cmp ecrm:fieldValue ?fieldValue}.
}
Sample Data (Live Query Results)
Dump all Notes
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT ?descr
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?nt a ecrm:Note .
OPTIONAL{?nt ecrm:has_ecrm_organization ?hasorg}.
OPTIONAL{?nt ecrm:owner ?owner}.
OPTIONAL{?nt ecrm:FREETEXT_ID ?FREETEXT_ID}.
OPTIONAL{?nt ecrm:DESCRIPTION ?descr}.
}
Sample Data (Live Query Results)
Company & Contacts Dump
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?ctr a ecrm:Employment.
OPTIONAL{?ctr ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?ctr ecrm:has_company ?has_company}.
OPTIONAL{?ctr ecrm:has_contact ?has_contact}.
OPTIONAL{?ctr ecrm:owner ?owner}.
OPTIONAL{?ctr ecrm:department ?department}.
OPTIONAL{?ctr ecrm:title ?title}.
OPTIONAL{?ctr ecrm:phoneNumber ?phoneNumber}.
OPTIONAL{?ctr ecrm:phoneExtension ?phoneExtension}.
OPTIONAL{?ctr ecrm:faxNumber ?faxNumber}.
OPTIONAL{?ctr ecrm:faxExtension ?faxExtension}.
OPTIONAL{?ctr ecrm:mobileNumber ?mobileNumber}.
OPTIONAL{?ctr ecrm:email ?email}.
}
Sample Data (Live Query Results)
Dump of all Contacts
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX sioc: <http://rdfs.org/sioc/ns#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cn a ecrm:Contact .
?cn a foaf:Person.
OPTIONAL{?cn ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cn ecrm:FREETEXT_ID ?FREETEXT_ID}.
OPTIONAL{?cn foaf:title ?title}.
OPTIONAL{?cn foaf:firstName ?firstName}.
OPTIONAL{?cn foaf:givenname ?givenname}.
OPTIONAL{?cn foaf:surname ?surname}.
OPTIONAL{?cn foaf:birthday ?birthDate}.
OPTIONAL{?cn ecrm:contactType ?contactType}.
OPTIONAL{?cn ecrm:manager ?manager}.
OPTIONAL{?cn sioc:User ?User}.
OPTIONAL{?cn ecrm:business ?business}.
OPTIONAL{?cn foaf:interest ?interest}.
OPTIONAL{?cn ecrm:sourceTitle ?sourceTitle}.
OPTIONAL{?cn foaf:phone ?phone}.
OPTIONAL{?cn ecrm:phoneExtension ?phoneExtension}.
OPTIONAL{?cn ecrm:phone2Number ?phone2Number}.
OPTIONAL{?cn ecrm:phone2Extension ?phone2Extension}.
OPTIONAL{?cn ecrm:faxNumber ?faxNumber}.
OPTIONAL{?cn ecrm:faxExtension ?faxExtension}.
OPTIONAL{?cn ecrm:mobileNumber ?mobileNumber}.
OPTIONAL{?cn foaf:mbox ?mbox}.
OPTIONAL{?cn ecrm:country ?country}.
OPTIONAL{?cn ecrm:province ?province}.
OPTIONAL{?cn ecrm:city ?city}.
OPTIONAL{?cn ecrm:postalCode ?postalCode}.
OPTIONAL{?cn ecrm:address1 ?address1}.
OPTIONAL{?cn ecrm:address2 ?address2}.
OPTIONAL{?cn ecrm:description ?description}.
}
Sample Data (Live Query Results)
Dump all Leads
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?st a ecrm:Lead .
?st a foaf:Person .
OPTIONAL{?st ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?st ecrm:FREETEXT_ID ?FREETEXT_ID}.
OPTIONAL{?st ecrm:subject ?subject}.
OPTIONAL{?st foaf:title ?title }.
OPTIONAL{?st foaf:firstName ?firstName}.
OPTIONAL{?st foaf:givenname ?givenname}.
OPTIONAL{?st foaf:surname ?surname}.
OPTIONAL{?st ecrm:company ?company}.
OPTIONAL{?st ecrm:has_company ?has_company}.
OPTIONAL{?st ecrm:leadTitle ?leadtitle }.
OPTIONAL{?st ecrm:status ?status}.
OPTIONAL{?st ecrm:rating ?rating}.
OPTIONAL{?st foaf:phone ?phone}.
OPTIONAL{?st ecrm:phoneExtension ?phoneExtension}.
OPTIONAL{?st ecrm:mobileNumber ?mobileNumber}.
OPTIONAL{?st ecrm:faxNumber ?faxNumber}.
OPTIONAL{?st ecrm:faxExtension ?faxExtension}.
OPTIONAL{?st foaf:mbox ?mbox}.
OPTIONAL{?st ecrm:country ?country}.
OPTIONAL{?st ecrm:province ?province}.
OPTIONAL{?st ecrm:city ?city}.
OPTIONAL{?st ecrm:postalCode ?postalCode}.
OPTIONAL{?st ecrm:address1 ?address1}.
OPTIONAL{?st ecrm:address2 ?address2}.
}
Sample Data (Live Query Results)
Dump all Opportunities
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX cal: <http://www.w3.org/2002/12/cal/ical#>
PREFIX sioc: <http://rdfs.org/sioc/ns#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?st a ecrm:Opportunity.
?st a cal:Vevent.
OPTIONAL{?st ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?st ecrm:FREETEXT_ID ?FREETEXT_ID}.
OPTIONAL{?st ecrm:opportunityName ?opportunityName}.
OPTIONAL{?st sioc:User ?user}.
OPTIONAL{?st ecrm:manager ?manager}.
OPTIONAL{?st ecrm:company ?company}.
OPTIONAL{?st ecrm:has_company ?has_company}.
OPTIONAL{?st ecrm:has_contact ?has_contact}.
OPTIONAL{?st ecrm:contactName ?contactName}.
OPTIONAL{?st ecrm:forecast ?forecast}.
OPTIONAL{?st ecrm:estimateClose ?estimateClose}.
OPTIONAL{?st cal:dtstart ?dtstart}.
OPTIONAL{?st ecrm:startDate ?startDate}.
OPTIONAL{?st ecrm:status ?status}.
OPTIONAL{?st ecrm:code ?code}.
OPTIONAL{?st ecrm:stageTitle ?stageTitle}.
OPTIONAL{?st ecrm:sourceTitle ?sourceTitle}.
OPTIONAL{?st ecrm:closedAmount ?closedAmount}.
OPTIONAL{?st cal:dtend ?dtend}.
OPTIONAL{?st ecrm:closedDate ?closedDate}.
OPTIONAL{?st ecrm:propability ?propability}.
OPTIONAL{?st ecrm:potential ?potential}.
}
Sample Data (Live Query Results)
Dump of all Cases
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX cal: <http://www.w3.org/2002/12/cal/ical#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cs a ecrm:Case .
?cs a cal:Vevent.
OPTIONAL{?cs ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cs ecrm:summary ?summary}.
OPTIONAL{?cs ecrm:status ?status}.
OPTIONAL{?cs ecrm:priority ?priority}.
OPTIONAL{?cs cal:dtstart ?dtstart}.
OPTIONAL{?cs ecrm:openDate ?openDate}.
OPTIONAL{?cs cal:dtclose ?dtclose}.
OPTIONAL{?cs ecrm:lastActionDate ?lastActionDate}.
OPTIONAL{?cs ecrm:daysOld ?daysOld}.
OPTIONAL{?cs ecrm:has_company ?has_company}.
OPTIONAL{?cs ecrm:company ?company}.
OPTIONAL{?cs ecrm:has_contact ?has_contact}.
OPTIONAL{?cs ecrm:contactName ?contactName}.
OPTIONAL{?cs cal:url ?url}.
OPTIONAL{?cs ecrm:application ?application}.
OPTIONAL{?cs ecrm:appVer ?appVer}.
OPTIONAL{?cs ecrm:phoneNumber ?phoneNumber}.
OPTIONAL{?cs ecrm:relationship ?relationship}.
OPTIONAL{?cs ecrm:email ?email}.
OPTIONAL{?cs ecrm:client ?client}.
OPTIONAL{?cs ecrm:clientVersion ?clientVersion}.
OPTIONAL{?cs ecrm:office ?office}.
OPTIONAL{?cs ecrm:consultant ?consultant}.
OPTIONAL{?cs ecrm:dbVer ?dbVer}.
OPTIONAL{?cs ecrm:misTsID ?misTsID}.
OPTIONAL{?cs ecrm:oplClient ?oplClient}.
OPTIONAL{?cs ecrm:oplVer ?oplVer}.
OPTIONAL{?cs ecrm:server ?server}.
OPTIONAL{?cs ecrm:serverVersion ?serverVersion}.
OPTIONAL{?cs ecrm:downloadDate ?downloadDate}.
OPTIONAL{?cs ecrm:jobTitle ?jobTitle}.
}
Sample Data (Live Query Results)
Dump of all Activities
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX cal: <http://www.w3.org/2002/12/cal/ical#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?ac a ecrm:Activity .
?ac a cal:Vevent.
OPTIONAL{?cs ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cs ecrm:owner ?owner}.
}
Sample Data (Live Query Results)
Dump of all Mail Messages
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cmp a ecrm:MailMessage .
OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cmp ecrm:owner ?owner}.
}
Sample Data (Live Query Results)
Dump of all Documents
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?doc a ecrm:Document.
?doc a foaf:Document.
OPTIONAL{?doc ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?doc ecrm:owner ?owner}.
OPTIONAL{?doc ecrm:item ?item}.
OPTIONAL{?doc ecrm:reference ?reference}.
}
Sample Data (Live Query Results)
Dump of all Influencers
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?inf a ecrm:Influencer .
?inf a foaf:Person.
OPTIONAL{?inf ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?inf ecrm:has_opportunity ?has_opportunity}.
OPTIONAL{?inf ecrm:has_company ?has_company}.
OPTIONAL{?inf ecrm:contactName ?contactName}.
OPTIONAL{?inf foaf:title ?title}.
OPTIONAL{?inf ecrm:IROLE ?IROLE}.
OPTIONAL{?inf ecrm:responseMode ?responseMode}.
}
Sample Data (Live Query Results)
Dump of all Teams
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?tm a ecrm:Team.
OPTIONAL{?tm ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?tm ecrm:has_opportunity ?has_opportunity}.
OPTIONAL{?tm ecrm:has_contact ?has_contact}.
OPTIONAL{?tm ecrm:title ?title }.
OPTIONAL{?tm ecrm:department ?department}.
OPTIONAL{?tm ecrm:TROLE ?TROLE}.
}
Sample Data (Live Query Results)
Dump of all Competitors
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cmp a ecrm:Competitor .
?cmp a foaf:Organization.
OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cmp ecrm:has_opportunity ?has_opportunity}.
OPTIONAL{?cmp ecrm:has_company ?has_company}.
OPTIONAL{?cmp ecrm:has_product ?has_product }.
OPTIONAL{?cmp foaf:name ?name}.
OPTIONAL{?cmp ecrm:productName ?productName}.
OPTIONAL{?cmp ecrm:Strengths ?Strengths}.
OPTIONAL{?cmp ecrm:Weakness ?Weakness}.
OPTIONAL{?cmp ecrm:Rating ?Rating}.
OPTIONAL{?cmp ecrm:Status ?Status}.
}
Sample Data (Live Query Results)
Dump of all Issues
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cmp a ecrm:Issue.
OPTIONAL{?cmp ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cmp ecrm:has_opportunity ?has_opportunity}.
OPTIONAL{?cmp ecrm:subject ?subject}.
OPTIONAL{?cmp ecrm:reference ?reference }.
OPTIONAL{?cmp ecrm:priority ?priority}.
OPTIONAL{?cmp ecrm:issueDate ?issueDate}.
OPTIONAL{?cmp ecrm:status ?status}.
OPTIONAL{?cmp ecrm:userName ?userName}.
OPTIONAL{?cmp ecrm:docTitle ?docTitle}.
}
Sample Data (Live Query Results)
Dump of Orders with details for customers, company name, country, etc.
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?ord a ecrm:Order.
OPTIONAL{?ord ecrm:has_ecrm_organization ?org }.
OPTIONAL{?ord ecrm:has_company ?has_company}.
OPTIONAL{?ord ecrm:companyName ?company }.
OPTIONAL{?ord ecrm:contactName ?contact}.
OPTIONAL{?ord ecrm:year ?year}.
OPTIONAL{?ord ecrm:month ?month}.
OPTIONAL{?ord ecrm:quarter ?quarter}.
OPTIONAL{?ord ecrm:financialYear ?financialYear}.
}
Sample Data (Live Query Results)
Dump all Countries containing in their name "Aus".
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?name ?code
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cnt a ecrm:Country .
?cnt a geo:SpatialThing .
?cnt ecrm:countryName ?name .
?cnt ecrm:isoCode ?code .
FILTER REGEX(str(?name), "^Aus") .
}
Sample Data (Live Query Results)
Dump all Provinces starting with "B"
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
SELECT ?name
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cnt a ecrm:Province .
?cnt a geo:SpatialThing .
?cnt ecrm:provinceName ?name .
FILTER REGEX(str(?name), "^B") .
}
Sample Data (Live Query Results)
All Orders made by customer "General Motors"
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT COUNT(*)
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?ord a ecrm:Order.
?ord ecrm:companyName ?scompany FILTER (?scompany like '%Motor%') .
}
Sample Data (Live Query Results)
All Contacts associated with "New Way"
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT COUNT(*)
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?ord a ecrm:Employment.
?ord ecrm:has_contact ?scontact .
?ord ecrm:has_company ?scompany FILTER (?scompany like '%New%') .
}
Sample Data (Live Query Results)
Count of Orders from Russia
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT COUNT(*)
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?ord a ecrm:Order.
?ord ecrm:shipCountry ?scountry FILTER (?scountry like '%Russia%') .
}
Sample Data (Live Query Results)
All Leads containing "Lead from" in their subject
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?st a ecrm:Lead .
?st ecrm:subject ?subject FILTER (?subject like '%Lead from%') .
}
Sample Data (Live Query Results)
All Lost Opportunities
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX cal: <http://www.w3.org/2002/12/cal/ical#>
PREFIX sioc: <http://rdfs.org/sioc/ns#>
SELECT COUNT(*)
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?st a ecrm:Opportunity.
?st ecrm:status ?status FILTER (?status like '%Lost%') .
}
Sample Data (Live Query Results)
All Cases after 2006
PREFIX cal: <http://www.w3.org/2002/12/cal/ical#>
PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE
{
?cs a ecrm:Case .
?cs a cal:Vevent.
OPTIONAL{?cs ecrm:has_ecrm_organization ?has_ecrm_organization}.
OPTIONAL{?cs ecrm:owner ?owner}.
OPTIONAL{?cs ecrm:summary ?summary}.
OPTIONAL{?cs ecrm:status ?status}.
OPTIONAL{?cs ecrm:priority ?priority}.
OPTIONAL{?cs cal:dtstart ?dtstart}.
FILTER (xsd:dateTime (?dtstart) > xsd:dateTime ("2001-01-01T00:00:00Z")).
}
Sample Data (Live Query Results)
References