eCRM SPARQL Reference

Key eCRM Data Space to eCRM schema Mappings

KeyeCRMSample Value
ClassProductecrm:Order
PropertyproductNameecrm:productName
PropertyunitPriceecrm:unitPrice
Attributehas_categoryecrm:has_category
Attributehas_supplierecrm: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