tool: QUERYTOOL
query: Executed process of a Clinical study  --> sql
Note: Lists all executed process associated to a clinical study.
SELECT a1.PropertyValue, OPMProcess.OPMProcessStartTime,OPMProcess.OPMProcessEndTime  FROM OPMProcess, OPMEntity, OPMGraph, OPMAnnotation, OPMAnnotation as a1, Property, Property as p1
WHERE OPMProcess.OPMProcessKey = OPMEntity.OPMEntityKey and OPMEntity.OPMGraphKey = OPMGraph.OPMGraphKey and 
 	  OPMAnnotation.OPMSubjectKey = OPMGraph.OPMGraphKey and OPMAnnotation.PropertyKey = Property.PropertyKey and 
	  Property.PropertyId = 'http://www.doc.ic.ac.uk/~rdanger/transform_ontologies/OPMSoftwareProfile.owl#idProject' and
	  OPMAnnotation.PropertyValue = '@CLINICAL_STUDY@' and
	  a1.OPMSubjectKey = OPMProcess.OPMProcessKey and a1.PropertyKey = p1.PropertyKey and
	  p1.PropertyId = 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type'

tool: QUERYTOOL
squery: Authentication Certificates by process
options(Date format): Until, From-Until, From
query: Authentication Certificates by process (until a given date)  --> sparql
Note: This query will list references to all SAML authentication certificates for logins that were recorded in a specified time period.</br></br>Date: Date parameter in YYYY-MM-DD format (e.g. 2011-12-31)
select ?p ?id ?d ?authentCertif
where{
    ?p rdf:type opmv:Process .
	?authentCertif opmo:wasGeneratedBy ?p .
	?authentCertif rdf:type <file:///homes/rdanger/ontologies/OPMSoftwareProfile/OPMSoftwareProfile.owl#SAMLAssertion> .
	?p <http://openprovenance.org/dprovenance/example#processEndTime> ?d .
	FILTER ( ?d < "@DATE@T00:00:00Z"^^xsd:dateTime ) .
}

tool: QUERYTOOL
query: Authentication Certificates by process (between two given dates)  --> sparql
Note: This query will list references to all SAML authentication certificates for processes that were recorded in a specified time period.</br></br>Date1: First date parameter in YYYY-MM-DD format (e.g. 2011-12-31)</br></br>Date1: Second date parameter in YYYY-MM-DD format (e.g. 2011-12-31)
select ?proc ?id ?date ?authentCertif 
where{
	 ?proc rdf:type opmv:Process .
	 ?authentCertif opmo:wasGeneratedBy ?proc .
	 ?authentCertif rdf:type <file:///homes/rdanger/ontologies/OPMSoftwareProfile/OPMSoftwareProfile.owl#SAMLAssertion> .
	 ?proc <http://openprovenance.org/dprovenance/example#processEndTime> ?date .
	 FILTER ( ?date > "@DATE1@T00:00:00Z"^^xsd:dateTime and 
	          ?date < "@DATE2@T00:00:00Z"^^xsd:dateTime ) .
}

tool: QUERYTOOL
query: Authentication Certificates by process (from a given date)  --> sparql
Note: This query will list references to all SAML authentication certificates for processes that were recorded in a specified time period.</br></br>Date: Date parameter in YYYY-MM-DD format (e.g. 2011-12-31)
select ?proc ?id ?date ?authentCertif 
where{
    ?proc rdf:type opmv:Process .
	?authentCertif opmo:wasGeneratedBy ?proc .
	?authentCertif rdf:type <file:///homes/rdanger/ontologies/OPMSoftwareProfile/OPMSoftwareProfile.owl#SAMLAssertion> .
	?proc <http://openprovenance.org/dprovenance/example#processEndTime> ?date .
	FILTER ( ?date > "@DATE@T00:00:00Z"^^xsd:dateTime ) .
}

tool: QUERYTOOL
query: Eligible patients for query  --> sparql
Note: Lists the queries together with the number of eligible patients found.
select ?EC ?nPatients
where{
	?p rdf:type <file:///homes/rdanger/ontologies/rcto/v2.0/rcto.owl#ClinicalStudyEligibilityCriteriaQueryProcess> .
	?result opmo:wasGeneratedBy ?p .
	?p opmo:used ?EC .
	?EC rdf:type <file:///homes/rdanger/ontologies/rcto/v2.0/rcto.owl#ClinicalStudyEligibilityCriteria> .
	?result <file:///homes/rdanger/ontologies/OPMSoftwareProfile/OPMSoftwareProfile.owl#firstRowQueryResult> ?nPatients .
}
		
tool: QUERYTOOL
query: Average times for creating eligibility criteria -->sql
Note: This query calculates the total average time spent on creating eligibility criteria in various studies. The total time is simply the duration between the first and last recording time for all criteria in the study. </br>
select ann.PropertyValue as Label, OPMEntity.OPMGraphKey as ProcessID, sum( OPMProcess.OPMProcessEndTime - OPMProcess.OPMProcessStartTime ) as Duration
from Property, Property prop, OPMProcess, OPMGraph, OPMEntity, OPMAnnotation, OPMAnnotation ann 
where OPMEntity.OPMGraphKey = OPMGraph.OPMGraphKey and  OPMEntity.OPMEntityKey=OPMProcessKey and  
OPMProcess.OPMProcessKey = OPMAnnotation.OPMSubjectKey and  
OPMAnnotation.PropertyKey = Property.propertyKey and  
Property.propertyKey = 6 and  
OPMAnnotation.PropertyValue LIKE '%ClinicalStudyEligibilityCriteriaEditionProcess' and  ann.PropertyKey=prop.PropertyKey and  ann.OPMSubjectKey=OPMGraph.OPMGraphKey and  prop.PropertyKey =1 and  OPMProcess.OPMProcessEndTime is not null and OPMProcess.OPMProcessStartTime is not null 
group by OPMGraph.OPMGraphKey

tool: QUERYTOOL
query: Study activity on a specific date --> sparql
Note: Listing of all processes that occurred on a specific date in relation to the given study.</br></br>ClinStudyId: Reference to the clinical study requested.
select ?p ?id ?e ?v
where{
	?p rdf:type opmv:Process .
	?p <http://openprovenance.org/dprovenance/example#value> ?id .
	?p (opmo:used|opmo:wasGeneratedBy|opmo:wasControlledBy|opmo:wasTriggeredBy|opmo:wasGeneratedFrom)* ?e .
	?e <http://openprovenance.org/dprovenance/example#value> "@ClinStudyId@"^^xsd:string ." +
}

tool: DATAQUALITYTOOL
query: Executed process -->sql
Note: List all processes executed in the data quality tool. </br>
SELECT a1.PropertyValue, OPMEntityAnnotationTime FROM OPMProcess, OPMEntity, OPMGraph, OPMAnnotation, OPMAnnotation as a1, Property, Property as p1 
WHERE OPMProcess.OPMProcessKey = OPMEntity.OPMEntityKey and OPMEntity.OPMGraphKey = OPMGraph.OPMGraphKey and  OPMAnnotation.OPMSubjectKey = OPMGraph.OPMGraphKey and OPMAnnotation.PropertyKey = Property.PropertyKey and Property.PropertyId = 'http://www.doc.ic.ac.uk/~rdanger/transform_ontologies/OPMSoftwareProfile.owl#idProject' and OPMAnnotation.PropertyValue = 'DataQualityTool ' and a1.OPMSubjectKey = OPMProcess.OPMProcessKey and a1.PropertyKey = p1.PropertyKey and p1.PropertyId = 'http://www.w3.org/1999/02/22-rdf-syntax-ns#type' 
LIMIT 20

tool: 
query: Details of an entity -->sparql
select ?prop ?e
where{
	@entityURI@ ?prop ?e .
}