Virtuoso Open-Source Edition: ODS.ODSeCRMGoodRelationsRef

ODS eCRM GoodRelations SPARQL Reference

The following collection offers GoodRelations SPARQL queries:

Companies With Support Cases That Have Not Placed At Least One Order

In other words get all Evaluators with Closed Support cases who haven't become Customers.

PREFIX  ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX  gr: <http://purl.org/goodrelations/v1#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT ?name ?case
FROM <http://demo.openlinksw.com/ecrm>
WHERE
  {
    ?comp a gr:BusinessEntity .
    ?comp foaf:name ?name .
    ?comp ecrm:is_company_of ?case .
    ?case a ecrm:Case.
    OPTIONAL{?comp ecrm:has_order ?order .
                         ?order a ecrm:Order }.
    FILTER (!bound (?order)).
  }

• View Query Results (via SPARQL Protocol URL)
• View Query Results (via iSPARQL Results URL)
• View Query Editor (via iSPARQL Visual Query Editor URL)

Evaluators Who's Company Has Not Placed At Least One Order

In other words get all Evaluators that haven't become customers.

PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX gr: <http://purl.org/goodrelations/v1#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT ?name
FROM <http://demo.openlinksw.com/ecrm>
WHERE
  {
    ?comp a gr:BusinessEntity .
    ?comp foaf:name ?name .
    OPTIONAL {?comp ecrm:has_order ?order .
                          ?order a ecrm:Order }.
    FILTER (!bound (?order)).
  }

• View Query Results (via SPARQL Protocol URL)
• View Query Results (via iSPARQL Results URL)
• View Query Editor (via iSPARQL Visual Query Editor URL)

Orders By Geo Location

PREFIX ecrm: <http://demo.openlinksw.com/schemas/ecrm#>
PREFIX gr: <http://purl.org/goodrelations/v1#>
SELECT *
FROM <http://demo.openlinksw.com/ecrm>
WHERE 
  {
    ?order a gr:Offering .
    ?order ecrm:shipCountry ?country .
    FILTER (?country LIKE '%Russia%').
  }

• View Query Results (via SPARQL Protocol URL)
• View Query Results (via iSPARQL Results URL)
• View Query Editor (via iSPARQL Visual Query Editor URL)

References

• eCRM SPARQL SIOC Reference
• Virtuoso GoodRelations SPARQL Reference Collection
• GoodRelations Ontology
• eCRM Linked Data Views