Check_in_UOC_which_instruments_were_observing_at_a_given_time_period_and_datetime_start00 2000-01-01T00:00:00 2012-03-15 14:21:41.640 GMT time_end00 time end of the time period 2012-03-15 13:56:23.406 GMT 2009-01-02T00:00:00 2012-03-15 13:56:14.0 GMT x00 100 2012-03-15 13:56:53.953 GMT x position on the Sun 2012-03-15 13:56:44.968 GMT y00 y postion on the Sun 2012-03-15 13:57:03.515 GMT 216 2012-03-15 13:57:14.15 GMT VOTable VOTable with observatory_instrument keys 2012-03-15 13:58:03.859 GMT <helio:queryResponse xmlns:helio="http://helio-vo.eu/xml/QueryService/v0.1"><VOTABLE version="1.1" xmlns="http://www.ivoa.net/xml/VOTable/v1.1"> <RESOURCE> <DESCRIPTION>Helio UOC time based query V1.7.2</DESCRIPTION> <INFO name="QUERY_STATUS" value="OK"/> <INFO name="EXECUTED_AT" value="2012-03-15 13:49:08"/> <INFO name="QUERY_STRING">SELECT distinct ii.obsinst_key FROM pointed_instrument as pi inner join instrument_information as ii on pi.instrument_information_table_id = ii.id WHERE time_obs&lt;= '2009-01-02T00:00:00' and time_end&gt;= '2000-01-01T00:00:00' and fovx&lt;= 100 and fovx+cdelt1 &gt;=100 and fovy &lt;=216 and fovy + cdelt2 &gt;= 216 </INFO> <INFO name="QUERY_URL">http://festung1.oats.inaf.it:8080/helio-uoc/HelioQueryService?&amp;WHERE=time_obs&lt;= '2009-01-02T00:00:00' and time_end&gt;= '2000-01-01T00:00:00' and fovx&lt;= 100 and fovx+cdelt1 &gt;=100 and fovy &lt;=216 and fovy + cdelt2 &gt;= 216&amp;FROM=pointed_instrument as pi inner join instrument_information as ii on pi.instrument_information_table_id = ii.id</INFO> <TABLE name="uoc-pointed_instrument as pi inner join instrument_information as ii on pi.instrument_information_table_id = ii.id"> <FIELD arraysize="*" datatype="char" name="obsinst_key"/> <DATA> <TABLEDATA> <TR> <TD>HINODE__EIS</TD> </TR> <TR> <TD>TRACE__TRACE_EUV</TD> </TR> <TR> <TD>TRACE__TRACE_UV</TD> </TR> <TR> <TD>TRACE__TRACE_VIS</TD> </TR> </TABLEDATA> </DATA> </TABLE> </RESOURCE> </VOTABLE> </helio:queryResponse> 2012-03-15 13:57:38.453 GMT UOC_sqlsql_select0response00net.sf.taverna.t2.activitieswsdl-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.wsdl.WSDLActivity http://festung1.oats.inaf.it:8080/helio-uoc/HelioTavernaService?wsdl SQLSelect net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 3 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeSQLSelect_sql_selectFROM1WHAT1WHERE0output00net.sf.taverna.t2.activitieswsdl-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.wsdl.xmlsplitter.XMLInputSplitterActivity WHAT 1 l('text/plain') false FROM 1 l('text/plain') false WHERE 0 'text/plain' false ORDER_BY 0 'text/plain' false LIMIT 0 'text/plain' false OFFSET 0 'text/plain' false output 0 'text/xml' 0 <s:extensions xmlns:s="http://org.embl.ebi.escience/xscufl/0.1alpha"><s:complextype optional="false" unbounded="false" typename="SQLSelect" name="sql_select" qname="{http://helio-vo.eu/xml/QueryService/v0.1}SQLSelect"><s:elements><s:arraytype optional="true" unbounded="true" wrapped="false" typename="string" name="WHAT" qname="SQLSelect&gt;WHAT"><s:elementtype><s:basetype optional="false" unbounded="false" typename="string" name="" qname="{http://www.w3.org/2001/XMLSchema}string" /></s:elementtype></s:arraytype><s:arraytype optional="false" unbounded="true" wrapped="false" typename="string" name="FROM" qname="SQLSelect&gt;FROM"><s:elementtype><s:basetype optional="false" unbounded="false" typename="string" name="" qname="{http://www.w3.org/2001/XMLSchema}string" /></s:elementtype></s:arraytype><s:basetype optional="true" unbounded="false" typename="string" name="WHERE" qname="SQLSelect&gt;WHERE" /><s:basetype optional="true" unbounded="false" typename="string" name="ORDER_BY" qname="SQLSelect&gt;ORDER_BY" /><s:basetype optional="true" unbounded="false" typename="int" name="LIMIT" qname="SQLSelect&gt;LIMIT" /><s:basetype optional="true" unbounded="false" typename="int" name="OFFSET" qname="SQLSelect&gt;OFFSET" /></s:elements></s:complextype></s:extensions> net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeFROM_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.stringconstant.StringConstantActivity pointed_instrument as pi inner join instrument_information as ii on pi.instrument_information_table_id = ii.id net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeWHAT_valuevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.stringconstant.StringConstantActivity distinct ii.obsinst_key net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeUOC_wheretime_end0time_start0x0y0where_string00net.sf.taverna.t2.activitiesbeanshell-activity1.3-SNAPSHOTnet.sf.taverna.t2.activities.beanshell.BeanshellActivity time_start 0 text/plain java.lang.String true time_end 0 text/plain java.lang.String true x 0 text/plain java.lang.String true y 0 text/plain java.lang.String true where_string 0 0 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3-SNAPSHOTnet.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeUOC_sqlsql_selectSQLSelect_sql_selectoutputSQLSelect_sql_selectFROMFROM_valuevalueSQLSelect_sql_selectWHATWHAT_valuevalueSQLSelect_sql_selectWHEREUOC_wherewhere_stringUOC_wheretime_endtime_endUOC_wheretime_starttime_startUOC_wherexxUOC_whereyyVOTableUOC_sqlresponse 4d13f03f-02d5-49b0-a7b8-e5e126cc8c59 2012-03-15 14:21:43.375 GMT 8cbd804a-db13-4d12-92f8-8a8949ab8f23 2012-03-15 13:34:27.156 GMT b5d2548c-8895-43e8-b578-fe61cf89ccb6 2012-03-15 13:57:17.609 GMT Check in UOC which instruments were observing at a given time period and date 2012-03-15 13:54:13.875 GMT b00107ba-6684-423a-a9b2-a55e78132e0e 2012-03-15 13:46:01.921 GMT 4ee09dfd-bc58-435f-9f6f-5cc545f33ff1 2012-03-15 11:55:22.93 GMT 58217367-9cce-4bbe-8caf-b337d5eff3ed 2012-03-15 13:44:59.453 GMT 2d20f1b5-2a18-4dbe-8f98-0b46ad364601 2012-03-15 14:20:23.921 GMT 81b60cfe-e4c2-4367-9412-e8211b50f80f 2012-03-15 11:54:31.875 GMT ef0ceeb6-bc4c-467b-bb19-49c29aca1cac 2012-03-15 16:00:40.406 GMT Anja Le Blanc 2012-03-15 13:52:39.437 GMT fe13d11c-8c33-4b18-b316-915b161f2870 2012-03-15 14:22:01.218 GMT cb85cb88-3611-4be9-a60b-8df8c7ee880f 2012-03-15 13:42:50.828 GMT Query of the UOC to find the instrument_observatory keys for instruments which were observing at a given time period and a given location. 2012-03-15 13:54:52.343 GMT 91e9c9fd-5f9c-4e2f-b7b6-2a269ad52713 2012-03-15 13:43:34.0 GMT 7cc91702-7187-4f4b-a2ae-e2df192cbef6 2012-03-15 13:58:03.953 GMT