retrieve_data_for_all_instruments_for_events_during_a_time_spanHEC_stop_date00 2008-03-20 23:59:00 2010-04-16 13:34:51.593 BST stop date time for the query; format YYYY-MM-dd hh:mm:ss 2010-04-16 13:35:34.890 BST HEC_start_date00 start date for the query format YYYY-MM-dd hh:mm:ss 2010-04-16 13:34:02.796 BST 2008-03-10 01:00:00 2010-04-16 13:34:29.531 BST HEC_table00 which table should be qeried; see http://hec.ts.astro.it/sec_ui.php for a list of possible tables 2010-04-16 13:58:01.875 BST goes_xray_flare 2010-04-16 13:41:18.687 BST which table should be qeried 2010-04-16 13:36:04.640 BST which table should be qeried; see http://hec.ts.astro.it/sec_ui.php for documentation 2010-04-16 13:40:28.968 BST dpas_queryReturnsqlparameters0parameters00net.sf.taverna.t2.activitieswsdl-activity1.1net.sf.taverna.t2.activities.wsdl.WSDLActivity http://helio.oato.inaf.it:8080/HECService/HECService?WSDL sql net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.5 1000 5000 10 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokesql_inputarg00output00net.sf.taverna.t2.activitieswsdl-activity1.1net.sf.taverna.t2.activities.wsdl.xmlsplitter.XMLInputSplitterActivity <s:extensions xmlns:s="http://org.embl.ebi.escience/xscufl/0.1alpha"><s:complextype optional="false" unbounded="false" typename="sql" name="parameters" qname="{http://service.hec/}sql"><s:elements><s:basetype optional="true" unbounded="false" typename="string" name="arg0" qname="sql&gt;arg0" /></s:elements></s:complextype></s:extensions> false arg0 0 'text/plain' 0 output 0 'text/xml' net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.5 1000 5000 10 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokesql_basevalue00net.sf.taverna.t2.activitiesstringconstant-activity1.1net.sf.taverna.t2.activities.stringconstant.StringConstantActivity SELECT * FROM %table% WHERE time_start>='%start_date%' AND time_start<'%stop_date%' ORDER BY ntime_start; net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.5 1000 5000 10 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokecombine_sql_querysql_base0stop_date0start_date0table0sql_string00net.sf.taverna.t2.activitiesbeanshell-activity1.1net.sf.taverna.t2.activities.beanshell.BeanshellActivity workflow java.lang.String true start_date 0 text/plain java.lang.String true stop_date 0 text/plain java.lang.String true sql_base 0 text/plain java.lang.String true table 0 text/plain 0 sql_string 0 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.5 1000 5000 10 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokesql_outputinput0return00net.sf.taverna.t2.activitieswsdl-activity1.1net.sf.taverna.t2.activities.wsdl.xmlsplitter.XMLOutputSplitterActivity <s:extensions xmlns:s="http://org.embl.ebi.escience/xscufl/0.1alpha"><s:complextype optional="false" unbounded="false" typename="sqlResponse" name="parameters" qname="{http://service.hec/}sqlResponse"><s:elements><s:basetype optional="true" unbounded="false" typename="string" name="return" qname="sqlResponse&gt;return" /></s:elements></s:complextype></s:extensions> java.lang.String false input 0 'text/xml' 0 return 0 'text/plain' net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.5 1000 5000 10 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokegetAllIventDatesvoTable0endDates11startDates11net.sf.taverna.t2.activitiesbeanshell-activity1.1net.sf.taverna.t2.activities.beanshell.BeanshellActivity workflow java.lang.String true voTable 0 text/plain 1 startDates 1 1 endDates 1 1 positions 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.5 1000 5000 10 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokegetInstrumentsparameters00net.sf.taverna.t2.activitieswsdl-activity1.1net.sf.taverna.t2.activities.wsdl.WSDLActivity http://helio.i4ds.technik.fhnw.ch:8080/HelioDPAS-R1/services/QueryService?wsdl getInstruments net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokegetInstruments_outputinput0getInstrumentsReturn00net.sf.taverna.t2.activitieswsdl-activity1.1net.sf.taverna.t2.activities.wsdl.xmlsplitter.XMLOutputSplitterActivity <s:extensions xmlns:s="http://org.embl.ebi.escience/xscufl/0.1alpha"><s:complextype optional="false" unbounded="false" typename="getInstrumentsResponse" name="parameters" qname="{http://controller.dpas.helio.i4ds.ie}getInstrumentsResponse"><s:elements><s:basetype optional="false" unbounded="false" typename="string" name="getInstrumentsReturn" qname="{http://controller.dpas.helio.i4ds.ie}&gt;getInstrumentsResponse&gt;getInstrumentsReturn" /></s:elements></s:complextype></s:extensions> java.lang.String false input 0 'text/xml' 0 getInstrumentsReturn 0 'text/plain' net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokecommavalue00net.sf.taverna.t2.activitiesstringconstant-activity1.1net.sf.taverna.t2.activities.stringconstant.StringConstantActivity , net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeSplit_string_into_string_list_by_regular_expression_2regex0string0split11net.sf.taverna.t2.activitieslocalworker-activity1.1net.sf.taverna.t2.activities.localworker.LocalworkerActivity org.embl.ebi.escience.scuflworkers.java.SplitByRegex workflow java.lang.String true string 0 'text/plain' java.lang.String true regex 0 'text/plain' 1 split 1 l('text/plain') net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokequeryparameters0parameters00net.sf.taverna.t2.activitieswsdl-activity1.1net.sf.taverna.t2.activities.wsdl.WSDLActivity http://helio.i4ds.technik.fhnw.ch:8080/HelioDPAS-R1/services/QueryService?wsdl query net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokequery_inputinstruments1stopTimes1startTimes1output00net.sf.taverna.t2.activitieswsdl-activity1.1net.sf.taverna.t2.activities.wsdl.xmlsplitter.XMLInputSplitterActivity <s:extensions xmlns:s="http://org.embl.ebi.escience/xscufl/0.1alpha"><s:complextype optional="false" unbounded="false" typename="query" name="parameters" qname="{http://controller.dpas.helio.i4ds.ie}query"><s:elements><s:arraytype optional="false" unbounded="true" wrapped="false" typename="string" name="instruments" qname="{http://controller.dpas.helio.i4ds.ie}&gt;query&gt;instruments"><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="startTimes" qname="{http://controller.dpas.helio.i4ds.ie}&gt;query&gt;startTimes"><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="stopTimes" qname="{http://controller.dpas.helio.i4ds.ie}&gt;query&gt;stopTimes"><s:elementtype><s:basetype optional="false" unbounded="false" typename="string" name="" qname="{http://www.w3.org/2001/XMLSchema}string" /></s:elementtype></s:arraytype></s:elements></s:complextype></s:extensions> false instruments 1 l('text/plain') false startTimes 1 l('text/plain') false stopTimes 1 l('text/plain') 0 output 0 'text/xml' net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokequery_outputinput0queryReturn00net.sf.taverna.t2.activitieswsdl-activity1.1net.sf.taverna.t2.activities.wsdl.xmlsplitter.XMLOutputSplitterActivity <s:extensions xmlns:s="http://org.embl.ebi.escience/xscufl/0.1alpha"><s:complextype optional="false" unbounded="false" typename="queryResponse" name="parameters" qname="{http://controller.dpas.helio.i4ds.ie}queryResponse"><s:elements><s:basetype optional="false" unbounded="false" typename="string" name="queryReturn" qname="{http://controller.dpas.helio.i4ds.ie}&gt;queryResponse&gt;queryReturn" /></s:elements></s:complextype></s:extensions> java.lang.String false input 0 'text/xml' 0 queryReturn 0 'text/plain' net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeCreateInputListsinstruments1startDates1stopDates1instrumentsOut11stopOut11startOut11net.sf.taverna.t2.activitiesbeanshell-activity1.1net.sf.taverna.t2.activities.beanshell.BeanshellActivity workflow java.lang.String true instruments 1 text/plain java.lang.String true startDates 1 text/plain java.lang.String true stopDates 1 text/plain 1 instrumentsOut 1 1 startOut 1 1 stopOut 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.1net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokesqlparameterssql_inputoutputsql_inputarg0combine_sql_querysql_stringcombine_sql_querysql_basesql_basevaluecombine_sql_querystop_dateHEC_stop_datecombine_sql_querystart_dateHEC_start_datecombine_sql_querytableHEC_tablesql_outputinputsqlparametersgetAllIventDatesvoTablesql_outputreturngetInstruments_outputinputgetInstrumentsparametersSplit_string_into_string_list_by_regular_expression_2regexcommavalueSplit_string_into_string_list_by_regular_expression_2stringgetInstruments_outputgetInstrumentsReturnqueryparametersquery_inputoutputquery_inputinstrumentsCreateInputListsinstrumentsOutquery_inputstopTimesCreateInputListsstopOutquery_inputstartTimesCreateInputListsstartOutquery_outputinputqueryparametersCreateInputListsinstrumentsSplit_string_into_string_list_by_regular_expression_2splitCreateInputListsstartDatesgetAllIventDatesstartDatesCreateInputListsstopDatesgetAllIventDatesendDatesdpas_queryReturnquery_outputqueryReturn retrieve data for all instruments for events during a time span 2010-04-21 10:47:30.968 BST retrive 2010-04-21 10:46:36.921 BST Anja Le Blanc 2010-04-21 10:46:15.546 BST This workflow uses the HEC to retrieve events for a time spane given by the user from a HEC table given by the user as well. It uses all instruments available in the DPAS to retrieve data for the events Output: XML as returned by the DPAS 2010-04-21 11:55:33.984 BST This workflow uses the HEC to retrieve events for a time spane given by the user from a HEC table given by the user as well. It uses all instruments available in the DPAS to retrieve data for the events; empty results are filtered out, the data is combind with the instrument name from which it was measured. Output a list of events with lists of instrument and data values. 2010-04-21 10:52:05.0 BST