eCRM RDF Views script
To reload the transient eCRM RDF Views, run the following script:
use DB;
SPARQL drop silent quad map virtrdf:ecrmDemo1
;
SPARQL drop silent quad map virtrdf:ecrmDemo2
;
SPARQL drop silent quad map virtrdf:ecrmDemo3
;
create procedure DB.DBA.exec_no_error(in expr varchar)
{
declare state, message, meta, result any;
exec(expr, state, message, vector(), 0, meta, result);
}
;
GRANT SELECT ON eCRM.DBA.SFA_SALES_QUOTA TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_COMPANIES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_CONTACTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_EMPLOYMENTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_LEADS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_OPPORTUNITIES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_DOCUMENTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_INFLUENCERS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_TEAMS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_NOTES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_COMPETITORS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_ISSUES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_CUSTOM_FIELD_DEFS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_CUSTOM_FIELDS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_CASES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_ORDERS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_ORDER_ITEMS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_CATEGORIES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_PRODUCTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_PRODUCT_ATTRIBUTES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_CATALOGS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_CATALOG_PRODUCTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_MODULES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_REGISTRY TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_ORGANIZATIONS_DATA TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_MESSAGES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_COUNTRIES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_PROVINCES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_TIMEZONES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_MIME_TYPES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_MIME_EXTENSIONS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_CNAMES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_QUOTAS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_ROLES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_ACCOUNTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_USERDATA TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_GROUPDATA TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_MEMBERS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_SESSIONS_DATA TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_SESSION_DATA TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_LIST_MEMBERS_DEFS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_CLASSES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_ORG_CLASSES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_CLASS_METHODS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_CLASS_VIEWS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_ROLE_PRIVILEGES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_USER_PRIVILEGES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_HISTORY TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_USERS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_SALES_QUOTA TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_COMPANIES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_CONTACTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_EMPLOYMENTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_LEADS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_OPPORTUNITIES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_ACTIVITIES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_MAIL_MESSAGES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_DOCUMENTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_INFLUENCERS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_TEAMS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_NOTES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_COMPETITORS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_ISSUES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_CUSTOM_FIELD_DEFS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_CUSTOM_FIELDS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_CASES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_ORDERS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.SFA_ORDER_ITEMS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_CATEGORIES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_PRODUCTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_PRODUCT_ATTRIBUTES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_CATALOGS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.PM_CATALOG_PRODUCTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_COUNTRIES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.XSYS_PROVINCES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.AP_PROCESSES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.AP_PROCESSES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.AP_OBJECTS TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.AP_RULES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.AP_RULES TO "SPARQL"
;
GRANT SELECT ON eCRM.DBA.AP_QUEUE TO "SPARQL"
;
create function DB.DBA.ECRM_CONTACT_NAME (in fname varchar, in lname varchar)
{
declare tmp varchar;
tmp := 'Noname';
if (fname is not null)
tmp := fname;
if (lname is not null)
tmp := trim(concat(tmp, ' ', lname));
return tmp;
}
;
grant execute on DB.DBA.ECRM_CONTACT_NAME to SPARQL_SELECT
;
create function DB.DBA.ECRM_CONTACT_NAME_INV_1 (in name varchar)
{
declare parts any;
if (isstring(name))
{
parts := sprintf_inverse(name, '%s %s', 0);
if (parts is not null)
return parts[0];
}
return NULL;
}
;
grant execute on DB.DBA.ECRM_CONTACT_NAME_INV_1 to SPARQL_SELECT
;
create function DB.DBA.ECRM_CONTACT_NAME_INV_2 (in name varchar)
{
declare parts any;
if (isstring(name))
{
parts := sprintf_inverse(name, '%s %s', 0);
if (parts is not null)
return parts[1];
}
return NULL;
}
;
grant execute on DB.DBA.ECRM_CONTACT_NAME_INV_2 to SPARQL_SELECT
;
create function DB.DBA.ECRM_DBPEDIA_URI (in name varchar)
{
if (name is not NULL)
return sprintf('http://dbpedia.org/resource/%U', name);
return NULL;
}
;
grant execute on DB.DBA.ECRM_DBPEDIA_URI to SPARQL_SELECT
;
create function DB.DBA.ECRM_DBPEDIA_URI_INVERSE (in name varchar)
{
declare parts any;
if (isstring(name))
{
parts := sprintf_inverse(name, 'http://dbpedia.org/resource/%U', 0);
if (parts is not null)
return parts[0];
}
return NULL;
}
;
grant execute on DB.DBA.ECRM_DBPEDIA_URI_INVERSE to SPARQL_SELECT
;
create function DB.DBA.ECRM_TEL_URI (in name varchar)
{
if (name is not NULL)
return sprintf('tel:%s', name);
return NULL;
}
;
grant execute on DB.DBA.ECRM_TEL_URI to SPARQL_SELECT
;
create function DB.DBA.ECRM_TEL_URI_INVERSE (in name varchar)
{
declare parts any;
if (isstring(name))
{
parts := sprintf_inverse(name, 'tel:%s', 0);
if (parts is not null)
return parts[0];
}
return NULL;
}
;
grant execute on DB.DBA.ECRM_TEL_URI_INVERSE to SPARQL_SELECT
;
create function DB.DBA.ECRM_CALLTO_URI (in name varchar)
{
if (name is not NULL)
return sprintf('callto:%s', name);
return NULL;
}
;
grant execute on DB.DBA.ECRM_CALLTO_URI to SPARQL_SELECT
;
create function DB.DBA.ECRM_CALLTO_URI_INVERSE (in name varchar)
{
declare parts any;
if (isstring(name))
{
parts := sprintf_inverse(name, 'callto:%s', 0);
if (parts is not null)
return parts[0];
}
return NULL;
}
;
grant execute on DB.DBA.ECRM_CALLTO_URI_INVERSE to SPARQL_SELECT
;
create function DB.DBA.ECRM_MBOX_URI (in name varchar)
{
if (name is not NULL)
return sprintf('mailto:%s', name);
return NULL;
}
;
grant execute on DB.DBA.ECRM_MBOX_URI to SPARQL_SELECT
;
create function DB.DBA.ECRM_MBOX_URI_INVERSE (in name varchar)
{
declare parts any;
if (isstring(name))
{
parts := sprintf_inverse(name, 'mailto:%s', 0);
if (parts is not null)
return parts[0];
}
return NULL;
}
;
grant execute on DB.DBA.ECRM_MBOX_URI_INVERSE to SPARQL_SELECT
;
create function DB.DBA.ECRM_USER_URI (in name varchar)
{
if (name is not NULL)
return sprintf('http://%s/dataspace/%U', registry_get ('URIQADefaultHost'), name);
return NULL;
}
;
grant execute on DB.DBA.ECRM_USER_URI to SPARQL_SELECT
;
create function DB.DBA.ECRM_USER_URI_INVERSE (in name varchar)
{
declare parts any;
if (isstring(name))
{
parts := sprintf_inverse(name, sprintf('http://%s/dataspace/%%U', registry_get ('URIQADefaultHost')), 0);
if (parts is not null)
return parts[0];
}
return NULL;
}
;
grant execute on DB.DBA.ECRM_USER_URI_INVERSE to SPARQL_SELECT
;
create function DB.DBA.ECRM_ORDER_ID_LIT (in id integer)
{
return cast(id as varchar);
}
;
grant execute on DB.DBA.ECRM_ORDER_ID_LIT to SPARQL_SELECT
;
create function DB.DBA.ECRM_ORDER_ID_LIT_INVERSE (in id_lit varchar)
{
if (id_lit is not null)
{
return atoi(id_lit);
}
return NULL;
}
;
grant execute on DB.DBA.ECRM_ORDER_ID_LIT_INVERSE to SPARQL_SELECT
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:SalesQuota "http://^{URIQADefaultHost}^/ecrm/SalesQuota/%d/%d#this" (in ORG_ID integer, in SALES_QUOTA_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Company "http://^{URIQADefaultHost}^/ecrm/Company/%U/%U/%d#this" (in COMPANY_NAME varchar, in COMPANY_ID number, in ORG_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Contact "http://^{URIQADefaultHost}^/ecrm/Contact/%U/%d#this" (in CONTACT_ID number, in ORG_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Employment "http://^{URIQADefaultHost}^/ecrm/Employment/%U/%U/%U/%d#this" (in DEPARTMENT varchar, in COMPANY_ID varchar, in CONTACT_ID number, in ORG_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Lead "http://^{URIQADefaultHost}^/ecrm/Lead/%U/%d/%U#this" (in SNAME varchar, in ORG_ID integer, in LEAD_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:CustomFieldDef "http://^{URIQADefaultHost}^/ecrm/CustomFieldDef/%d/%d#this" (in ORG_ID integer, in EMPLOYMENT_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:CustomField "http://^{URIQADefaultHost}^/ecrm/CustomField/%d/%U/%d#this" (in ORG_ID integer, in EMPLOYMENT_ID number, in ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Opportunity "http://^{URIQADefaultHost}^/ecrm/Opportunity/%d/%U#this" (in ORG_ID integer, in OPPORTUNITY_ID number) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Case "http://^{URIQADefaultHost}^/ecrm/Case/%d/%U#this" (in ORG_ID integer, in CASE_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Note "http://^{URIQADefaultHost}^/ecrm/Note/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Activity "http://^{URIQADefaultHost}^/ecrm/Activity/%d/%U/%U#this" (in ORG_ID integer, in ACT_ID varchar, in OBJ_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:MailMessage "http://^{URIQADefaultHost}^/ecrm/MailMessage/%d/%U/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar, in EMPLOYMENT_ID2 varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Document "http://^{URIQADefaultHost}^/ecrm/Document/%d/%U/%U" (in ORG_ID integer, in EMPLOYMENT_ID varchar, in EMPLOYMENT_ID2 varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Influencer "http://^{URIQADefaultHost}^/ecrm/Influencer/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Team "http://^{URIQADefaultHost}^/ecrm/Team/%d/%U/%U#this" (in ORG_ID integer, in OPPORTUNITY_ID number, in CONTACT_ID number) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Competitor "http://^{URIQADefaultHost}^/ecrm/Competitor/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Issue "http://^{URIQADefaultHost}^/ecrm/Issue/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Order "http://^{URIQADefaultHost}^/ecrm/Order/%d/%U#this" (in ORG_ID integer, in ORDER_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:OrderItem "http://^{URIQADefaultHost}^/ecrm/OrderItem/%d/%U#this" (in ORG_ID integer, in ORDER_ITEM_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Category "http://^{URIQADefaultHost}^/ecrm/Category/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:ProductAttributeDef "http://^{URIQADefaultHost}^/ecrm/ProductAttributeDef/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Product "http://^{URIQADefaultHost}^/ecrm/Product/%d/%U#this" (in ORG_ID integer, in PRODUCT_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:ProductAttribute "http://^{URIQADefaultHost}^/ecrm/ProductAttribute/%d/%U/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar, in ORG_ID2 varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Catalog "http://^{URIQADefaultHost}^/ecrm/Catalog/%d/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:CatalogProduct "http://^{URIQADefaultHost}^/ecrm/CatalogProduct/%d/%U/%U#this" (in ORG_ID integer, in EMPLOYMENT_ID varchar, in EMPLOYMENT_ID2 varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Module "http://^{URIQADefaultHost}^/ecrm/Module/%d#this" (in ORG_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Registry "http://^{URIQADefaultHost}^/ecrm/Registry/%U#this" (in ORG_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:OrganizationsData "http://^{URIQADefaultHost}^/ecrm/OrganizationsData/%d/%U#this" (in ORG_ID integer, in DNS_ZONE varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Message "http://^{URIQADefaultHost}^/ecrm/Message/%d/%U#this" (in ORG_ID integer, in MSG_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Country "http://^{URIQADefaultHost}^/ecrm/Country/%U#this" (in COUNTRY_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:CompanyAddress "http://^{URIQADefaultHost}^/ecrm/CompanyAddress/%U/%d#this" (in COMPANY_ID number, in ORG_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:ContactAddress "http://^{URIQADefaultHost}^/ecrm/ContactAddress/%U/%d#this" (in COMPANY_ID number, in ORG_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:LeadAddress "http://^{URIQADefaultHost}^/ecrm/LeadAddress/%U/%d#this" (in COMPANY_ID varchar, in ORG_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:OrderAddress "http://^{URIQADefaultHost}^/ecrm/OrderAddress/%U/%d#this" (in COMPANY_ID varchar, in ORG_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Province "http://^{URIQADefaultHost}^/ecrm/Province/%U/%U#this" (in COUNTRY_ID varchar, in PROV_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Timezone "http://^{URIQADefaultHost}^/ecrm/Timezone/%U#this" (in COUNTRY_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:MimeType "http://^{URIQADefaultHost}^/ecrm/MimeType/%d#this" (in COUNTRY_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:MimeExtension "http://^{URIQADefaultHost}^/ecrm/MimeExtension/%d/%U#this" (in COUNTRY_ID integer, in COUNTRY_ID2 varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Cname "http://^{URIQADefaultHost}^/ecrm/Cname/%U#this" (in COUNTRY_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Quota "http://^{URIQADefaultHost}^/ecrm/Quota/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Role "http://^{URIQADefaultHost}^/ecrm/Role/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Account "http://^{URIQADefaultHost}^/ecrm/Account/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:UserData "http://^{URIQADefaultHost}^/ecrm/UserData/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:GroupData "http://^{URIQADefaultHost}^/ecrm/GroupData/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Member "http://^{URIQADefaultHost}^/ecrm/Member/%d/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer, in COUNTRY_ID3 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:SessionsData "http://^{URIQADefaultHost}^/ecrm/SessionsData/%U#this" (in COUNTRY_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:SessionData "http://^{URIQADefaultHost}^/ecrm/SessionData/%U/%d#this" (in COUNTRY_ID varchar, in COUNTRY_ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:ListMembersDef "http://^{URIQADefaultHost}^/ecrm/ListMembersDef/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:Class "http://^{URIQADefaultHost}^/ecrm/Class/%U#this" (in COUNTRY_ID varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:OrgClass "http://^{URIQADefaultHost}^/ecrm/OrgClass/%d/%U#this" (in COUNTRY_ID integer, in COUNTRY_ID2 varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:ClassMethod "http://^{URIQADefaultHost}^/ecrm/ClassMethod/%U/%U#this" (in COUNTRY_ID varchar, in COUNTRY_ID2 varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:ClassView "http://^{URIQADefaultHost}^/ecrm/ClassView/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:RolePrivelege "http://^{URIQADefaultHost}^/ecrm/RolePrivelege/%d/%d/%U/%U#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer, in COUNTRY_ID3 varchar, in COUNTRY_ID4 varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:UserPrivelege "http://^{URIQADefaultHost}^/ecrm/UserPrivelege/%d/%d/%U/%U#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer, in COUNTRY_ID3 varchar, in COUNTRY_ID4 varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:History "http://^{URIQADefaultHost}^/ecrm/History/%d/%d#this" (in COUNTRY_ID integer, in COUNTRY_ID2 integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:XSys_User "http://^{URIQADefaultHost}^/ecrm/XSys_User/%d/%U/%d#this" (in ORG_ID integer, in ACCOUNT_NAME varchar, in ACCOUNT_ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:AP_Process "http://^{URIQADefaultHost}^/ecrm/AP_Process/%d/%U#this" (in ORG_ID integer, in AP_ID number) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:AP_Rule "http://^{URIQADefaultHost}^/ecrm/AP_Rule/%d/%U/%d#this" (in ORG_ID integer, in AP_ID number, in RSEQ integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:AP_Queue "http://^{URIQADefaultHost}^/ecrm/AP_Queue/%d#this" (in ID integer) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:SalesRep "http://^{URIQADefaultHost}^/ecrm/SalesRep/%d/%U#this" (in ORG_ID integer, in SALESREP varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:isDefinedBy "http://www.openlinksw.com/ontology/ecrm#" () option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create literal class ecrm:OrderLabel "%d" (in ORDER_NO varchar) option (BIJECTION)
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:vendor_iri using
function DB.DBA.ECRM_VENDOR_URI (in name varchar) returns varchar ,
function DB.DBA.ECRM_VENDOR_URI_INVERSE (in name varchar) returns varchar
option(BIJECTION) .
;
create function DB.DBA.ECRM_VENDOR_URI (in name varchar)
{
if (name is not NULL)
return sprintf('http://data.openlinksw.com/oplweb/vendor/%U', name);
return NULL;
}
;
grant execute on DB.DBA.ECRM_VENDOR_URI to SPARQL_SELECT
;
create function DB.DBA.ECRM_VENDOR_URI_INVERSE (in name varchar)
{
declare parts any;
if (isstring(name))
{
parts := sprintf_inverse(name, 'http://data.openlinksw.com/oplweb/vendor/%U', 0);
if (parts is not null)
return parts[0];
}
return NULL;
}
;
grant execute on DB.DBA.ECRM_VENDOR_URI_INVERSE to SPARQL_SELECT
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:sioc_user_iri using
function DB.DBA.ECRM_USER_URI (in name varchar) returns varchar ,
function DB.DBA.ECRM_USER_URI_INVERSE (in name varchar) returns varchar
option(BIJECTION) .
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:mbox_iri using
function DB.DBA.ECRM_MBOX_URI (in name varchar) returns varchar ,
function DB.DBA.ECRM_MBOX_URI_INVERSE (in name varchar) returns varchar
option(BIJECTION) .
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:tel_iri using
function DB.DBA.ECRM_TEL_URI (in name varchar) returns varchar ,
function DB.DBA.ECRM_TEL_URI_INVERSE (in name varchar) returns varchar
option(BIJECTION) .
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:callto_iri using
function DB.DBA.ECRM_CALLTO_URI (in name varchar) returns varchar ,
function DB.DBA.ECRM_CALLTO_URI_INVERSE (in name varchar) returns varchar
option(BIJECTION) .
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create iri class ecrm:dbpedia_iri using
function DB.DBA.ECRM_DBPEDIA_URI (in name varchar) returns varchar ,
function DB.DBA.ECRM_DBPEDIA_URI_INVERSE (in name varchar) returns varchar
option(BIJECTION) .
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create literal class ecrm:contact_name_literal using
function DB.DBA.ECRM_CONTACT_NAME (in fname varchar, in lname varchar) returns varchar ,
function DB.DBA.ECRM_CONTACT_NAME_INV_1 (in name varchar) returns varchar ,
function DB.DBA.ECRM_CONTACT_NAME_INV_2 (in name varchar) returns varchar
option(BIJECTION) .
;
SPARQL prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
create literal class ecrm:order_lit using
function DB.DBA.ECRM_ORDER_ID_LIT (in id integer) returns varchar ,
function DB.DBA.ECRM_ORDER_ID_LIT_INVERSE (in id_iri varchar) returns integer
option (BIJECTION) .
;
SPARQL
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
prefix sioc: <http://rdfs.org/sioc/ns#>
prefix OpenLink: <http://www.openlinksw.com/schemas/oplweb#>
prefix gr: <http://purl.org/goodrelations/v1#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix vcard: <http://www.w3.org/2001/vcard-rdf/3.0#>
prefix cal: <http://www.w3.org/2002/12/cal/ical#>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix product: <http://www.swop-project.eu/ontologies/pmo/product.owl#>
prefix owl: <http://www.w3.org/2002/07/owl#>
prefix relationship: <http://purl.org/vocab/relationship/>
alter quad storage virtrdf:DefaultQuadStorage
from eCRM.DBA.SFA_SALES_QUOTA as sales_quotas
from eCRM.DBA.SFA_COMPANIES as companies text literal companies.DESCRIPTION
from eCRM.DBA.SFA_CONTACTS as contacts text literal contacts.NAME_FIRST
from eCRM.DBA.SFA_EMPLOYMENTS as employments
from eCRM.DBA.SFA_LEADS as leads text literal leads.SUBJECT
from eCRM.DBA.SFA_OPPORTUNITIES as opportunities text literal opportunities.OPPORTUNITY_NAME
from eCRM.DBA.SFA_ACTIVITIES as activities
from eCRM.DBA.SFA_MAIL_MESSAGES as messages
from eCRM.DBA.SFA_DOCUMENTS as documents
from eCRM.DBA.SFA_INFLUENCERS as influencers
from eCRM.DBA.SFA_TEAMS as teams
from eCRM.DBA.SFA_NOTES as notes text literal notes.DESCRIPTION
from eCRM.DBA.SFA_COMPETITORS as competitors
from eCRM.DBA.SFA_ISSUES as issues
from eCRM.DBA.SFA_CUSTOM_FIELD_DEFS as custom_field_defs
from eCRM.DBA.SFA_CUSTOM_FIELDS as custom_fields
from eCRM.DBA.SFA_CASES as cases text literal cases.SUMMARY
from eCRM.DBA.SFA_ORDERS as orders text literal orders.EMAIL
from eCRM.DBA.SFA_ORDER_ITEMS as order_items
from eCRM.DBA.PM_CATEGORIES as categories
from eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS as product_attribute_defs
from eCRM.DBA.PM_PRODUCTS as products text literal products.DESCRIPTION
from eCRM.DBA.PM_PRODUCT_ATTRIBUTES as product_attributes
from eCRM.DBA.PM_CATALOGS as catalogs
from eCRM.DBA.PM_CATALOG_PRODUCTS as catalog_products
from eCRM.DBA.XSYS_MODULES as modules
from eCRM.DBA.XSYS_REGISTRY as registries
from eCRM.DBA.XSYS_ORGANIZATIONS_DATA as organizations_data
from eCRM.DBA.XSYS_MESSAGES as xsysmessages
from eCRM.DBA.XSYS_COUNTRIES as countries
from eCRM.DBA.XSYS_PROVINCES as provinces
from eCRM.DBA.XSYS_TIMEZONES as timezones
from eCRM.DBA.XSYS_MIME_TYPES as mimetypes
from eCRM.DBA.XSYS_MIME_EXTENSIONS as mimeexts
from eCRM.DBA.XSYS_CNAMES as cnames
from eCRM.DBA.XSYS_QUOTAS as quotas
from eCRM.DBA.XSYS_ROLES as roles
from eCRM.DBA.XSYS_ACCOUNTS as accounts
from eCRM.DBA.XSYS_USERDATA as userdatas
from eCRM.DBA.XSYS_GROUPDATA as groupdatas
from eCRM.DBA.XSYS_MEMBERS as members
from eCRM.DBA.XSYS_SESSIONS_DATA as sessionsdatas
from eCRM.DBA.XSYS_SESSION_DATA as sessiondatas
from eCRM.DBA.XSYS_LIST_MEMBERS_DEFS as list_members_defs
from eCRM.DBA.XSYS_CLASSES as classes
from eCRM.DBA.XSYS_ORG_CLASSES as org_classes
from eCRM.DBA.XSYS_CLASS_METHODS as class_methods
from eCRM.DBA.XSYS_CLASS_VIEWS as class_views
from eCRM.DBA.XSYS_ROLE_PRIVILEGES as role_priveleges
from eCRM.DBA.XSYS_USER_PRIVILEGES as user_priveleges
from eCRM.DBA.XSYS_HISTORY as history
from eCRM.DBA.XSYS_USERS as xsys_users
from eCRM.DBA.AP_PROCESSES as ap_processes
from eCRM.DBA.AP_RULES as ap_rules
from eCRM.DBA.AP_QUEUE as ap_queues
where (^{companies.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{contacts.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{leads.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{products.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{orders.}^.SHIP_COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
{
create virtrdf:ecrmDemo1 as graph iri ("http://^{URIQADefaultHost}^/ecrm") option (order 1501)
{
ecrm:CompanyAddress (companies.COMPANY_ID, companies.ORG_ID)
a vcard:work;
rdfs:label 'Address' ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
vcard:Country companies.COUNTRY_NAME;
vcard:Region companies.PROVINCE;
vcard:Locality companies.CITY;
vcard:Pcode companies.POSTAL_CODE;
vcard:Street companies.ADDRESS1;
vcard:Extadd companies.ADDRESS2 .
ecrm:ContactAddress (contacts.CONTACT_ID, contacts.ORG_ID)
a vcard:Address;
rdfs:label 'Address' ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
vcard:Country contacts.COUNTRY_NAME;
vcard:Region contacts.PROVINCE;
vcard:Locality contacts.CITY;
vcard:Pcode contacts.POSTAL_CODE;
vcard:Street contacts.ADDRESS1;
vcard:Extadd contacts.ADDRESS2 .
ecrm:LeadAddress (leads.LEAD_ID, leads.ORG_ID)
a vcard:Address;
rdfs:label 'Address' ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
vcard:Country leads.COUNTRY_NAME;
vcard:Region leads.PROVINCE;
vcard:Locality leads.CITY;
vcard:Pcode leads.POSTAL_CODE;
vcard:Street leads.ADDRESS1;
vcard:Extadd leads.ADDRESS2 .
ecrm:OrderAddress (orders.ORDER_ID, orders.ORG_ID)
a vcard:Address;
rdfs:label 'Ship Address' ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
vcard:Country orders.SHIP_COUNTRY_NAME;
vcard:Region orders.SHIP_PROVINCE;
vcard:Locality orders.SHIP_CITY;
vcard:Pcode orders.SHIP_POSTAL_CODE;
vcard:Street orders.SHIP_ADDRESS1;
vcard:Extadd orders.SHIP_ADDRESS2 .
ecrm:Country (countries.COUNTRY_NAME)
a ecrm:Country
as virtrdf:Country-Countrys2 ;
a geo:SpatialThing
as virtrdf:Country-Countrys ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label countries.COUNTRY_NAME ;
geo:lat countries.LAT ;
geo:long countries.LNG ;
owl:sameAs ecrm:dbpedia_iri (countries.COUNTRY_NAME) ;
ecrm:countryID countries.COUNTRY_ID
as virtrdf:Country-COUNTRY_ID ;
ecrm:countryID3 countries.COUNTRY_ID3
as virtrdf:Country-COUNTRY_ID3 ;
ecrm:isoCode countries.ISO_CODE
as virtrdf:Country-ISO_CODE ;
ecrm:countryName countries.COUNTRY_NAME
as virtrdf:Country-COUNTRY_NAME .
ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
ecrm:is_province_of ecrm:Country (countries.COUNTRY_NAME)
where (^{countries.}^.COUNTRY_ID = ^{provinces.}^.COUNTRY_ID)
as virtrdf:ecrmProvince-is_province_of .
ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
a ecrm:Province
as virtrdf:ecrmProvince-Provinces2 ;
a geo:SpatialThing
as virtrdf:ecrmProvince-Provinces ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
owl:sameAs ecrm:dbpedia_iri (provinces.PROVINCE_NAME) ;
geo:lat provinces.LAT ;
geo:long provinces.LNG ;
rdfs:label provinces.PROVINCE_NAME ;
ecrm:provinceID provinces.PROVINCE_ID
as virtrdf:Province-PROVINCE_ID ;
ecrm:provinceName provinces.PROVINCE_NAME
as virtrdf:ecrmProvince-PROVINCE_NAME .
ecrm:Country (countries.COUNTRY_NAME)
ecrm:has_province ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
where (^{provinces.}^.COUNTRY_ID = ^{countries.}^.COUNTRY_ID)
as virtrdf:ecrmCountry-has_province .
ecrm:SalesQuota (sales_quotas.ORG_ID, sales_quotas.QUOTA_ID)
a ecrm:SalesQuota
as virtrdf:SalesQuota-SalesQuotas ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{sales_quotas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:SalesQuota-ORG_ID ;
ecrm:has_user ecrm:UserData(members.ORG_ID, sales_quotas.USER_ID)
as virtrdf:SalesQuota-USER_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{sales_quotas.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{sales_quotas.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:SalesQuota-OWNER_ID ;
ecrm:fromDate sales_quotas.FROM_DATE
as virtrdf:SalesQuota-FROM_DATE ;
ecrm:toDate sales_quotas.TO_DATE
as virtrdf:SalesQuota-TO_DATE ;
ecrm:quotaValue sales_quotas.QUOTA_VALUE
as virtrdf:SalesQuota-QUOTA_VALUE ;
ecrm:objectives sales_quotas.OBJECTIVES
as virtrdf:SalesQuota-OBJECTIVES .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:SalesQuota (sales_quotas.ORG_ID, sales_quotas.QUOTA_ID)
where (^{sales_quotas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:SalesQuota-is_ecrm_org_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:SalesQuota (sales_quotas.ORG_ID, sales_quotas.QUOTA_ID)
where (^{sales_quotas.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{sales_quotas.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:SalesQuota-account_manager .
ecrm:Company (companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
a ecrm:Company
as virtrdf:Company-Companys2 ;
a gr:BusinessEntity
as virtrdf:grBusinessEntity-Companys ;
a foaf:Organization
as virtrdf:Company-Companys ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label companies.COMPANY_NAME ;
rdfs:comment companies.DESCRIPTION ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{companies.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Company-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{companies.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{companies.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Company-OWNER_ID ;
ecrm:FREETEXT_ID companies.FREETEXT_ID
as virtrdf:Company-FREETEXT_ID ;
foaf:name companies.COMPANY_NAME
as virtrdf:foafCompany-COMPANY_NAME ;
gr:legalName companies.COMPANY_NAME
as virtrdf:foafCompany-COMPANY_NAME2 ;
ecrm:industry companies.INDUSTRY_NAME
as virtrdf:Company-INDUSTRY_NAME ;
foaf:homepage companies.URL
as virtrdf:foafCompany-URL ;
foaf:phone ecrm:tel_iri(companies.PHONE_NUMBER)
as virtrdf:foafCompany-PHONE_NUMBER ;
ecrm:phoneExtension companies.PHONE_EXTENSION
as virtrdf:Company-PHONE_EXTENSION ;
ecrm:faxNumber ecrm:tel_iri(companies.FAX_NUMBER)
as virtrdf:Company-FAX_NUMBER ;
ecrm:faxExtension companies.FAX_EXTENSION
as virtrdf:Company-FAX_EXTENSION ;
ecrm:mobileNumber ecrm:tel_iri(companies.MOBILE_NUMBER)
as virtrdf:Company-MOBILE_NUMBER ;
foaf:mbox ecrm:mbox_iri(companies.EMAIL)
as virtrdf:foafCompany-EMAIL ;
ecrm:email_text companies.EMAIL
as virtrdf:Companies-EMAIL-TEXT ;
ecrm:country ecrm:Country(companies.COUNTRY_NAME)
as virtrdf:Company-COUNTRY ;
ecrm:province ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
where (^{companies.}^.PROVINCE = ^{provinces.}^.PROVINCE_NAME)
as virtrdf:Company-PROVINCE ;
ecrm:city ecrm:dbpedia_iri (companies.CITY)
as virtrdf:Company-dbpedia_CITY ;
ecrm:postalCode companies.POSTAL_CODE
as virtrdf:Company-POSTAL_CODE ;
ecrm:address1 companies.ADDRESS1
as virtrdf:Company-ADDRESS1 ;
ecrm:address2 companies.ADDRESS2
as virtrdf:Company-ADDRESS2 ;
vcard:ADR ecrm:CompanyAddress (companies.COMPANY_ID, companies.ORG_ID)
as virtrdf:Company-ADR ;
ecrm:description companies.DESCRIPTION
as virtrdf:Company-DESCRIPTION .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Company (companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{companies.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Company-is_ecrm_org_of .
ecrm:Country (companies.COUNTRY_NAME)
ecrm:is_country_of
ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
as virtrdf:Company-is_country_of .
ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
ecrm:is_province_of
ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{companies.}^.PROVINCE = ^{provinces.}^.PROVINCE_NAME)
as virtrdf:Company-is_province_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{companies.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{companies.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Company-account_manager .
ecrm:CustomFieldDef (custom_field_defs.ORG_ID, custom_field_defs.FIELD_ID)
a ecrm:CustomFieldDefs
as virtrdf:CustomFieldDef-CustomFieldDefs ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label custom_field_defs.FIELD_NAME;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{custom_field_defs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:CustomFieldDef-ORG_ID ;
ecrm:has_class ecrm:Class(custom_field_defs.CLASS_ID)
as virtrdf:CustomFieldDef-CLASS_ID ;
ecrm:fieldName custom_field_defs.FIELD_NAME
as virtrdf:CustomFieldDef-FIELD_NAME ;
ecrm:fieldType custom_field_defs.FIELD_TYPE
as virtrdf:CustomFieldDef-FIELD_TYPE .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:CustomFieldDef (custom_field_defs.ORG_ID, custom_field_defs.FIELD_ID)
where (^{custom_field_defs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:CustomFieldDef-is_ecrm_org_of .
ecrm:Class(custom_field_defs.CLASS_ID)
ecrm:is_class_of
ecrm:CustomFieldDef (custom_field_defs.ORG_ID, custom_field_defs.FIELD_ID)
as virtrdf:CustomFieldDef-is_class_of .
ecrm:CustomField (custom_fields.ORG_ID, custom_fields.OBJ_ID, custom_fields.FIELD_ID)
a ecrm:CustomField
as virtrdf:CustomField-CustomFields ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{custom_fields.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:CustomField-ORG_ID ;
ecrm:OBJ_ID custom_fields.OBJ_ID
as virtrdf:CustomField-OBJ_ID ;
ecrm:has_field ecrm:CustomFieldDef(custom_fields.ORG_ID, custom_fields.FIELD_ID)
as virtrdf:CustomField-FIELD_ID ;
ecrm:fieldValue custom_fields.FIELD_VALUE
as virtrdf:CustomField-FIELD_VALUE .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:CustomField (custom_fields.ORG_ID, custom_fields.OBJ_ID, custom_fields.FIELD_ID)
where (^{custom_fields.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:CustomField-is_ecrm_org_of .
ecrm:CustomFieldDef(custom_fields.ORG_ID, custom_fields.FIELD_ID)
ecrm:is_custom_field_def_of
ecrm:CustomField (custom_fields.ORG_ID, custom_fields.OBJ_ID, custom_fields.FIELD_ID)
as virtrdf:CustomField-is_custom_field_def_of .
ecrm:Note (notes.ORG_ID, notes.NOTE_ID)
a ecrm:Note
as virtrdf:Note-Notes ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:comment notes.DESCRIPTION;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{notes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Note-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{notes.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{notes.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Note-OWNER_ID ;
ecrm:FREETEXT_ID notes.FREETEXT_ID
as virtrdf:Note-FREETEXT_ID ;
ecrm:OBJ_ID notes.OBJ_ID
as virtrdf:Note-OBJ_ID ;
ecrm:REL_ID notes.REL_ID
as virtrdf:Note-REL_ID ;
ecrm:DESCRIPTION notes.DESCRIPTION
as virtrdf:Note-DESCRIPTION .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Note (notes.ORG_ID, notes.NOTE_ID)
where (^{notes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Note-is_ecrm_org_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Note (notes.ORG_ID, notes.NOTE_ID)
where (^{notes.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{notes.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Note-account_manager .
ecrm:Employment (employments.DEPARTMENT, employments.COMPANY_ID, employments.CONTACT_ID, employments.ORG_ID)
a ecrm:Employment
as virtrdf:Employment-Employments ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{employments.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Employment-ORG_ID ;
rdfs:label employments.TITLE;
ecrm:has_company ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{employments.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{employments.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Employment-COMPANY_ID ;
ecrm:has_contact ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
where (^{employments.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{employments.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Employment-CONTACT_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{employments.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{employments.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Employment-OWNER_ID ;
ecrm:EMPLOYMENT_ID employments.EMPLOYMENT_ID
as virtrdf:Employment-EMPLOYMENT_ID ;
ecrm:department employments.DEPARTMENT
as virtrdf:Employment-Department ;
ecrm:title employments.TITLE
as virtrdf:Employment-TITLE ;
ecrm:phoneNumber ecrm:tel_iri(employments.PHONE_NUMBER)
as virtrdf:Employment-PHONE_NUMBER ;
ecrm:phoneExtension employments.PHONE_EXTENSION
as virtrdf:Employment-PHONE_EXTENSION ;
ecrm:faxNumber ecrm:tel_iri(employments.FAX_NUMBER)
as virtrdf:Employment-FAX_NUMBER ;
ecrm:faxExtension employments.FAX_EXTENSION
as virtrdf:Employment-FAX_EXTENSION ;
ecrm:mobileNumber ecrm:tel_iri(employments.MOBILE_NUMBER)
as virtrdf:Employment-MOBILE_NUMBER ;
ecrm:email_text employments.EMAIL
as virtrdf:Employments-EMAIL-TEXT ;
foaf:mbox ecrm:mbox_iri(employments.EMAIL)
as virtrdf:Employment-EMAIL .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Employment (employments.DEPARTMENT, employments.COMPANY_ID, employments.CONTACT_ID, employments.ORG_ID)
where (^{employments.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Employment-is_ecrm_org_of .
ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
ecrm:is_contact_of
ecrm:Employment (employments.DEPARTMENT, employments.COMPANY_ID, employments.CONTACT_ID, employments.ORG_ID)
where (^{employments.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{employments.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Employment-is_coontact_of .
ecrm:Company (companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
ecrm:is_company_of
ecrm:Employment (employments.DEPARTMENT, employments.COMPANY_ID, employments.CONTACT_ID, employments.ORG_ID)
where (^{employments.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{employments.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Employment-is_company_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Employment (employments.DEPARTMENT, employments.COMPANY_ID, employments.CONTACT_ID, employments.ORG_ID)
where (^{employments.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{employments.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Employment-account_manager .
ecrm:Contact (contacts.CONTACT_ID, contacts.ORG_ID)
a ecrm:Contact
as virtrdf:Contact-Contacts2 ;
a foaf:Person
as virtrdf:Contact-Contacts ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{contacts.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Contact-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{contacts.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{contacts.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Contact-OWNER_ID ;
rdfs:label ecrm:contact_name_literal(contacts.NAME_FIRST, contacts.NAME_LAST);
rdfs:comment contacts.DESCRIPTION ;
ecrm:FREETEXT_ID contacts.FREETEXT_ID
as virtrdf:Contact-FREETEXT_ID ;
foaf:title contacts.NAME_TITLE
as virtrdf:foafContact-NAME_TITLE ;
foaf:firstName contacts.NAME_FIRST
as virtrdf:foafContact-NAME_FIRST ;
foaf:givenname contacts.NAME_MIDDLE
as virtrdf:foafContact-NAME_MIDDLE ;
foaf:surname contacts.NAME_LAST
as virtrdf:foafContact-NAME_LAST ;
foaf:birthday contacts.BIRTH_DATE
as virtrdf:foafContact-BIRTH_DATE ;
ecrm:contactType contacts.CONTACT_TYPE_TITLE
as virtrdf:Contact-CONTACT_TYPE_TITLE ;
ecrm:manager ecrm:sioc_user_iri(contacts.MANAGER_NAME)
as virtrdf:Contact-MANAGER_NAME ;
sioc:User ecrm:sioc_user_iri(contacts.MANAGER_NAME)
as virtrdf:siocContact-MANAGER_NAME ;
ecrm:business contacts.BUSINESS
as virtrdf:Contact-BUSINESS ;
foaf:interest contacts.INTEREST
as virtrdf:foafContact-INTEREST ;
ecrm:open contacts."OPEN"
as virtrdf:Contact-OPEN ;
ecrm:sourceTitle contacts.SOURCE_TITLE
as virtrdf:Contact-SOURCE_TITLE ;
foaf:phone ecrm:tel_iri(contacts.PHONE_NUMBER)
as virtrdf:foafContact-PHONE_NUMBER ;
ecrm:phoneExtension contacts.PHONE_EXTENSION
as virtrdf:Contact-PHONE_EXTENSION ;
ecrm:phone2Number ecrm:tel_iri(contacts.PHONE2_NUMBER)
as virtrdf:Contact-PHONE2_NUMBER ;
ecrm:phone2Extension contacts.PHONE2_EXTENSION
as virtrdf:Contact-PHONE2_EXTENSION ;
ecrm:faxNumber ecrm:tel_iri(contacts.FAX_NUMBER)
as virtrdf:Contact-FAX_NUMBER ;
ecrm:faxExtension contacts.FAX_EXTENSION
as virtrdf:Contact-FAX_EXTENSION ;
ecrm:mobileNumber ecrm:tel_iri(contacts.MOBILE_NUMBER)
as virtrdf:Contact-MOBILE_NUMBER ;
foaf:mbox ecrm:mbox_iri(contacts.EMAIL)
as virtrdf:foafContact-EMAIL ;
ecrm:email_text contacts.EMAIL
as virtrdf:Contact-EMAIL ;
ecrm:country ecrm:Country(contacts.COUNTRY_NAME)
as virtrdf:Contact-COUNTRY_NAME ;
ecrm:province ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
where (^{contacts.}^.PROVINCE = ^{provinces.}^.PROVINCE_NAME)
as virtrdf:Contact-PROVINCE ;
ecrm:city ecrm:dbpedia_iri (contacts.CITY)
as virtrdf:Contact-dbpedia_CITY ;
ecrm:postalCode contacts.POSTAL_CODE
as virtrdf:Contact-POSTAL_CODE ;
ecrm:address1 contacts.ADDRESS1
as virtrdf:Contact-ADDRESS1 ;
ecrm:address2 contacts.ADDRESS2
as virtrdf:Contact-ADDRESS2 ;
vcard:ADR ecrm:ContactAddress (contacts.CONTACT_ID, contacts.ORG_ID)
as virtrdf:Contact-ADR ;
ecrm:description contacts.DESCRIPTION
as virtrdf:Contact-DESCRIPTION .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Contact (contacts.CONTACT_ID, contacts.ORG_ID)
where (^{contacts.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Contact-is_ecrm_org_of .
ecrm:Country (contacts.COUNTRY_NAME)
ecrm:is_country_of
ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
as virtrdf:Contacts-is_country_of .
ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
ecrm:is_province_of
ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
where (^{contacts.}^.PROVINCE = ^{provinces.}^.PROVINCE_NAME)
as virtrdf:Contact-is_province_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
where (^{contacts.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{contacts.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Contact-account_manager .
ecrm:Lead (leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID)
a ecrm:Lead
as virtrdf:Lead-Leads2 ;
a foaf:Person
as virtrdf:Lead-Leads ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
vcard:ADR ecrm:LeadAddress (leads.LEAD_ID, leads.ORG_ID)
as virtrdf:Lead-ADR ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{leads.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Lead-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{leads.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{leads.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Lead-OWNER_ID ;
rdfs:label leads.SUBJECT;
ecrm:FREETEXT_ID leads.FREETEXT_ID
as virtrdf:Lead-FREETEXT_ID ;
ecrm:subject leads.SUBJECT
as virtrdf:Lead-SUBJECT ;
foaf:title leads.NAME_TITLE
as virtrdf:foafLead-NAME_TITLE ;
foaf:firstName leads.NAME_FIRST
as virtrdf:foafLead-NAME_FIRST ;
foaf:givenname leads.NAME_MIDDLE
as virtrdf:Lead-NAME_MIDDLE ;
foaf:surname leads.NAME_LAST
as virtrdf:foafLead-NAME_LAST ;
ecrm:company leads.COMPANY_NAME
as virtrdf:Lead-COMPANY_NAME ;
ecrm:has_company ecrm:Company(leads.COMPANY_NAME, leads.COMPANY_ID, leads.ORG_ID)
as virtrdf:Lead-COMPANY_ID ;
ecrm:REL_ID leads.REL_ID
as virtrdf:Lead-REL_ID ;
ecrm:leadTitle leads.TITLE
as virtrdf:Lead-TITLE ;
ecrm:status leads.STATUS
as virtrdf:Lead-STATUS ;
ecrm:rating leads.RATING
as virtrdf:Lead-RATING ;
foaf:phone ecrm:tel_iri(leads.PHONE_NUMBER)
as virtrdf:foafLead-PHONE_NUMBER ;
ecrm:phoneExtension leads.PHONE_EXTENSION
as virtrdf:Lead-PHONE_EXTENSION ;
ecrm:mobileNumber ecrm:tel_iri(leads.MOBILE_NUMBER)
as virtrdf:Lead-MOBILE_NUMBER ;
ecrm:faxNumber ecrm:tel_iri(leads.FAX_NUMBER)
as virtrdf:Lead-FAX_NUMBER ;
ecrm:faxExtension leads.FAX_EXTENSION
as virtrdf:Lead-FAX_EXTENSION ;
foaf:mbox ecrm:mbox_iri(leads.EMAIL)
as virtrdf:foafLead-EMAIL ;
ecrm:email_text leads.EMAIL
as virtrdf:Leads-EMAIL ;
ecrm:country ecrm:Country(leads.COUNTRY_NAME)
as virtrdf:Lead-COUNTRY_NAME ;
ecrm:province ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
where (^{leads.}^.PROVINCE = ^{provinces.}^.PROVINCE_NAME)
as virtrdf:Lead-PROVINCE ;
ecrm:city ecrm:dbpedia_iri (leads.CITY)
as virtrdf:Lead-dbpedia_CITY ;
ecrm:postalCode leads.POSTAL_CODE
as virtrdf:Lead-POSTAL_CODE ;
ecrm:address1 leads.ADDRESS1
as virtrdf:Lead-ADDRESS1 ;
ecrm:address2 leads.ADDRESS2
as virtrdf:Lead-ADDRESS2 .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Lead (leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID)
where (^{leads.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Lead-is_ecrm_org_of .
ecrm:Company (companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
ecrm:is_company_of
ecrm:Lead (leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID)
where (^{leads.}^.COMPANY_NAME = ^{companies.}^.COMPANY_NAME and ^{leads.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Lead-is_company_of .
ecrm:Country (leads.COUNTRY_NAME)
ecrm:is_country_of
ecrm:Lead(leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID)
as virtrdf:Lead-is_country_of .
ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
ecrm:is_province_of
ecrm:Lead(leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID)
where (^{leads.}^.PROVINCE = ^{provinces.}^.PROVINCE_NAME)
as virtrdf:Lead-is_province_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Lead(leads.SUBJECT, leads.ORG_ID, leads.LEAD_ID)
where (^{leads.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{leads.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Lead-account_manager .
ecrm:Opportunity (opportunities.ORG_ID, opportunities.OPPORTUNITY_ID)
a ecrm:Opportunity
as virtrdf:Opportunity-Opportunitys2 ;
a cal:Vevent
as virtrdf:Opportunity-Opportunitys ;
rdfs:label opportunities.OPPORTUNITY_NAME;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{opportunities.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Opportunity-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{opportunities.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{opportunities.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Opportunity-OWNER_ID ;
ecrm:FREETEXT_ID opportunities.FREETEXT_ID
as virtrdf:Opportunity-FREETEXT_ID ;
ecrm:opportunityName opportunities.OPPORTUNITY_NAME
as virtrdf:Opportunity-OPPORTUNITY_NAME ;
sioc:User ecrm:sioc_user_iri(opportunities.MANAGER_NAME)
as virtrdf:siocOpportunity-MANAGER_NAME ;
ecrm:manager ecrm:sioc_user_iri(opportunities.MANAGER_NAME)
as virtrdf:Opportunity-MANAGER_NAME ;
ecrm:has_company ecrm:Company(opportunities.COMPANY_NAME, opportunities.COMPANY_ID, opportunities.ORG_ID)
as virtrdf:Opportunity-COMPANY_ID ;
ecrm:company opportunities.COMPANY_NAME
as virtrdf:Opportunity-COMPANY_NAME ;
ecrm:has_contact ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
where (^{opportunities.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{opportunities.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Opportunity-CONTACT_ID ;
ecrm:contactName opportunities.CONTACT_NAME
as virtrdf:Opportunity-CONTACT_NAME ;
ecrm:companyRelID opportunities.COMPANY_REL_ID
as virtrdf:Opportunity-COMPANY_REL_ID ;
ecrm:contactRelID opportunities.CONTACT_REL_ID
as virtrdf:Opportunity-CONTACT_REL_ID ;
ecrm:forecast opportunities.FORECAST
as virtrdf:Opportunity-FORECAST ;
ecrm:estimateClose opportunities.ESTIMATE_CLOSE
as virtrdf:Opportunity-ESTIMATE_CLOSE ;
cal:dtstart opportunities.START_DATE
as virtrdf:calOpportunity-START_DATE ;
ecrm:startDate opportunities.START_DATE
as virtrdf:Opportunity-START_DATE ;
ecrm:status opportunities.STATUS
as virtrdf:Opportunity-STATUS ;
ecrm:code opportunities.CODE
as virtrdf:Opportunity-CODE ;
ecrm:stageTitle opportunities.STAGE_TITLE
as virtrdf:Opportunity-STAGE_TITLE ;
ecrm:sourceTitle opportunities.SOURCE_TITLE
as virtrdf:Opportunity-SOURCE_TITLE ;
ecrm:closedAmount opportunities.CLOSED_AMOUNT
as virtrdf:Opportunity-CLOSED_AMOUNT ;
cal:dtend opportunities.CLOSED_DATE
as virtrdf:calOpportunity-CLOSED_DATE ;
ecrm:closedDate opportunities.CLOSED_DATE
as virtrdf:Opportunity-CLOSED_DATE ;
ecrm:propability opportunities.PROBABILITY
as virtrdf:Opportunity-PROBABILITY ;
ecrm:potential opportunities.POTENTIAL
as virtrdf:Opportunity-POTENTIAL .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Opportunity (opportunities.ORG_ID, opportunities.OPPORTUNITY_ID)
where (^{opportunities.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Opportunity-is_ecrm_org_of .
ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
ecrm:is_contact_of
ecrm:Opportunity (opportunities.ORG_ID, opportunities.OPPORTUNITY_ID)
where (^{opportunities.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{opportunities.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Opportunity-is_contact_of .
ecrm:Company (opportunities.COMPANY_NAME, opportunities.COMPANY_ID, opportunities.ORG_ID)
ecrm:is_company_of
ecrm:Opportunity (opportunities.ORG_ID, opportunities.OPPORTUNITY_ID)
as virtrdf:Opportunity-is_company_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Opportunity (opportunities.ORG_ID, opportunities.OPPORTUNITY_ID)
where (^{opportunities.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{opportunities.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Opportunity-account_manager .
ecrm:Case (cases.ORG_ID, cases.CASE_ID)
a ecrm:Case
as virtrdf:Case-Cases2 ;
a cal:Vevent
as virtrdf:Case-Cases ;
rdfs:label cases.SUMMARY;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{cases.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Case-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{cases.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{cases.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Case-OWNER_ID ;
ecrm:FREETEXT_ID cases.FREETEXT_ID
as virtrdf:Case-FREETEXT_ID ;
ecrm:summary cases.SUMMARY
as virtrdf:Case-SUMMARY ;
ecrm:status cases.STATUS
as virtrdf:Case-STATUS ;
cal:priority cases.PRIORITY
as virtrdf:calCase-PRIORITY ;
ecrm:priority cases.PRIORITY
as virtrdf:Case-PRIORITY ;
cal:dtstart cases.OPEN_DATE
as virtrdf:calCase-OPEN_DATE ;
ecrm:openDate cases.OPEN_DATE
as virtrdf:Case-OPEN_DATE ;
cal:dtclose cases.LAST_ACTION_DATE
as virtrdf:calCase-LAST_ACTION_DATE ;
ecrm:lastActionDate cases.LAST_ACTION_DATE
as virtrdf:Case-LAST_ACTION_DATE ;
ecrm:daysOld cases.DAYS_OLD
as virtrdf:Case-DAYS_OLD ;
ecrm:has_company ecrm:Company(cases.COMPANY_NAME, cases.COMPANY_ID, cases.ORG_ID)
as virtrdf:Case-COMPANY_ID ;
ecrm:company cases.COMPANY_NAME
as virtrdf:Case-COMPANY_NAME ;
ecrm:has_contact ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
where (^{cases.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{cases.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Case-CONTACT_ID ;
ecrm:contactName cases.CONTACT_NAME
as virtrdf:Case-CONTACT_NAME ;
cal:url cases.URI
as virtrdf:calCase-URI ;
ecrm:uri cases.URI
as virtrdf:Case-URI ;
ecrm:application cases.APPLICATION
as virtrdf:Case-APPLICATION ;
ecrm:appVer cases.APPVER
as virtrdf:Case-APPVER ;
ecrm:phoneNumber ecrm:tel_iri(cases.PHONE_NUMBER)
as virtrdf:Case-PHONE_NUMBER ;
ecrm:relationship cases.RELATIONSHIP
as virtrdf:Case-RELATIONSHIP ;
ecrm:email ecrm:mbox_iri(cases.EMAIL)
as virtrdf:Case-EMAIL-FOAF ;
ecrm:email_text cases.EMAIL
as virtrdf:Case-EMAIL ;
ecrm:client ecrm:vendor_iri(cases.CLIENT)
as virtrdf:Case-CLIENT ;
ecrm:clientVersion cases.CLIENT_VERSION
as virtrdf:Case-CLIENT_VERSION ;
ecrm:office cases.OFFICE
as virtrdf:Case-OFFICE ;
ecrm:consultant cases.CONSULTANT
as virtrdf:Case-CONSULTANT ;
OpenLink:DbmsFamilyVendor ecrm:vendor_iri(cases.DB_VENDOR)
as virtrdf:Case-DB_VENDOR ;
ecrm:dbVer cases.DB_VER
as virtrdf:Case-DB_VER ;
ecrm:misTsID cases.MIS_TS_ID
as virtrdf:Case-MIS_TS_ID ;
ecrm:oplClient cases.OPL_CLIENT
as virtrdf:Case-OPL_CLIENT ;
ecrm:oplVer cases.OPL_VER
as virtrdf:Case-OPL_VER ;
ecrm:server ecrm:vendor_iri(cases.SERVER)
as virtrdf:Case-SERVER ;
ecrm:serverVersion cases.SERVER_VERSION
as virtrdf:Case-SERVER_VERSION ;
ecrm:downloadDate cases.DOWNLOAD_DATE
as virtrdf:Case-DOWNLOAD_DATE ;
ecrm:jobTitle cases.JOB_TITLE
as virtrdf:Case-JOB_TITLE ;
ecrm:source cases.SOURCE
as virtrdf:Case-SOURCE ;
ecrm:year cases.YEAR
as virtrdf:Case-YEAR ;
ecrm:month cases.MONTH
as virtrdf:Case-MONTH ;
ecrm:quarter cases.QUARTER
as virtrdf:Case-QUARTER ;
ecrm:whenOrder cases.WHEN_ORDER
as virtrdf:Case-WHEN_ORDER ;
ecrm:internalStatus cases.INTERNAL_STATUS
as virtrdf:Case-INTERNAL_STATUS ;
ecrm:financialYear cases.FINANCIAL_YEAR
as virtrdf:Case-FINANCIAL_YEAR ;
ecrm:contactRelID cases.CONTACT_REL_ID
as virtrdf:Case-CONTACT_REL_ID ;
ecrm:companyRelID cases.COMPANY_REL_ID
as virtrdf:Case-COMPANY_REL_ID .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Case (cases.ORG_ID, cases.CASE_ID)
where (^{cases.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Case-is_ecrm_org_of .
ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
ecrm:is_contact_of
ecrm:Case (cases.ORG_ID, cases.CASE_ID)
where (^{cases.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{cases.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Case-is_contact_of .
ecrm:Company (cases.COMPANY_NAME, cases.COMPANY_ID, cases.ORG_ID)
ecrm:is_company_of
ecrm:Case (cases.ORG_ID, cases.CASE_ID)
as virtrdf:Case-is_company_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Case (cases.ORG_ID, cases.CASE_ID)
where (^{cases.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{cases.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Case-account_manager .
ecrm:Activity (activities.ORG_ID, activities.ACT_ID, activities.OBJ_ID)
a ecrm:Activity
as virtrdf:Activity-Activitys2 ;
a cal:Vevent
as virtrdf:Activity-Activitys ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{activities.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Activity-ORG_ID ;
ecrm:ACTIVITY_ID activities.ACTIVITY_ID
as virtrdf:Activity-ACTIVITY_ID ;
ecrm:ACT_ID activities.ACT_ID
as virtrdf:Activity-ACT_ID ;
ecrm:OBJ_ID activities.OBJ_ID
as virtrdf:Activity-OBJ_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{activities.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{activities.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Activity-OWNER_ID .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Activity (activities.ORG_ID, activities.ACT_ID, activities.OBJ_ID)
where (^{activities.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Activity-is_ecrm_org_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Activity (activities.ORG_ID, activities.ACT_ID, activities.OBJ_ID)
where (^{activities.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{activities.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Activity-account_manager .
ecrm:MailMessage (messages.ORG_ID, messages.MAIL_MSG_ID, messages.OBJ_ID)
a ecrm:MailMessage
as virtrdf:MailMessage-MailMessages ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{messages.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:MailMessage-ORG_ID ;
ecrm:MAIL_MESSAGE_ID messages.MAIL_MESSAGE_ID
as virtrdf:MailMessage-MAIL_MESSAGE_ID ;
ecrm:MAIL_MSG_ID messages.MAIL_MSG_ID
as virtrdf:MailMessage-MAIL_MSG_ID ;
ecrm:OBJ_ID messages.OBJ_ID
as virtrdf:MailMessage-OBJ_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{messages.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{messages.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:MailMessage-OWNER_ID .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:MailMessage (messages.ORG_ID, messages.MAIL_MSG_ID, messages.OBJ_ID)
where (^{messages.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:MailMessage-is_ecrm_org_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:MailMessage (messages.ORG_ID, messages.MAIL_MSG_ID, messages.OBJ_ID)
where (^{messages.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{messages.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:MailMessage-account_manager .
ecrm:Document (documents.ORG_ID, documents.DOC_ID, documents.OBJ_ID)
a ecrm:Document
as virtrdf:Document-Documents2 ;
a foaf:Document
as virtrdf:Document-Documents ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{documents.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Document-ORG_ID ;
ecrm:documentId documents.DOCUMENT_ID
as virtrdf:Document-DOCUMENT_ID ;
ecrm:DOC_ID documents.DOC_ID
as virtrdf:Document-DOC_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{documents.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{documents.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Document-OWNER_ID ;
ecrm:OBJ_ID documents.OBJ_ID
as virtrdf:Document-OBJ_ID ;
ecrm:item documents.ITEM
as virtrdf:Document-ITEM ;
ecrm:reference documents.REFERENCE
as virtrdf:Document-REFERENCE .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Document (documents.ORG_ID, documents.DOC_ID, documents.OBJ_ID)
where (^{documents.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Document-is_ecrm_org_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Document (documents.ORG_ID, documents.DOC_ID, documents.OBJ_ID)
where (^{documents.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{documents.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Document-account_manager .
} .
} .
;
SPARQL
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
prefix sioc: <http://rdfs.org/sioc/ns#>
prefix OpenLink: <http://www.openlinksw.com/schemas/oplweb#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix cal: <http://www.w3.org/2002/12/cal/ical#>
prefix product: <http://www.swop-project.eu/ontologies/pmo/product.owl#>
prefix owl: <http://www.w3.org/2002/07/owl#>
prefix relationship: <http://vocab.org/relationship/#>
prefix gr: <http://purl.org/goodrelations/v1#>
alter quad storage virtrdf:DefaultQuadStorage
from eCRM.DBA.SFA_SALES_QUOTA as sales_quotas
from eCRM.DBA.SFA_COMPANIES as companies text literal companies.DESCRIPTION
from eCRM.DBA.SFA_CONTACTS as contacts text literal contacts.NAME_FIRST
from eCRM.DBA.SFA_EMPLOYMENTS as employments
from eCRM.DBA.SFA_LEADS as leads text literal leads.SUBJECT
from eCRM.DBA.SFA_OPPORTUNITIES as opportunities text literal opportunities.OPPORTUNITY_NAME
from eCRM.DBA.SFA_ACTIVITIES as activities
from eCRM.DBA.SFA_MAIL_MESSAGES as messages
from eCRM.DBA.SFA_DOCUMENTS as documents
from eCRM.DBA.SFA_INFLUENCERS as influencers
from eCRM.DBA.SFA_TEAMS as teams
from eCRM.DBA.SFA_NOTES as notes text literal notes.DESCRIPTION
from eCRM.DBA.SFA_COMPETITORS as competitors
from eCRM.DBA.SFA_ISSUES as issues
from eCRM.DBA.SFA_CUSTOM_FIELD_DEFS as custom_field_defs
from eCRM.DBA.SFA_CUSTOM_FIELDS as custom_fields
from eCRM.DBA.SFA_CASES as cases text literal cases.SUMMARY
from eCRM.DBA.SFA_ORDERS as orders text literal orders.EMAIL
from eCRM.DBA.SFA_ORDER_ITEMS as order_items
from eCRM.DBA.PM_CATEGORIES as categories
from eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS as product_attribute_defs
from eCRM.DBA.PM_PRODUCTS as products text literal products.DESCRIPTION
from eCRM.DBA.PM_PRODUCT_ATTRIBUTES as product_attributes
from eCRM.DBA.PM_CATALOGS as catalogs
from eCRM.DBA.PM_CATALOG_PRODUCTS as catalog_products
from eCRM.DBA.XSYS_MODULES as modules
from eCRM.DBA.XSYS_REGISTRY as registries
from eCRM.DBA.XSYS_ORGANIZATIONS_DATA as organizations_data
from eCRM.DBA.XSYS_MESSAGES as xsysmessages
from eCRM.DBA.XSYS_COUNTRIES as countries
from eCRM.DBA.XSYS_PROVINCES as provinces
from eCRM.DBA.XSYS_TIMEZONES as timezones
from eCRM.DBA.XSYS_MIME_TYPES as mimetypes
from eCRM.DBA.XSYS_MIME_EXTENSIONS as mimeexts
from eCRM.DBA.XSYS_CNAMES as cnames
from eCRM.DBA.XSYS_QUOTAS as quotas
from eCRM.DBA.XSYS_ROLES as roles
from eCRM.DBA.XSYS_ACCOUNTS as accounts
from eCRM.DBA.XSYS_USERDATA as userdatas
from eCRM.DBA.XSYS_GROUPDATA as groupdatas
from eCRM.DBA.XSYS_MEMBERS as members
from eCRM.DBA.XSYS_SESSIONS_DATA as sessionsdatas
from eCRM.DBA.XSYS_SESSION_DATA as sessiondatas
from eCRM.DBA.XSYS_LIST_MEMBERS_DEFS as list_members_defs
from eCRM.DBA.XSYS_CLASSES as classes
from eCRM.DBA.XSYS_ORG_CLASSES as org_classes
from eCRM.DBA.XSYS_CLASS_METHODS as class_methods
from eCRM.DBA.XSYS_CLASS_VIEWS as class_views
from eCRM.DBA.XSYS_ROLE_PRIVILEGES as role_priveleges
from eCRM.DBA.XSYS_USER_PRIVILEGES as user_priveleges
from eCRM.DBA.XSYS_HISTORY as history
from eCRM.DBA.XSYS_USERS as xsys_users
from eCRM.DBA.AP_PROCESSES as ap_processes
from eCRM.DBA.AP_RULES as ap_rules
from eCRM.DBA.AP_QUEUE as ap_queues
where (^{companies.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{contacts.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{leads.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{products.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{orders.}^.SHIP_COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
{
create virtrdf:ecrmDemo2 as graph iri ("http://^{URIQADefaultHost}^/ecrm") option (order 1502)
{
ecrm:Issue (issues.ORG_ID, issues.ISSUE_ID)
a ecrm:Issue
as virtrdf:Issue-Issues ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{issues.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Issue-ORG_ID ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label issues.SUBJECT;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{issues.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{issues.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Issue-OWNER_ID ;
ecrm:has_opportunity ecrm:Opportunity(issues.ORG_ID, issues.OPPORTUNITY_ID)
as virtrdf:Issue-OPPORTUNITY_ID ;
ecrm:REL_ID issues.REL_ID
as virtrdf:Issue-REL_ID ;
ecrm:subject issues.SUBJECT
as virtrdf:Issue-SUBJECT ;
ecrm:reference issues.REFERENCE
as virtrdf:Issue-REFERENCE ;
ecrm:priority issues.PRIORITY
as virtrdf:Issue-PRIORITY ;
ecrm:issueDate issues.ISSUE_DATE
as virtrdf:Issue-ISSUE_DATE ;
ecrm:status issues.STATUS
as virtrdf:Issue-STATUS ;
ecrm:userName issues.USER_NAME
as virtrdf:Issue-USER_NAME ;
ecrm:docTitle issues.DOC_TITLE
as virtrdf:Issue-DOC_TITLE .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Issue (issues.ORG_ID, issues.ISSUE_ID)
where (^{issues.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Issue-is_ecrm_org_of .
ecrm:Opportunity(issues.ORG_ID, issues.OPPORTUNITY_ID)
ecrm:is_opportunity_of
ecrm:Issue (issues.ORG_ID, issues.ISSUE_ID)
as virtrdf:Issue-is_opportunity_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Issue (issues.ORG_ID, issues.ISSUE_ID)
where (^{issues.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{issues.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Issue-account_manager .
ecrm:Order (orders.ORG_ID, orders.ORDER_ID)
a ecrm:Order
as virtrdf:Order-Orders ;
ecrm:order_id_stext ecrm:order_lit (orders.ORDER_ID)
as virtrdf:Orders-order_lit ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label ecrm:OrderLabel (orders.ORDER_NO) ;
vcard:ADR ecrm:OrderAddress (orders.ORDER_ID, orders.ORG_ID)
as virtrdf:Order-ADR ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{orders.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Order-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{orders.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{orders.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Order-OWNER_ID ;
ecrm:FREETEXT_ID orders.FREETEXT_ID
as virtrdf:Order-FREETEXT_ID ;
ecrm:has_company ecrm:Company(orders.COMPANY_NAME, orders.COMPANY_ID, orders.ORG_ID)
as virtrdf:Order-COMPANY_ID ;
#cannot guess manufacturer from schema
#gr:hasManufacturer ecrm:Company(orders.COMPANY_NAME, orders.COMPANY_ID, orders.ORG_ID)
# as virtrdf:Order-COMPANY_ID22 ;
ecrm:companyName orders.COMPANY_NAME
as virtrdf:Order-COMPANY_NAME ;
ecrm:has_contact ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
where (^{orders.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{orders.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Order-CONTACT_ID ;
ecrm:contactName orders.CONTACT_NAME
as virtrdf:Order-CONTACT_NAME ;
ecrm:orderNo orders.ORDER_NO
as virtrdf:Order-ORDER_NO ;
ecrm:shipFirstName orders.SHIP_FNAME
as virtrdf:Order-SHIP_FNAME ;
ecrm:shipSecondName orders.SHIP_SNAME
as virtrdf:Order-SHIP_SNAME ;
ecrm:phoneNumber ecrm:tel_iri(orders.PHONE_NUMBER)
as virtrdf:Order-PHONE_NUMBER ;
ecrm:phoneExtension orders.PHONE_EXTENSION
as virtrdf:Order-PHONE_EXTENSION ;
foaf:mbox ecrm:mbox_iri(orders.EMAIL)
as virtrdf:Order-EMAIL ;
ecrm:email_text orders.EMAIL
as virtrdf:Order-EMAIL-TEXT ;
ecrm:shipCountry ecrm:Country(orders.SHIP_COUNTRY_NAME)
as virtrdf:Order-SHIP_COUNTRY_NAME ;
ecrm:shipProvince ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
where (^{orders.}^.SHIP_PROVINCE = ^{provinces.}^.PROVINCE_NAME)
as virtrdf:Order-SHIP_PROVINCE ;
ecrm:shipCity ecrm:dbpedia_iri (orders.SHIP_CITY)
as virtrdf:Order-SHIP_dbpedia_CITY ;
ecrm:shipPostalCode orders.SHIP_POSTAL_CODE
as virtrdf:Order-SHIP_POSTAL_CODE ;
ecrm:shipAddress1 orders.SHIP_ADDRESS1
as virtrdf:Order-SHIP_ADDRESS1 ;
ecrm:shipAddress2 orders.SHIP_ADDRESS2
as virtrdf:Order-SHIP_ADDRESS2 ;
ecrm:salesRep ecrm:SalesRep(orders.ORG_ID, orders.SALESREP)
as virtrdf:Order-SALESREP ;
ecrm:orderDate orders.ORDER_DATE
as virtrdf:Order-ORDER_DATE ;
ecrm:orderValue orders.ORDER_VALUE
as virtrdf:Order-ORDER_VALUE ;
ecrm:refund orders.REFUND
as virtrdf:Order-REFUND ;
ecrm:year orders.YEAR
as virtrdf:Order-YEAR ;
ecrm:month orders.MONTH
as virtrdf:Order-MONTH ;
ecrm:quarter orders.QUARTER
as virtrdf:Order-QUARTER ;
ecrm:financialYear orders.FINANCIAL_YEAR
as virtrdf:Order-FINANCIAL_YEAR ;
ecrm:CONTACT_REL_ID orders.CONTACT_REL_ID
as virtrdf:Order-CONTACT_REL_ID ;
ecrm:COMPANY_REL_ID orders.COMPANY_REL_ID
as virtrdf:Order-COMPANY_REL_ID .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Order (orders.ORG_ID, orders.ORDER_ID)
where (^{orders.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Order-is_ecrm_org_of .
ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
ecrm:is_contact_of
ecrm:Order (orders.ORG_ID, orders.ORDER_ID)
where (^{orders.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{orders.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Order-is_contact_of .
ecrm:Company(orders.COMPANY_NAME, orders.COMPANY_ID, orders.ORG_ID)
ecrm:has_order
ecrm:Order (orders.ORG_ID, orders.ORDER_ID)
as virtrdf:Order-is_company_of .
ecrm:Country (orders.SHIP_COUNTRY_NAME)
ecrm:is_ship_country_of
ecrm:Order(orders.ORG_ID, orders.ORDER_ID)
as virtrdf:Order-is_country_of .
ecrm:Province (provinces.COUNTRY_ID, provinces.PROVINCE_NAME)
ecrm:is_shipprovince_of
ecrm:Order(orders.ORG_ID, orders.ORDER_ID)
where (^{orders.}^.SHIP_PROVINCE = ^{provinces.}^.PROVINCE_NAME)
as virtrdf:Order-is_province_of .
ecrm:SalesRep (orders.ORG_ID, orders.SALESREP)
a ecrm:SalesRep
as virtrdf:SalesRep-SalesRep ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:is_sales_rep_of
ecrm:Order(orders.ORG_ID, orders.ORDER_ID)
as virtrdf:SalesRep-is_of ;
foaf:name orders.SALESREP
as virtrdf:SalesRep-Name .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Order(orders.ORG_ID, orders.ORDER_ID)
where (^{orders.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{orders.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Order-account_manager .
ecrm:OrderItem (order_items.ORG_ID, order_items.ORDER_ITEM_ID)
a ecrm:OrderItem
as virtrdf:OrderItem-OrderItems ;
a gr:ProductOrServicesSomeInstancesPlaceholder
as virtrdf:OrderItem-ProductOrServicesSomeInstancesPlaceholder ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label order_items.PRODUCT_NAME;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{order_items.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:OrderItem-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{order_items.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{order_items.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:OrderItem-OWNER_ID ;
ecrm:has_order ecrm:Order(order_items.ORG_ID, order_items.ORDER_ID)
as virtrdf:OrderItem-ORDER_ID ;
ecrm:has_product ecrm:Product(order_items.ORG_ID, order_items.PRODUCT_ID)
as virtrdf:OrderItem-PRODUCT_ID ;
ecrm:productName order_items.PRODUCT_NAME
as virtrdf:OrderItem-PRODUCT_NAME ;
ecrm:client order_items.CLIENT
as virtrdf:OrderItem-CLIENT ;
ecrm:server ecrm:dbpedia_iri (order_items.SERVER)
as virtrdf:OrderItem-SERVER ;
ecrm:dbms ecrm:dbpedia_iri (order_items.DBMS)
as virtrdf:OrderItem-DBMS ;
ecrm:discount order_items.DISCOUNT
as virtrdf:OrderItem-DISCOUNT ;
ecrm:unitPrice order_items.UNIT_PRICE
as virtrdf:OrderItem-UNIT_PRICE ;
ecrm:qty order_items.QTY
as virtrdf:OrderItem-QTY .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:OrderItem (order_items.ORG_ID, order_items.ORDER_ITEM_ID)
where (^{order_items.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:OrderItem-is_ecrm_org_of .
ecrm:Order(order_items.ORG_ID, order_items.ORDER_ID)
ecrm:is_order_of
ecrm:OrderItem (order_items.ORG_ID, order_items.ORDER_ITEM_ID)
as virtrdf:OrderItem-is_order_of .
ecrm:Product(order_items.ORG_ID, order_items.PRODUCT_ID)
ecrm:is_product_of
ecrm:OrderItem (order_items.ORG_ID, order_items.ORDER_ITEM_ID)
as virtrdf:OrderItem-is_product_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:OrderItem (order_items.ORG_ID, order_items.ORDER_ITEM_ID)
where (^{order_items.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{order_items.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:OrderItem-account_manager .
ecrm:Category (categories.ORG_ID, categories.CATEGORY_ID)
a ecrm:Category
as virtrdf:Category-Categorys ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{categories.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Category-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{categories.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{categories.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Category-OWNER_ID ;
ecrm:FREETEXT_ID categories.FREETEXT_ID
as virtrdf:Category-FREETEXT_ID ;
rdfs:label categories.CATEGORY_NAME;
ecrm:categoryName categories.CATEGORY_NAME
as virtrdf:Category-CATEGORY_NAME ;
ecrm:description categories.DESCRIPTION
as virtrdf:Category-DESCRIPTION .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Category (categories.ORG_ID, categories.CATEGORY_ID)
where (^{categories.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Category-is_ecrm_org_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Category (categories.ORG_ID, categories.CATEGORY_ID)
where (^{categories.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{categories.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Category-account_manager .
ecrm:OrganizationsData (organizations_data.ORG_ID, organizations_data.DNS_ZONE)
a ecrm:OrganizationsData
as virtrdf:OrganizationsData-OrganizationsDatas2 ;
a foaf:Organization
as virtrdf:OrganizationsData-OrganizationsDatas ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label organizations_data.DNS_ZONE;
ecrm:dnsZone organizations_data.DNS_ZONE
as virtrdf:OrganizationsData-DNS_ZONE ;
ecrm:status organizations_data.STATUS
as virtrdf:OrganizationsData-STATUS ;
ecrm:data organizations_data.DATA
as virtrdf:OrganizationsData-DATA ;
ecrm:spaceTotal organizations_data.SPACE_TOTAL
as virtrdf:OrganizationsData-SPACE_TOTAL ;
ecrm:spaceUsed organizations_data.SPACE_USED
as virtrdf:OrganizationsData-SPACE_USED ;
ecrm:userLicenses organizations_data.USER_LICENSES
as virtrdf:OrganizationsData-USER_LICENSES .
ecrm:ProductAttributeDef (product_attribute_defs.ORG_ID, product_attribute_defs.ATTRIBUTE_ID)
a ecrm:ProductAttributeDef
as virtrdf:ProductAttributeDef-ProductAttributeDefs ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{product_attribute_defs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:ProductAttributeDef-ORG_ID ;
ecrm:has_category ecrm:Category(product_attribute_defs.ORG_ID, product_attribute_defs.CATEGORY_ID)
as virtrdf:ProductAttributeDef-CATEGORY_ID ;
ecrm:attributeName product_attribute_defs.ATTRIBUTE_NAME
as virtrdf:ProductAttributeDef-ATTRIBUTE_NAME ;
ecrm:attributeType product_attribute_defs.ATTRIBUTE_TYPE
as virtrdf:ProductAttributeDef-ATTRIBUTE_TYPE .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:ProductAttributeDef (product_attribute_defs.ORG_ID, product_attribute_defs.ATTRIBUTE_ID)
where (^{product_attribute_defs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:ProductAttributeDef-is_ecrm_org_of .
ecrm:Category(product_attribute_defs.ORG_ID, product_attribute_defs.CATEGORY_ID)
ecrm:is_ctegory_of
ecrm:ProductAttributeDef (product_attribute_defs.ORG_ID, product_attribute_defs.ATTRIBUTE_ID)
as virtrdf:ProductAttributeDef-is_category_of .
ecrm:Product (products.ORG_ID, products.PRODUCT_ID)
a ecrm:Product
as virtrdf:ecrmProduct-Products ;
a product:Product
as virtrdf:Product-Products ;
a gr:ProductOrService as virtrdf:grProductOrService-Products ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{products.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Product-ORG_ID ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label products.PRODUCT_NAME ;
rdfs:comment products.DESCRIPTION ;
gr:description products.DESCRIPTION ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{products.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{products.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Product-OWNER_ID ;
ecrm:FREETEXT_ID products.FREETEXT_ID
as virtrdf:Product-FREETEXT_ID ;
ecrm:productName products.PRODUCT_NAME
as virtrdf:Product-PRODUCT_NAME ;
ecrm:has_category ecrm:Category(products.ORG_ID, products.CATEGORY_ID)
as virtrdf:Product-CATEGORY_ID ;
ecrm:unitOfMeasure products.UNIT_OF_MEASURE
as virtrdf:Product-UNIT_OF_MEASURE ;
ecrm:units products.UNITS
as virtrdf:Product-UNITS ;
product:unit products.UNITS
as virtrdf:Product-productUNITS ;
ecrm:manufacturer products.MANUFACTURER
as virtrdf:Product-MANUFACTURER ;
gr:hasManufacturer ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{products.}^.MANUFACTURER = ^{companies.}^.COMPANY_NAME and ^{products.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:grhasManufacturer-MANUFACTURER ;
ecrm:has_manufacturer ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{products.}^.MANUFACTURER = ^{companies.}^.COMPANY_NAME and ^{products.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Product-MANUFACTURER2 ;
ecrm:validFrom products.VALID_FROM
as virtrdf:Product-VALID_FROM ;
ecrm:validUntil products.VALID_UNTIL
as virtrdf:Product-VALID_UNTIL ;
ecrm:country ecrm:Country(products.COUNTRY_NAME)
as virtrdf:Product-COUNTRY_NAME ;
ecrm:minorder products.MINORDER
as virtrdf:Product-MINORDER ;
ecrm:maxorder products.MAXORDER
as virtrdf:Product-MAXORDER ;
ecrm:productVendor products.PRODUCT_VENDOR
as virtrdf:Product-PRODUCT_VENDOR ;
ecrm:has_vendor ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{products.}^.PRODUCT_VENDOR = ^{companies.}^.COMPANY_NAME and ^{products.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Product-PRODUCT_VENDOR2 ;
ecrm:description products.DESCRIPTION
as virtrdf:Product-DESCRIPTION .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Product (products.ORG_ID, products.PRODUCT_ID)
where (^{products.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Product-is_ecrm_org_of .
ecrm:Country (products.COUNTRY_NAME)
ecrm:is_country_of
ecrm:Product(products.ORG_ID, products.PRODUCT_ID)
as virtrdf:Product-is_country_of .
ecrm:Category(products.ORG_ID, products.CATEGORY_ID)
ecrm:is_category_of
ecrm:Product(products.ORG_ID, products.PRODUCT_ID)
as virtrdf:Product-is_category_of .
ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
ecrm:is_manufacturer_of
ecrm:Product(products.ORG_ID, products.PRODUCT_ID)
where (^{products.}^.MANUFACTURER = ^{companies.}^.COMPANY_NAME and ^{products.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Product-is_manufacturer_of .
ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
ecrm:is_vendor_of
ecrm:Product(products.ORG_ID, products.PRODUCT_ID)
where (^{products.}^.PRODUCT_VENDOR = ^{companies.}^.COMPANY_NAME and ^{products.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Product-is_vendor_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Product(products.ORG_ID, products.PRODUCT_ID)
where (^{products.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{products.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Product-account_manager .
ecrm:ProductAttribute (product_attributes.ORG_ID, product_attributes.PRODUCT_ID, product_attributes.ATTRIBUTE_ID)
a ecrm:ProductAttribute
as virtrdf:ProductAttribute-ProductAttributes ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{product_attributes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:ProductAttribute-ORG_ID ;
ecrm:has_product ecrm:Product(product_attributes.ORG_ID, product_attributes.PRODUCT_ID)
as virtrdf:ProductAttribute-PRODUCT_ID ;
ecrm:has_attribute ecrm:ProductAttributeDef(product_attributes.ORG_ID, product_attributes.ATTRIBUTE_ID)
as virtrdf:ProductAttribute-ATTRIBUTE_ID ;
ecrm:attributeValue product_attributes.ATTRIBUTE_VALUE
as virtrdf:ProductAttribute-ATTRIBUTE_VALUE .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:ProductAttribute (product_attributes.ORG_ID, product_attributes.PRODUCT_ID, product_attributes.ATTRIBUTE_ID)
where (^{product_attributes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:ProductAttribute-is_ecrm_org_of .
ecrm:Product(product_attributes.ORG_ID, product_attributes.PRODUCT_ID)
ecrm:is_product_of
ecrm:ProductAttribute (product_attributes.ORG_ID, product_attributes.PRODUCT_ID, product_attributes.ATTRIBUTE_ID)
as virtrdf:ProductAttribute-is_product_of .
ecrm:Catalog (catalogs.ORG_ID, catalogs.CATALOG_ID)
a ecrm:Catalog
as virtrdf:Catalog-Catalogs ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{catalogs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Catalog-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{catalogs.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{catalogs.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Catalog-OWNER_ID ;
ecrm:FREETEXT_ID catalogs.FREETEXT_ID
as virtrdf:Catalog-FREETEXT_ID ;
rdfs:label catalogs.CATALOG_NAME;
rdfs:comment catalogs.DESCRIPTION;
ecrm:catalogName catalogs.CATALOG_NAME
as virtrdf:Catalog-CATALOG_NAME ;
ecrm:has_provider ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{catalogs.}^.CATALOG_PROVIDER = ^{companies.}^.COMPANY_NAME and ^{catalogs.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Catalogs-CATALOG_PROVIDER2 ;
ecrm:catalogProvider catalogs.CATALOG_PROVIDER
as virtrdf:Catalog-CATALOG_PROVIDER ;
ecrm:catalogAudience catalogs.CATALOG_AUDIENCE
as virtrdf:Catalog-CATALOG_AUDIENCE ;
ecrm:validFrom catalogs.VALID_FROM
as virtrdf:Catalog-VALID_FROM ;
ecrm:validUntil catalogs.VALID_UNTIL
as virtrdf:Catalog-VALID_UNTIL ;
ecrm:description catalogs.DESCRIPTION
as virtrdf:Catalog-DESCRIPTION .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Catalog (catalogs.ORG_ID, catalogs.CATALOG_ID)
where (^{catalogs.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Catalog-is_ecrm_org_of .
ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
ecrm:is_provider_of
ecrm:Catalog (catalogs.ORG_ID, catalogs.CATALOG_ID)
where (^{catalogs.}^.CATALOG_PROVIDER = ^{companies.}^.COMPANY_NAME and ^{catalogs.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Catalog-is_provider_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Catalog (catalogs.ORG_ID, catalogs.CATALOG_ID)
where (^{catalogs.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{catalogs.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Catalog-account_manager .
ecrm:CatalogProduct (catalog_products.ORG_ID, catalog_products.CATALOG_ID, catalog_products.PRODUCT_ID)
a ecrm:CatalogProduct
as virtrdf:CatalogProduct-CatalogProducts ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{catalog_products.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:CatalogProduct-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{catalog_products.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{catalog_products.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:CatalogProduct-OWNER_ID ;
ecrm:has_catalog ecrm:Catalog(catalog_products.ORG_ID, catalog_products.CATALOG_ID)
as virtrdf:CatalogProduct-CATALOG_ID ;
ecrm:has_product ecrm:Product(catalog_products.ORG_ID, catalog_products.PRODUCT_ID)
as virtrdf:CatalogProduct-PRODUCT_ID ;
rdfs:comment catalog_products.DESCRIPTION;
ecrm:REL_ID catalog_products.REL_ID
as virtrdf:CatalogProduct-REL_ID ;
ecrm:price catalog_products.PRICE
as virtrdf:CatalogProduct-PRICE ;
ecrm:currency catalog_products.CURRENCY
as virtrdf:CatalogProduct-CURRENCY ;
ecrm:description catalog_products.DESCRIPTION
as virtrdf:CatalogProduct-DESCRIPTION .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:CatalogProduct (catalog_products.ORG_ID, catalog_products.CATALOG_ID, catalog_products.PRODUCT_ID)
where (^{catalog_products.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:CatalogProduct-is_ecrm_org_of .
ecrm:Catalog(catalog_products.ORG_ID, catalog_products.CATALOG_ID)
ecrm:is_catalog_of
ecrm:CatalogProduct (catalog_products.ORG_ID, catalog_products.CATALOG_ID, catalog_products.PRODUCT_ID)
as virtrdf:CatalogProduct-is_catalog_of .
ecrm:Product(catalog_products.ORG_ID, catalog_products.PRODUCT_ID)
ecrm:is_product_of
ecrm:CatalogProduct (catalog_products.ORG_ID, catalog_products.CATALOG_ID, catalog_products.PRODUCT_ID)
as virtrdf:CatalogProduct-is_product_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:CatalogProduct (catalog_products.ORG_ID, catalog_products.CATALOG_ID, catalog_products.PRODUCT_ID)
where (^{catalog_products.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{catalog_products.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:CatalogProduct-account_manager .
ecrm:tel_iri(companies.PHONE_NUMBER)
owl:sameAs
ecrm:callto_iri(companies.PHONE_NUMBER) .
ecrm:tel_iri(companies.FAX_NUMBER)
owl:sameAs
ecrm:callto_iri(companies.FAX_NUMBER) .
ecrm:tel_iri(companies.MOBILE_NUMBER)
owl:sameAs
ecrm:callto_iri(companies.MOBILE_NUMBER) .
ecrm:tel_iri(employments.PHONE_NUMBER)
owl:sameAs
ecrm:callto_iri(employments.PHONE_NUMBER) .
ecrm:tel_iri(employments.FAX_NUMBER)
owl:sameAs
ecrm:callto_iri(employments.FAX_NUMBER).
ecrm:tel_iri(employments.MOBILE_NUMBER)
owl:sameAs
ecrm:callto_iri(employments.MOBILE_NUMBER).
ecrm:tel_iri(contacts.PHONE_NUMBER)
owl:sameAs
ecrm:callto_iri(contacts.PHONE_NUMBER).
ecrm:tel_iri(contacts.PHONE2_NUMBER)
owl:sameAs
ecrm:callto_iri(contacts.PHONE2_NUMBER).
ecrm:tel_iri(contacts.FAX_NUMBER)
owl:sameAs
ecrm:callto_iri(contacts.FAX_NUMBER).
ecrm:tel_iri(contacts.MOBILE_NUMBER)
owl:sameAs
ecrm:callto_iri(contacts.MOBILE_NUMBER).
ecrm:tel_iri(leads.PHONE_NUMBER)
owl:sameAs
ecrm:callto_iri(leads.PHONE_NUMBER).
ecrm:tel_iri(leads.MOBILE_NUMBER)
owl:sameAs
ecrm:callto_iri(leads.MOBILE_NUMBER).
ecrm:tel_iri(leads.FAX_NUMBER)
owl:sameAs
ecrm:callto_iri(leads.FAX_NUMBER).
ecrm:tel_iri(cases.PHONE_NUMBER)
owl:sameAs
ecrm:callto_iri(cases.PHONE_NUMBER).
ecrm:tel_iri(orders.PHONE_NUMBER)
owl:sameAs
ecrm:callto_iri(orders.PHONE_NUMBER).
} .
} .
;
SPARQL
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix ecrm: <http://www.openlinksw.com/ontology/ecrm#>
prefix sioc: <http://rdfs.org/sioc/ns#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix cal: <http://www.w3.org/2002/12/cal/ical#>
prefix product: <http://www.swop-project.eu/ontologies/pmo/product.owl#>
prefix owl: <http://www.w3.org/2002/07/owl#>
prefix relationship: <http://vocab.org/relationship/#>
prefix gr: <http://purl.org/goodrelations/v1#>
alter quad storage virtrdf:DefaultQuadStorage
from eCRM.DBA.SFA_SALES_QUOTA as sales_quotas
from eCRM.DBA.SFA_COMPANIES as companies text literal companies.DESCRIPTION
from eCRM.DBA.SFA_CONTACTS as contacts text literal contacts.NAME_FIRST
from eCRM.DBA.SFA_EMPLOYMENTS as employments
from eCRM.DBA.SFA_LEADS as leads text literal leads.SUBJECT
from eCRM.DBA.SFA_OPPORTUNITIES as opportunities text literal opportunities.OPPORTUNITY_NAME
from eCRM.DBA.SFA_ACTIVITIES as activities
from eCRM.DBA.SFA_MAIL_MESSAGES as messages
from eCRM.DBA.SFA_DOCUMENTS as documents
from eCRM.DBA.SFA_INFLUENCERS as influencers
from eCRM.DBA.SFA_TEAMS as teams
from eCRM.DBA.SFA_NOTES as notes text literal notes.DESCRIPTION
from eCRM.DBA.SFA_COMPETITORS as competitors
from eCRM.DBA.SFA_ISSUES as issues
from eCRM.DBA.SFA_CUSTOM_FIELD_DEFS as custom_field_defs
from eCRM.DBA.SFA_CUSTOM_FIELDS as custom_fields
from eCRM.DBA.SFA_CASES as cases text literal cases.SUMMARY
from eCRM.DBA.SFA_ORDERS as orders text literal orders.EMAIL
from eCRM.DBA.SFA_ORDER_ITEMS as order_items
from eCRM.DBA.PM_CATEGORIES as categories
from eCRM.DBA.PM_PRODUCT_ATTRIBUTE_DEFS as product_attribute_defs
from eCRM.DBA.PM_PRODUCTS as products text literal products.DESCRIPTION
from eCRM.DBA.PM_PRODUCT_ATTRIBUTES as product_attributes
from eCRM.DBA.PM_CATALOGS as catalogs
from eCRM.DBA.PM_CATALOG_PRODUCTS as catalog_products
from eCRM.DBA.XSYS_MODULES as modules
from eCRM.DBA.XSYS_REGISTRY as registries
from eCRM.DBA.XSYS_ORGANIZATIONS_DATA as organizations_data
from eCRM.DBA.XSYS_MESSAGES as xsysmessages
from eCRM.DBA.XSYS_COUNTRIES as countries
from eCRM.DBA.XSYS_PROVINCES as provinces
from eCRM.DBA.XSYS_TIMEZONES as timezones
from eCRM.DBA.XSYS_MIME_TYPES as mimetypes
from eCRM.DBA.XSYS_MIME_EXTENSIONS as mimeexts
from eCRM.DBA.XSYS_CNAMES as cnames
from eCRM.DBA.XSYS_QUOTAS as quotas
from eCRM.DBA.XSYS_ROLES as roles
from eCRM.DBA.XSYS_ACCOUNTS as accounts
from eCRM.DBA.XSYS_USERDATA as userdatas
from eCRM.DBA.XSYS_GROUPDATA as groupdatas
from eCRM.DBA.XSYS_MEMBERS as members
from eCRM.DBA.XSYS_SESSIONS_DATA as sessionsdatas
from eCRM.DBA.XSYS_SESSION_DATA as sessiondatas
from eCRM.DBA.XSYS_LIST_MEMBERS_DEFS as list_members_defs
from eCRM.DBA.XSYS_CLASSES as classes
from eCRM.DBA.XSYS_ORG_CLASSES as org_classes
from eCRM.DBA.XSYS_CLASS_METHODS as class_methods
from eCRM.DBA.XSYS_CLASS_VIEWS as class_views
from eCRM.DBA.XSYS_ROLE_PRIVILEGES as role_priveleges
from eCRM.DBA.XSYS_USER_PRIVILEGES as user_priveleges
from eCRM.DBA.XSYS_HISTORY as history
from eCRM.DBA.XSYS_USERS as xsys_users
from eCRM.DBA.AP_PROCESSES as ap_processes
from eCRM.DBA.AP_RULES as ap_rules
from eCRM.DBA.AP_QUEUE as ap_queues
where (^{companies.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{contacts.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{leads.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{products.}^.COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
where (^{orders.}^.SHIP_COUNTRY_NAME = ^{countries.}^.COUNTRY_NAME)
{
create virtrdf:ecrmDemo3 as graph iri ("http://^{URIQADefaultHost}^/ecrm") option (exclusive, order 1503)
{
ecrm:Influencer (influencers.ORG_ID, influencers.INFLUENCER_ID)
a ecrm:Influencer
as virtrdf:Influencer-Influencers2 ;
a foaf:Person
as virtrdf:Influencer-Influencers ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label influencers.CONTACT_NAME;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{influencers.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Influencer-ORG_ID ;
ecrm:has_account_manager ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{influencers.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{influencers.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Influencer-OWNER_ID ;
ecrm:has_opportunity ecrm:Opportunity(influencers.ORG_ID, influencers.OPPORTUNITY_ID)
as virtrdf:Influencer-OPPORTUNITY_ID ;
ecrm:has_company ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{influencers.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{influencers.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Influencer-COMPANY_ID ;
ecrm:contactName influencers.CONTACT_NAME
as virtrdf:Influencer-CONTACT_NAME ;
foaf:title influencers.TITLE
as virtrdf:foafInfluencer-TITLE ;
ecrm:IROLE influencers.IROLE
as virtrdf:Influencer-IROLE ;
ecrm:responseMode influencers.RESPONSE_MODE
as virtrdf:Influencer-RESPONSE_MODE .
ecrm:Company (companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
ecrm:is_company_of
ecrm:Influencer (influencers.ORG_ID, influencers.INFLUENCER_ID)
where (^{influencers.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{influencers.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Influencer-is_company_of .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Influencer (influencers.ORG_ID, influencers.INFLUENCER_ID)
where (^{influencers.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Influencer-is_ecrm_org_of .
ecrm:Opportunity (influencers.ORG_ID, influencers.OPPORTUNITY_ID)
ecrm:has_influencer
ecrm:Influencer (influencers.ORG_ID, influencers.INFLUENCER_ID)
as virtrdf:Influencer-is_opportunity_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Influencer (influencers.ORG_ID, influencers.INFLUENCER_ID)
where (^{influencers.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{influencers.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Influencer-account_manager .
ecrm:Team (teams.ORG_ID, teams.OPPORTUNITY_ID, teams.CONTACT_ID)
a ecrm:Team
as virtrdf:Team-Teams ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{teams.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Team-ORG_ID ;
rdfs:label teams.TITLE;
ecrm:teamId teams.TEAM_ID
as virtrdf:Team-TEAM_ID ;
ecrm:has_opportunity ecrm:Opportunity(teams.ORG_ID, teams.OPPORTUNITY_ID)
as virtrdf:Team-OPPORTUNITY_ID ;
ecrm:owner ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{teams.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{teams.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Team-OWNER_ID ;
ecrm:has_contact ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
where (^{teams.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{teams.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Team-CONTACT_ID ;
ecrm:title teams.TITLE
as virtrdf:Team-TITLE ;
ecrm:department teams.DEPARTMENT
as virtrdf:Team-DEPARTMENT ;
ecrm:TROLE teams.TROLE
as virtrdf:Team-TROLE .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Team (teams.ORG_ID, teams.OPPORTUNITY_ID, teams.CONTACT_ID)
where (^{teams.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Team-is_ecrm_org_of .
ecrm:Contact(contacts.CONTACT_ID, contacts.ORG_ID)
ecrm:is_contact_of
ecrm:Team (teams.ORG_ID, teams.OPPORTUNITY_ID, teams.CONTACT_ID)
where (^{teams.}^.CONTACT_ID = ^{contacts.}^.CONTACT_ID and ^{teams.}^.ORG_ID = ^{contacts.}^.ORG_ID)
as virtrdf:Team-is_contact_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Team (teams.ORG_ID, teams.OPPORTUNITY_ID, teams.CONTACT_ID)
where (^{teams.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{teams.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Team-account_manager .
ecrm:Competitor (competitors.ORG_ID, competitors.COMPETITOR_ID)
a ecrm:Competitor
as virtrdf:Competitor-Competitors2 ;
a foaf:Organization
as virtrdf:Competitor-Competitors ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{competitors.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Competitor-ORG_ID ;
ecrm:owner ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{competitors.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{competitors.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Competitor-OWNER_ID ;
ecrm:has_opportunity ecrm:Opportunity(competitors.ORG_ID, competitors.OPPORTUNITY_ID)
as virtrdf:Competitor-OPPORTUNITY_ID ;
ecrm:has_company ecrm:Company(companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
where (^{competitors.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{competitors.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Competitor-COMPANY_ID ;
ecrm:has_product ecrm:Product(competitors.ORG_ID, competitors.PRODUCT_ID)
as virtrdf:Competitor-PRODUCT_ID ;
foaf:name competitors.CONTACT_NAME
as virtrdf:foafCompetitor-CONTACT_NAME ;
ecrm:productName competitors.PRODUCT_NAME
as virtrdf:Competitor-PRODUCT_NAME ;
ecrm:Strengths competitors.STRENGTHS
as virtrdf:Competitor-STRENGTHS ;
ecrm:Weakness competitors.WEAKNESS
as virtrdf:Competitor-WEAKNESS ;
ecrm:Rating competitors.RATING
as virtrdf:Competitor-RATING ;
ecrm:Status competitors.STATUS
as virtrdf:Competitor-STATUS .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Competitor (competitors.ORG_ID, competitors.COMPETITOR_ID)
where (^{competitors.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Competitor-is_ecrm_org_of .
ecrm:Company (companies.COMPANY_NAME, companies.COMPANY_ID, companies.ORG_ID)
ecrm:is_company_of
ecrm:Competitor (competitors.ORG_ID, competitors.COMPETITOR_ID)
where (^{competitors.}^.COMPANY_ID = ^{companies.}^.COMPANY_ID and ^{competitors.}^.ORG_ID = ^{companies.}^.ORG_ID)
as virtrdf:Competitor-is_company_of .
ecrm:Opportunity (competitors.ORG_ID, competitors.OPPORTUNITY_ID)
ecrm:is_opportunity_of
ecrm:Competitor (competitors.ORG_ID, competitors.COMPETITOR_ID)
as virtrdf:Competitor-is_opportunity_of .
ecrm:Product(competitors.ORG_ID, competitors.PRODUCT_ID)
ecrm:is_product_of
ecrm:Competitor (competitors.ORG_ID, competitors.COMPETITOR_ID)
as virtrdf:Competitor-is_product_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:Competitor (competitors.ORG_ID, competitors.COMPETITOR_ID)
where (^{competitors.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{competitors.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:Competitor-account_manager .
ecrm:Module (modules.MODULE_ID)
a ecrm:Module
as virtrdf:Module-Modules ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:prefix modules.PREFIX
as virtrdf:Module-PREFIX ;
rdfs:label modules.MODULE_NAME;
ecrm:moduleName modules.MODULE_NAME
as virtrdf:Module-MODULE_NAME ;
ecrm:description modules.DESCRIPTION
as virtrdf:Module-DESCRIPTION ;
ecrm:version modules.VERSION
as virtrdf:Module-VERSION ;
ecrm:buildDate modules.BUILD_DATE
as virtrdf:Module-BUILD_DATE ;
ecrm:installDate modules.INSTALL_DATE
as virtrdf:Module-INSTALL_DATE .
ecrm:Registry (registries.KEY_NAME)
a ecrm:Registry
as virtrdf:Registry-Registrys ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:keyName registries.KEY_NAME
as virtrdf:Registry-KEY_NAME ;
ecrm:hasModule ecrm:Module(registries.MODULE_ID)
as virtrdf:Registry-MODULE_ID ;
ecrm:keyData registries.KEY_DATA
as virtrdf:Registry-KEY_DATA .
ecrm:Module(registries.MODULE_ID)
ecrm:is_module_of
ecrm:Registry (registries.KEY_NAME)
as virtrdf:Registry-is_module_of .
ecrm:Message (xsysmessages.MODULE_ID, xsysmessages.MSG_ID)
a ecrm:Message
as virtrdf:Message-Messages ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label xsysmessages.MSG_TEXT;
ecrm:hasModule ecrm:Module(xsysmessages.MODULE_ID)
as virtrdf:Message-MODULE_ID ;
ecrm:messageText xsysmessages.MSG_TEXT
as virtrdf:Message-MSG_TEXT .
ecrm:Module(registries.MODULE_ID)
ecrm:is_module_of
ecrm:Message (xsysmessages.MODULE_ID, xsysmessages.MSG_ID)
as virtrdf:Message-is_module_of .
ecrm:Timezone (timezones.TZ_ID)
a ecrm:Timezone
as virtrdf:Timezone-Timezones ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label timezones.TZ_NAME;
ecrm:timezoneName timezones.TZ_NAME
as virtrdf:Timezone-TZ_NAME ;
ecrm:timezoneOffset timezones.TZ_OFFSET
as virtrdf:Timezone-TZ_OFFSET .
ecrm:MimeType (mimetypes.ID)
a ecrm:MimeType
as virtrdf:MimeType-MimeTypes ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label mimetypes.MIME_TYPE;
rdfs:comment mimetypes.DESCRIPTION;
ecrm:mimeType mimetypes.MIME_TYPE
as virtrdf:MimeType-MIME_TYPE ;
ecrm:description mimetypes.DESCRIPTION
as virtrdf:MimeType-DESCRIPTION .
ecrm:MimeExtension (mimeexts.MIME_TYPE_ID, mimeexts.EXTENSION)
a ecrm:MimeExtension
as virtrdf:MimeExtension-MimeExtensions ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:hasMimeType ecrm:MimeType (mimeexts.MIME_TYPE_ID)
as virtrdf:MimeExtension-MIME_TYPE_ID ;
ecrm:extension mimeexts.EXTENSION
as virtrdf:MimeExtension-EXTENSION .
ecrm:MimeType (mimetypes.ID)
ecrm:is_MimeType_of
ecrm:MimeExtension (mimeexts.MIME_TYPE_ID, mimeexts.EXTENSION)
as virtrdf:MimeExtension-is_mimetype_of .
ecrm:Cname (cnames.DNS_CNAME)
a ecrm:Cname
as virtrdf:Cname-Cnames ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label cnames.DNS_CNAME;
ecrm:dnsCname cnames.DNS_CNAME
as virtrdf:Cname-DNS_CNAME ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{cnames.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Cname-ORG_ID ;
ecrm:interface cnames.INTERFACE
as virtrdf:Cname-INTERFACE .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Cname (cnames.DNS_CNAME)
where (^{cnames.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Cname-is_ecrm_org_of .
ecrm:Quota (quotas.ORG_ID, quotas.QUOTA_ID)
a ecrm:Quota
as virtrdf:Quota-Quotas ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label quotas.QUOTA_NAME;
ecrm:quotaName quotas.QUOTA_NAME
as virtrdf:Quota-QUOTA_NAME ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{quotas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Quota-ORG_ID ;
ecrm:spaceTotal quotas.SPACE_TOTAL
as virtrdf:Quota-SPACE_TOTAL .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Quota (quotas.ORG_ID, quotas.QUOTA_ID)
where (^{quotas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Quota-is_ecrm_org_of .
ecrm:Role (roles.ORG_ID, roles.ROLE_ID)
a ecrm:Role
as virtrdf:Role-Roles ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label roles.ROLE_NAME;
ecrm:roleName roles.ROLE_NAME
as virtrdf:Role-ROLE_NAME ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{roles.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Role-ORG_ID ;
ecrm:parentID roles.PARENT_ID
as virtrdf:Role-PARENT_ID .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Role (roles.ORG_ID, roles.ROLE_ID)
where (^{roles.}^.ORG_ID = ^{organizations_data.}^.ORG_ID) as virtrdf:Role-is_ecrm_org_of .
ecrm:Account (accounts.ORG_ID, accounts.ACCOUNT_ID)
a ecrm:Account
as virtrdf:Account-Accounts ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label accounts.ACCOUNT_NAME;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{accounts.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Account-ORG_ID ;
ecrm:accountType accounts.ACCOUNT_TYPE
as virtrdf:Account-ACCOUNT_TYPE ;
ecrm:accountName accounts.ACCOUNT_NAME
as virtrdf:Account-ACCOUNT_NAME ;
ecrm:data accounts.DATA
as virtrdf:Account-DATA .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Account (accounts.ORG_ID, accounts.ACCOUNT_ID)
where (^{accounts.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Account-is_ecrm_org_of .
ecrm:UserData (userdatas.ORG_ID, userdatas.ACCOUNT_ID)
a ecrm:UserData
as virtrdf:UserData-UserDatas ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{userdatas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:UserData-ORG_ID ;
ecrm:has_account ecrm:Account(userdatas.ORG_ID, userdatas.ACCOUNT_ID)
as virtrdf:UserData-ACCOUNT_ID ;
ecrm:status userdatas.STATUS
as virtrdf:UserData-STATUS ;
ecrm:loginPassword userdatas.LOGIN_PWD
as virtrdf:UserData-LOGIN_PWD ;
ecrm:has_role ecrm:Role(userdatas.ORG_ID, userdatas.ROLE_ID)
as virtrdf:UserData-ROLE_ID ;
ecrm:has_quota ecrm:Quota(userdatas.ORG_ID, userdatas.QUOTA_ID)
as virtrdf:UserData-QUOTA_ID ;
ecrm:spaceUsed userdatas.SPACE_USED
as virtrdf:UserData-SPACE_USED ;
ecrm:lastLogin userdatas.LAST_LOGIN
as virtrdf:UserData-LAST_LOGIN ;
ecrm:loginPolicy userdatas.LOGIN_POLICY
as virtrdf:UserData-LOGIN_POLICY ;
ecrm:preferences userdatas.PREFERENCES
as virtrdf:UserData-PREFERENCES .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:UserData (userdatas.ORG_ID, userdatas.ACCOUNT_ID)
where (^{userdatas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:UserData-is_ecrm_org_of .
ecrm:Role(userdatas.ORG_ID, userdatas.ROLE_ID)
ecrm:is_role_of
ecrm:UserData (userdatas.ORG_ID, userdatas.ACCOUNT_ID)
as virtrdf:UserData-is_role_of .
ecrm:Quota(userdatas.ORG_ID, userdatas.QUOTA_ID)
ecrm:is_quota_of
ecrm:UserData (userdatas.ORG_ID, userdatas.ACCOUNT_ID)
as virtrdf:UserData-is_quota_of .
ecrm:Account(userdatas.ORG_ID, userdatas.ACCOUNT_ID)
ecrm:is_account_of
ecrm:UserData (userdatas.ORG_ID, userdatas.ACCOUNT_ID)
as virtrdf:UserData-is_account_of .
ecrm:GroupData (groupdatas.ORG_ID, groupdatas.ACCOUNT_ID)
a ecrm:GroupData
as virtrdf:GroupData-GroupDatas ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{groupdatas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:GroupData-ORG_ID ;
ecrm:has_account ecrm:Account(groupdatas.ORG_ID, groupdatas.ACCOUNT_ID)
as virtrdf:GroupData-ACCOUNT_ID ;
ecrm:owner ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{groupdatas.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{groupdatas.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:GroupData-OWNER_ID .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:GroupData (groupdatas.ORG_ID, groupdatas.ACCOUNT_ID)
where (^{groupdatas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:GroupData-is_ecrm_org_of .
ecrm:Account(groupdatas.ORG_ID, groupdatas.ACCOUNT_ID)
ecrm:is_account_of
ecrm:GroupData (groupdatas.ORG_ID, groupdatas.ACCOUNT_ID)
as virtrdf:GroupData-is_account_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:GroupData (groupdatas.ORG_ID, groupdatas.ACCOUNT_ID)
where (^{groupdatas.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{groupdatas.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:GroupData-account_manager .
ecrm:Member (members.ORG_ID, members.GROUP_ID, members.USER_ID)
a ecrm:Member
as virtrdf:Member-Members ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{members.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Member-ORG_ID ;
ecrm:has_groupData ecrm:GroupData(members.ORG_ID, members.GROUP_ID)
as virtrdf:Member-GROUP_ID ;
ecrm:has_userData ecrm:UserData(members.ORG_ID, members.USER_ID)
as virtrdf:Member-USER_ID ;
ecrm:addedBy members.ADDED_BY
as virtrdf:Member-ADDED_BY ;
ecrm:addedOn members.ADDED_ON
as virtrdf:Member-ADDED_ON .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:Member (members.ORG_ID, members.GROUP_ID, members.USER_ID)
where (^{members.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:Member-is_ecrm_org_of .
ecrm:GroupData(members.ORG_ID, members.GROUP_ID)
ecrm:is_groupdata_of
ecrm:Member (members.ORG_ID, members.GROUP_ID, members.USER_ID)
as virtrdf:Member-is_groupdata_of .
ecrm:UserData(members.ORG_ID, members.USER_ID)
ecrm:is_userdata_of
ecrm:Member (members.ORG_ID, members.GROUP_ID, members.USER_ID)
as virtrdf:Member-is_userdata_of .
ecrm:SessionsData (sessionsdatas.SID)
a ecrm:SessionsData
as virtrdf:SessionsData-SessionsDatas ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{sessionsdatas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:SessionsData-ORG_ID ;
ecrm:has_account ecrm:Account(sessionsdatas.ORG_ID, sessionsdatas.ACCOUNT_ID)
as virtrdf:SessionsData-ACCOUNT_ID ;
ecrm:createdOn sessionsdatas.CREATED_ON
as virtrdf:SessionsData-CREATED_ON ;
ecrm:expireOn sessionsdatas.EXPIRE_ON
as virtrdf:SessionsData-EXPIRE_ON ;
ecrm:forceExpire sessionsdatas.FORCE_EXPIRE
as virtrdf:SessionsData-FORCE_EXPIRE ;
ecrm:dirty sessionsdatas.DIRTY
as virtrdf:SessionsData-DIRTY ;
ecrm:ipAddr sessionsdatas.IP_ADDR
as virtrdf:SessionsData-IP_ADDR .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:SessionsData (sessionsdatas.SID)
where (^{sessionsdatas.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:SessionsData-is_ecrm_org_of .
ecrm:Account(sessionsdatas.ORG_ID, sessionsdatas.ACCOUNT_ID)
ecrm:is_account_of
ecrm:SessionsData (sessionsdatas.SID)
as virtrdf:SessionsData-is_account_of .
ecrm:SessionData (sessiondatas.SID, sessiondatas.BUFFER_ID)
a ecrm:SessionData
as virtrdf:SessionData-SessionDatas ;
ecrm:has_sessionsData ecrm:SessionsData(sessiondatas.SID)
as virtrdf:SessionData-SID ;
ecrm:BUFFER_ID sessiondatas.BUFFER_ID
as virtrdf:SessionData-BUFFER_ID .
ecrm:SessionsData(sessiondatas.SID)
ecrm:is_sessionsdata_of
ecrm:SessionData (sessiondatas.SID, sessiondatas.BUFFER_ID)
as virtrdf:SessionData-is_sessionsdata_of .
ecrm:Class (classes.CLASS_ID)
a ecrm:Class
as virtrdf:Class-Classes ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label classes.CLASS_NAME;
ecrm:className classes.CLASS_NAME
as virtrdf:Class-CLASS_NAME ;
ecrm:keyPrefix classes.KEY_PREFIX
as virtrdf:Class-KEY_PREFIX ;
ecrm:classTable classes.CLASS_TABLE
as virtrdf:Class-CLASS_TABLE ;
ecrm:data classes.DATA
as virtrdf:Class-DATA ;
ecrm:category classes.CATEGORY
as virtrdf:Class-CATEGORY ;
ecrm:weight classes.WEIGHT
as virtrdf:Class-WEIGHT ;
ecrm:xmlSchema classes.XML_SCHEMA
as virtrdf:Class-XML_SCHEMA .
ecrm:OrgClass (org_classes.ORG_ID, org_classes.CLASS_ID)
a ecrm:OrgClass
as virtrdf:OrgClass-OrgClasses ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{org_classes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:OrgClass-ORG_ID ;
ecrm:has_class ecrm:Class(org_classes.CLASS_ID)
as virtrdf:OrgClass-CLASS_ID ;
ecrm:customFields org_classes.CUSTOM_FIELDS
as virtrdf:OrgClass-CUSTOM_FIELDS .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:OrgClass (org_classes.ORG_ID, org_classes.CLASS_ID)
where (^{org_classes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:OrgClass-is_ecrm_org_of .
ecrm:ClassMethod (class_methods.CLASS_ID, class_methods.METHOD_ID)
a ecrm:ClassMethod
as virtrdf:ClassMethod-ClassMethods ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_class ecrm:Class(class_methods.CLASS_ID)
as virtrdf:ClassMethod-CLASS_ID ;
ecrm:methodId class_methods.METHOD_ID
as virtrdf:ClassMethod-METHOD_ID ;
ecrm:methodType class_methods.METHOD_TYPE
as virtrdf:ClassMethod-METHOD_TYPE .
ecrm:Class(class_methods.CLASS_ID)
ecrm:is_class_of
ecrm:ClassMethod (class_methods.CLASS_ID, class_methods.METHOD_ID)
as virtrdf:ClassMethod-is_class_of .
ecrm:ClassView (class_views.ORG_ID, class_views.VIEW_ID)
a ecrm:ClassView
as virtrdf:ClassView-ClassViews ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
rdfs:label class_views.VIEW_NAME;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{class_views.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:ClassView-ORG_ID ;
ecrm:owner ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{class_views.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{class_views.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:ClassView-OWNER_ID ;
ecrm:has_class ecrm:Class(class_views.CLASS_ID)
as virtrdf:ClassView-CLASS_ID ;
ecrm:viewName class_views.VIEW_NAME
as virtrdf:ClassView-VIEW_NAME ;
ecrm:viewData class_views.VIEW_DATA
as virtrdf:ClassView-VIEW_DATA ;
ecrm:isPublic class_views.IS_PUBLIC
as virtrdf:ClassView-IS_PUBLIC .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:ClassView (class_views.ORG_ID, class_views.VIEW_ID)
where (^{class_views.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:ClassView-is_ecrm_org_of .
ecrm:Class(class_views.CLASS_ID)
ecrm:is_class_of
ecrm:ClassView (class_views.ORG_ID, class_views.VIEW_ID)
as virtrdf:ClassView-is_class_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:ClassView (class_views.ORG_ID, class_views.VIEW_ID)
where (^{class_views.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{class_views.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:ClassView-account_manager .
ecrm:RolePrivelege (role_priveleges.ORG_ID, role_priveleges.ROLE_ID, role_priveleges.CLASS_ID, role_priveleges.METHOD_ID)
a ecrm:RolePrivelege
as virtrdf:RolePrivelege-RolePriveleges ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{role_priveleges.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:RolePrivelege-ORG_ID ;
ecrm:has_role ecrm:Role(role_priveleges.ORG_ID, role_priveleges.ROLE_ID)
as virtrdf:RolePrivelege-ROLE_ID ;
ecrm:has_class ecrm:Class(role_priveleges.CLASS_ID)
as virtrdf:RolePrivelege-CLASS_ID ;
ecrm:has_method ecrm:ClassMethod(role_priveleges.CLASS_ID, role_priveleges.METHOD_ID)
as virtrdf:RolePrivelege-METHOD_ID .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:RolePrivelege (role_priveleges.ORG_ID, role_priveleges.ROLE_ID, role_priveleges.CLASS_ID, role_priveleges.METHOD_ID)
where (^{role_priveleges.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:RolePrivelege-is_ecrm_org_of .
ecrm:Role(role_priveleges.ORG_ID, role_priveleges.ROLE_ID)
ecrm:is_role_of
ecrm:RolePrivelege (role_priveleges.ORG_ID, role_priveleges.ROLE_ID, role_priveleges.CLASS_ID, role_priveleges.METHOD_ID)
as virtrdf:RolePrivelege-is_role_of .
ecrm:UserPrivelege (user_priveleges.ORG_ID, user_priveleges.USER_ID, user_priveleges.CLASS_ID, user_priveleges.METHOD_ID)
a ecrm:UserPrivelege
as virtrdf:UserPrivelege-UserPriveleges ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{user_priveleges.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:UserPrivelege-ORG_ID ;
ecrm:has_userData ecrm:UserData(members.ORG_ID, user_priveleges.USER_ID)
as virtrdf:UserPrivelege-USER_ID ;
ecrm:has_class ecrm:Class(user_priveleges.CLASS_ID)
as virtrdf:UserPrivelege-CLASS_ID ;
ecrm:has_method ecrm:ClassMethod(user_priveleges.CLASS_ID, user_priveleges.METHOD_ID)
as virtrdf:UserPrivelege-METHOD_ID .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:UserPrivelege (user_priveleges.ORG_ID, user_priveleges.USER_ID, user_priveleges.CLASS_ID, user_priveleges.METHOD_ID)
where (^{user_priveleges.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:UserPrivelege-is_ecrm_org_of .
ecrm:UserData(members.ORG_ID, user_priveleges.USER_ID)
ecrm:is_userdata_of
ecrm:UserPrivelege (user_priveleges.ORG_ID, user_priveleges.USER_ID, user_priveleges.CLASS_ID, user_priveleges.METHOD_ID)
as virtrdf:UserPrivelege-is_userdata_of .
ecrm:Class(user_priveleges.CLASS_ID)
ecrm:is_class_of
ecrm:UserPrivelege (user_priveleges.ORG_ID, user_priveleges.USER_ID, user_priveleges.CLASS_ID, user_priveleges.METHOD_ID)
as virtrdf:UserPrivelege-is_class_of .
ecrm:ClassMethod(user_priveleges.CLASS_ID, user_priveleges.METHOD_ID)
ecrm:is_classmethod_of
ecrm:UserPrivelege (user_priveleges.ORG_ID, user_priveleges.USER_ID, user_priveleges.CLASS_ID, user_priveleges.METHOD_ID)
as virtrdf:UserPrivelege-is_classmethod_of .
ecrm:History (history.ORG_ID, history.EVENT_ID)
a ecrm:History
as virtrdf:History-Historys ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{history.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:History-ORG_ID ;
ecrm:eventDate history.EVENT_DATE
as virtrdf:History-EVENT_DATE ;
ecrm:has_class ecrm:Class(history.CLASS_ID)
as virtrdf:History-CLASS_ID ;
ecrm:has_method ecrm:ClassMethod(history.CLASS_ID, history.METHOD_ID)
as virtrdf:History-METHOD_ID ;
ecrm:has_user ecrm:UserData(members.ORG_ID, history.USER_ID)
as virtrdf:History-USER_ID ;
ecrm:protocol history.PROTOCOL
as virtrdf:History-PROTOCOL ;
ecrm:location history.LOCATION
as virtrdf:History-LOCATION ;
ecrm:data history.DATA
as virtrdf:History-DATA .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:History (history.ORG_ID, history.EVENT_ID)
where (^{history.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:History-is_ecrm_org_of .
ecrm:ClassMethod(history.CLASS_ID, history.METHOD_ID)
ecrm:is_classmethod_of
ecrm:History (history.ORG_ID, history.EVENT_ID)
as virtrdf:History-is_classmethod_of .
ecrm:UserData(members.ORG_ID, history.USER_ID)
ecrm:is_userdata_of
ecrm:History (history.ORG_ID, history.EVENT_ID)
as virtrdf:History-is_userdata_of .
ecrm:XSys_User (xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
a ecrm:XSys_User
as virtrdf:XSys_User-XSys_Users ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{xsys_users.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:XSys_User-ORG_ID ;
rdfs:label xsys_users.ACCOUNT_NAME;
ecrm:accountType xsys_users.ACCOUNT_TYPE
as virtrdf:XSys_User-ACCOUNT_TYPE ;
ecrm:accountName xsys_users.ACCOUNT_NAME
as virtrdf:XSys_User-ACCOUNT_NAME .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:XSys_User (xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{xsys_users.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:XSys_User-is_ecrm_org_of .
ecrm:AP_Process (ap_processes.ORG_ID, ap_processes.AP_ID)
a ecrm:AP_Process
as virtrdf:AP_Process-AP_Processes ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{ap_processes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:AP_Process-ORG_ID ;
ecrm:owner ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
where (^{ap_processes.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{ap_processes.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:AP_Process-OWNER_ID ;
ecrm:ProcessName ap_processes.NAME
as virtrdf:AP_Process-NAME ;
ecrm:ProcessDescription ap_processes.DESCRIPTION
as virtrdf:AP_Process-DESCRIPTION ;
ecrm:TargetClass ap_processes.TARGET_CLASS
as virtrdf:AP_Process-TARGET_CLASS ;
ecrm:Status ap_processes.STATUS
as virtrdf:AP_Process-STATUS ;
ecrm:AttachOnlyOne ap_processes.OPT_ATTACH_ONLY_ONE
as virtrdf:AP_Process-OPT_ATTACH_ONLY_ONE ;
ecrm:ExecImmediate ap_processes.OPT_EXEC_IMMEDIATE
as virtrdf:AP_Process-OPT_EXEC_IMMEDIATE ;
ecrm:ExecManualOnly ap_processes.OPT_EXEC_MANUAL_ONLY
as virtrdf:AP_Process-OPT_EXEC_MANUAL_ONLY ;
ecrm:AutoRestart ap_processes.OPT_AUTORESTART
as virtrdf:AP_Process-OPT_AUTORESTART ;
ecrm:AutoAttach ap_processes.OPT_AUTOATTACH
as virtrdf:AP_Process-OPT_AUTOATTACH .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:AP_Process (ap_processes.ORG_ID, ap_processes.AP_ID)
where (^{ap_processes.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:AP_Process-is_ecrm_org_of .
ecrm:XSys_User(xsys_users.ORG_ID, xsys_users.ACCOUNT_NAME, xsys_users.ACCOUNT_ID)
ecrm:account_manager
ecrm:AP_Process (ap_processes.ORG_ID, ap_processes.AP_ID)
where (^{ap_processes.}^.OWNER_ID = ^{xsys_users.}^.ACCOUNT_ID and ^{ap_processes.}^.ORG_ID = ^{xsys_users.}^.ORG_ID)
as virtrdf:AP_Process-account_manager .
ecrm:AP_Rule (ap_rules.ORG_ID, ap_rules.AP_ID, ap_rules.RSEQ)
a ecrm:AP_Rule
as virtrdf:AP_Rule-AP_Rules ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{ap_rules.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:AP_Rules-ORG_ID ;
ecrm:process ecrm:AP_Process(ap_rules.ORG_ID, ap_rules.AP_ID)
as virtrdf:AP_Rules-APP_ID ;
ecrm:rType ap_rules.RTYPE
as virtrdf:AP_Rules-RTYPE ;
ecrm:RuleName ap_rules.NAME
as virtrdf:AP_Rules-NAME ;
ecrm:TargetData ap_rules.TRG_DATA
as virtrdf:AP_Rules-TRG_DATA ;
ecrm:actData ap_rules.ACT_DATA
as virtrdf:AP_Rules-ACT_DATA .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:AP_Rule (ap_rules.ORG_ID, ap_rules.AP_ID, ap_rules.RSEQ)
where (^{ap_rules.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:AP_Rule-is_ecrm_org_of .
ecrm:AP_Process(ap_rules.ORG_ID, ap_rules.AP_ID)
ecrm:is_process_of
ecrm:AP_Rule (ap_rules.ORG_ID, ap_rules.AP_ID, ap_rules.RSEQ)
as virtrdf:AP_Rule-is_process_of .
ecrm:AP_Queue (ap_queues.ID)
a ecrm:AP_Queue
as virtrdf:AP_Queue-AP_Queues ;
rdfs:isDefinedBy ecrm:isDefinedBy () ;
ecrm:has_ecrm_organization ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
where (^{ap_queues.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:AP_Queue-ORG_ID ;
ecrm:process ecrm:AP_Process(ap_queues.ORG_ID, ap_queues.AP_ID)
as virtrdf:AP_Queue-APP_ID ;
ecrm:OBJ_ID ap_queues.OBJ_ID
as virtrdf:AP_Queue-OBJ_ID ;
ecrm:isRunning ap_queues.IS_RUNNING
as virtrdf:AP_Queue-IS_RUNNING ;
ecrm:isDebug ap_queues.IS_DEBUG
as virtrdf:AP_Queue-IS_DEBUG ;
ecrm:currentRule ecrm:AP_Rule (ap_queues.ORG_ID, ap_queues.AP_ID, ap_queues.CURRENT_RULE)
as virtrdf:AP_Queue-CURRENT_RULE ;
ecrm:lastPass ap_queues.LAST_PASS
as virtrdf:AP_Queue-LAST_PASS ;
ecrm:lastExec ap_queues.LAST_EXEC
as virtrdf:AP_Queue-LAST_EXEC ;
ecrm:dateAttach ap_queues.DATE_ATTACH
as virtrdf:AP_Queue-DATE_ATTACH ;
ecrm:dateStart ap_queues.DATE_START
as virtrdf:AP_Queue-DATE_START .
ecrm:OrganizationsData(organizations_data.ORG_ID, organizations_data.DNS_ZONE)
ecrm:ecrm_organization_of
ecrm:AP_Queue (ap_queues.ID)
where (^{ap_queues.}^.ORG_ID = ^{organizations_data.}^.ORG_ID)
as virtrdf:AP_Queue-is_ecrm_org_of .
ecrm:AP_Rule (ap_queues.ORG_ID, ap_queues.AP_ID, ap_queues.CURRENT_RULE)
ecrm:is_CurrentRule_of
ecrm:AP_Queue (ap_queues.ID)
as virtrdf:AP_Queue-is_rule_of .
} .
} .
;
delete from db.dba.url_rewrite_rule_list where urrl_list like 'ecrm_%';
delete from db.dba.url_rewrite_rule where urr_rule like 'ecrm_%';
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'ecrm_rule1',
1,
'(/[^#]*)',
vector('path'),
1,
'/about/html/http/^{URIQADefaultHost}^%s%%01this',
vector('path'),
null,
'(text/html)|(\\*/\\*)',
0,
303
)
;
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'ecrm_rule2',
1,
'(/[^#]*)',
vector('path'),
1,
'/sparql?query=CONSTRUCT+{+%%3Chttp%%3A//^{URIQADefaultHost}^%U%%23this%%3E+%%3Fp+%%3Fo+}+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/ecrm%%3E+WHERE+{+%%3Chttp%%3A//^{URIQADefaultHost}^%U%%23this%%3E+%%3Fp+%%3Fo+}&format=%U',
vector('path', 'path', '*accept*'),
null,
'(text/rdf.n3)|(application/rdf.xml)',
0,
null
)
;
DB.DBA.URLREWRITE_CREATE_REGEX_RULE (
'ecrm_rule3',
1,
'(/[^#]*)/\x24',
vector('path'),
1,
'%U',
vector('path'),
null,
null,
0,
null
)
;
create procedure DB.DBA.ECRM_MAKE_RDF_DET()
{
declare uriqa_str varchar;
uriqa_str := cfg_item_value(virtuoso_ini_path(), 'URIQA','DefaultHost');
uriqa_str := 'http://' || uriqa_str || '/ecrm';
DB.DBA."RDFData_MAKE_DET_COL" ('/DAV/VAD/eCRM/RDFData/', uriqa_str, NULL);
VHOST_REMOVE (lpath=>'/ecrm/data/rdf');
DB.DBA.VHOST_DEFINE (lpath=>'/ecrm/data/rdf', ppath=>'/DAV/VAD/eCRM/RDFData/All/', is_dav=>1, vsp_user=>'dba');
}
;
DB.DBA.ECRM_MAKE_RDF_DET()
;
drop procedure DB.DBA.ECRM_MAKE_RDF_DET
;
-- procedure to convert path to DET resource name
create procedure DB.DBA.ECRM_DET_REF (in par varchar, in fmt varchar, in val varchar)
{
declare res, iri any;
declare uriqa_str varchar;
uriqa_str := cfg_item_value(virtuoso_ini_path(), 'URIQA','DefaultHost');
uriqa_str := 'http://' || uriqa_str || '/ecrm';
iri := uriqa_str || val;
res := sprintf ('iid (%d).rdf', iri_id_num (iri_to_id (iri)));
return sprintf (fmt, res);
}
;
DB.DBA.URLREWRITE_CREATE_REGEX_RULE ('ecrm_rdf', 1,
'/ecrm/(.*)', vector('path'), 1,
'/ecrm/data/rdf/%U', vector('path'),
'DB.DBA.ECRM_DET_REF',
'application/rdf.xml',
2,
303)
;
create procedure DB.DBA.ECRM_DET_REF2 (in par varchar, in fmt varchar, in val varchar)
{
declare tmp, stream any;
declare oid, inst, class, sid, url varchar;
declare pos, org_id_ integer;
val := replace(val, '%27', '\'');
val := replace(val, '%20', ' ');
if (val like '%/%/view.vsp?sid=%&oid=%')
{
tmp := sprintf_inverse (val, '%s/%s/view.vsp?sid=%s&oid=%s', 0);
inst := tmp[0];
class := tmp[1];
sid := tmp[2];
oid := tmp[3];
pos := strchr(oid, '&');
if (pos is not NULL)
{
oid := left(oid, pos);
}
org_id_ := (select WAI_ID from DB.DBA.WA_INSTANCE where WAI_NAME = inst);
if (class = 'company')
{
for (select COMPANY_NAME, COMPANY_ID from eCRM.DBA.SFA_COMPANIES where cast(COMPANY_ID as varchar) = oid and ORG_ID = org_id_) do
{
url := sprintf('Company/%U/%U/%d#this', COMPANY_NAME, COMPANY_ID, org_id_);
}
}
if (class = 'lead')
{
for (select SUBJECT, LEAD_ID from eCRM.DBA.SFA_LEADS where cast(LEAD_ID as varchar) = oid and ORG_ID = org_id_) do
{
url := sprintf('Lead/%U/%d/%U#this', SUBJECT, org_id_, LEAD_ID);
}
}
if (class = 'opportunity')
{
url := sprintf('Lead/%d/%/U#this', org_id_, oid);
}
if (class = 'contact')
{
for (select NAME_FIRST, NAME_MIDDLE, NAME_LAST, CONTACT_ID from eCRM.DBA.SFA_CONTACTS where cast(CONTACT_ID as varchar) = oid and ORG_ID = org_id_) do
{
url := sprintf('Contact/%U/%U/%U/%U/%d#this', NAME_FIRST, NAME_MIDDLE, NAME_LAST, CONTACT_ID, org_id_);
}
}
if (class = 'order')
{
url := sprintf('Order/%d/%U#this', org_id_, oid);
}
}
else if (val like '%/%/view.vsp?sid=%')
{
tmp := sprintf_inverse (val, '%s/%s/view.vsp?sid=%s', 0);
inst := tmp[0];
class := tmp[1];
sid := tmp[2];
org_id_ := (select WAI_ID from DB.DBA.WA_INSTANCE where WAI_NAME = inst);
if (class = 'organization')
{
for (select DNS_ZONE from eCRM.DBA.XSYS_ORGANIZATIONS_DATA where ORG_ID = org_id_) do
{
url := sprintf('OrganizationsData/%d/%U#this', org_id_, DNS_ZONE);
}
}
}
return url;
}
;
DB.DBA.URLREWRITE_CREATE_REGEX_RULE ('ods_ecrm_rdf',
1,
'/dataspace/([^/]*)/eCRM/(.*)',
vector('uname', 'path'),
1,
'/ecrm/%U',
vector('path'),
'DB.DBA.ECRM_DET_REF2',
'application/rdf.xml',
2,
303)
;
DB.DBA.URLREWRITE_CREATE_RULELIST (
'ecrm_rule_list1',
1,
vector (
'ecrm_rule1',
'ecrm_rule2',
'ecrm_rule3',
'ecrm_rdf'
))
;
VHOST_REMOVE (lpath=>'/ecrm');
DB.DBA.VHOST_DEFINE (lpath=>'/ecrm', ppath=>'/DAV/VAD/eCRM/', vsp_user=>'dba', is_dav=>1, def_page=>'sfront.vspx', is_brws=>0, opts=>vector ('url_rewrite', 'ecrm_rule_list1'));
create procedure DB.DBA.LOAD_ECRM_ONTOLOGY_FROM_DAV()
{
declare ses, stat, msg, metas, rset, query, _source any;
metas := NULL; rset := NULL;
stat := '00000'; msg := '';
_source := 'http://www.openlinksw.com/data/turtle/ecrm.ttl' ;
query := sprintf('SPARQL define get:soft "no-sponge" load <%s> into <http://www.openlinksw.com/schemas/eCRMOntology/1.0/>',_source);
exec (query, stat, msg, vector (), 0, metas, rset);
if (stat <> '00000') {
log_message(sprintf ('Load eCRM Ontology: An error occurred %s %s', stat, msg));
};
commit work;
--declare content, urihost varchar;
--select cast (RES_CONTENT as varchar) into content from WS.WS.SYS_DAV_RES where RES_FULL_PATH = '/DAV/VAD/eCRM/ecrm.owl';
--DB.DBA.RDF_LOAD_RDFXML (content, 'http://www.openlinksw.com/ontology/ecrm#', '');
--urihost := cfg_item_value(virtuoso_ini_path(), 'URIQA','DefaultHost');
--if (urihost = 'www.openlinksw.com')
--{
-- DB.DBA.VHOST_REMOVE (lpath=>'/ontology/ecrm');
-- DB.DBA.VHOST_DEFINE (lpath=>'/ontology/ecrm', ppath=>'/DAV/VAD/eCRM/ecrm.owl', vsp_user=>'dba', is_dav=>1, is_brws=>0);
--}
}
;
DB.DBA.LOAD_ECRM_ONTOLOGY_FROM_DAV()
;
drop procedure DB.DBA.LOAD_ECRM_ONTOLOGY_FROM_DAV
;
XML_SET_NS_DECL ('virt-ecrm', 'http://www.openlinksw.com/ontology/ecrm#', 2)
;
-- Reload the persistent eCRM RDF Views i.e. with persistent RDF Views option -- the inclusion of triggers for updating the Quad Store
create procedure DB.DBA.RELOAD_PERSISTENT_ECRM_RDF_VIEWS()
{
declare ses, stat, msg, metas, rset, query, _host any;
declare _baseGraph, _targetGraph any;
metas := NULL;
rset := NULL;
stat := '00000';
msg := '';
_host := registry_get ('URIQADefaultHost');
_baseGraph := sprintf('http://%s/ecrm',_host);
_targetGraph := sprintf('urn:%s:ecrm',_host);
query := sprintf('SPARQL clear graph <%s>',_targetGraph);
log_enable(3,1);
exec (query, stat, msg, vector (), 0, metas, rset);
if (stat <> '00000') {
log_message(sprintf ('Reload persistent eCRM RDF Views: An error occurred %s %s', stat, msg));
};
commit work;
log_enable(1) ;
RDF_VIEW_SYNC_TO_PHYSICAL (_baseGraph, 0, _targetGraph, 1, 1);
}
;
DB.DBA.RELOAD_PERSISTENT_ECRM_RDF_VIEWS()
;
drop procedure DB.DBA.RELOAD_PERSISTENT_ECRM_RDF_VIEWS
;
Example for Reloading the persistent eCRM RDF Views:
Connected to OpenLink Virtuoso
Driver: 06.04.3132 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> RDF_VIEW_SYNC_TO_PHYSICAL ('http://localhost:8890/ecrm', 1, 'urn:myecrm:data');
STATE MESSAGE
VARCHAR VARCHAR
_______________________________________________________________________________
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is flagged as being edited
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is flagged as being edited
22023 Quad map <http://www.openlinksw.com/schemas/virtrdf#ecrmDemo1> is not used in storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads>
in
signal:(BIF),
__01 => '22023',
__02 => 'Quad map <http://www.openlinksw.com/schemas/virtrdf#ecrmDemo1> is not used in storage <http://www.op' (truncated),
DB.DBA.RDF_QM_DROP_MAPPING([executable]/sparql.sql:10755),
storage => UNAME'http://www.openlinksw.com/schemas/virtrdf#SyncToQuads',
mapname => (ARRAY_OF_POINTER value, tag 193),
<Top Level>,
:0 => UNAME'http://www.openlinksw.com/schemas/virtrdf#SyncToQuads',
:1 => (ARRAY_OF_POINTER value, tag 193)
00000 Reloading built-in metadata, this might fix some errors without accurate reporting that they did exist
00000 Built-in metadata were reloaded
00000 Metadata from system graph are cached in memory-resident JSOs (JavaScript Objects)
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is flagged as being edited
00000 Quad map <http://www.openlinksw.com/schemas/virtrdf#ecrmDemo1> is added to the storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads
>
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is unflagged and can be edited by other transactions
00000 Transaction committed, SPARQL compiler re-configured
00000 4 RDF metadata manipulation operations done
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is flagged as being edited
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is flagged as being edited
22023 Quad map <http://www.openlinksw.com/schemas/virtrdf#ecrmDemo2> is not used in storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads>
in
signal:(BIF),
__01 => '22023',
__02 => 'Quad map <http://www.openlinksw.com/schemas/virtrdf#ecrmDemo2> is not used in storage <http://www.op' (truncated),
DB.DBA.RDF_QM_DROP_MAPPING([executable]/sparql.sql:10755),
storage => UNAME'http://www.openlinksw.com/schemas/virtrdf#SyncToQuads',
mapname => (ARRAY_OF_POINTER value, tag 193),
<Top Level>,
:0 => UNAME'http://www.openlinksw.com/schemas/virtrdf#SyncToQuads',
:1 => (ARRAY_OF_POINTER value, tag 193)
00000 Reloading built-in metadata, this might fix some errors without accurate reporting that they did exist
00000 Built-in metadata were reloaded
00000 Metadata from system graph are cached in memory-resident JSOs (JavaScript Objects)
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is flagged as being edited
00000 Quad map <http://www.openlinksw.com/schemas/virtrdf#ecrmDemo2> is added to the storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads
>
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is unflagged and can be edited by other transactions
00000 Transaction committed, SPARQL compiler re-configured
00000 4 RDF metadata manipulation operations done
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is flagged as being edited
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is flagged as being edited
22023 Quad map <http://www.openlinksw.com/schemas/virtrdf#ecrmDemo3> is not used in storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads>
in
signal:(BIF),
__01 => '22023',
__02 => 'Quad map <http://www.openlinksw.com/schemas/virtrdf#ecrmDemo3> is not used in storage <http://www.op' (truncated),
DB.DBA.RDF_QM_DROP_MAPPING([executable]/sparql.sql:10755),
storage => UNAME'http://www.openlinksw.com/schemas/virtrdf#SyncToQuads',
mapname => (ARRAY_OF_POINTER value, tag 193),
<Top Level>,
:0 => UNAME'http://www.openlinksw.com/schemas/virtrdf#SyncToQuads',
:1 => (ARRAY_OF_POINTER value, tag 193)
00000 Reloading built-in metadata, this might fix some errors without accurate reporting that they did exist
00000 Built-in metadata were reloaded
00000 Metadata from system graph are cached in memory-resident JSOs (JavaScript Objects)
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is flagged as being edited
00000 Quad map <http://www.openlinksw.com/schemas/virtrdf#ecrmDemo3> is added to the storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads
>
00000 Quad storage <http://www.openlinksw.com/schemas/virtrdf#SyncToQuads> is unflagged and can be edited by other transactions
00000 Transaction committed, SPARQL compiler re-configured
00000 4 RDF metadata manipulation operations done
33 Rows. -- 19031 msec.
Related
- RDF_VIEW_SYNC_TO_PHYSICAL function to do triggers on a liked data view and optionally fill the physical graph.