HEC standard query

Created: 2010-04-16 15:00:50

Download Workflow

calls the HEC web service; inputs are start and stop time, which table should be queried and an optional where clause, as in an SQL statement output is of VOTable format

Preview

Download as scalable diagram (SVG)

Run

Run this Workflow in the Taverna Workbench...

Option 1:

Copy and paste this link into File > 'Open workflow location...'
http://www.myexperiment.org/workflows/1216/download?version=1
[ More Info Expand ]

Workflow Components

Authors (0)

Titles (0)

Descriptions (0)

Dependencies (0)

Inputs (4)

Name	Description
HEC_stop_date	stop date time for the query; format YYYY-MM-dd hh:mm:ss
HEC_start_date	start date for the query format YYYY-MM-dd hh:mm:ss
HEC_sql_where	other restrictions; must be in sql syntacs; depends on requested table structure; for more information see: http://hec.ts.astro.it/sec_ui.php other restrictions; must be in sql syntacs; depends on requested table structure; for more information see: other restrictions; must be in sql syntacs; depends on requested table structure; for more information see:
HEC_table	which table should be qeried; see http://hec.ts.astro.it/sec_ui.php for a list of possible tables which table should be qeried; see http://hec.ts.astro.it/sec_ui.php for documentation which table should be qeried

Processors (5)

Name	Type	Description
sql	wsdl	Wsdl http://helio.oato.inaf.it:8080/HECService/HECService?WSDL Wsdl Operation sql
sql_input	xmlsplitter
sql_base	stringconstant	Value SELECT * FROM %table% WHERE time_start>='%start_date%' AND time_start<'%stop_date%' %goes% ORDER BY ntime_start;
combine_sql_query	beanshell	Script String goes = new String("");sql_string = sql_base.replace("%start_date%",start_date);sql_string = sql_string.replace("%stop_date%",stop_date);sql_string = sql_string.replace("%table%", table);if(sql_where.length() > 0) { goes = goes.concat(" AND "+sql_where);}sql_string = sql_string.replace("%goes%",goes);
sql_output	xmlsplitter

Beanshells (1)

Name	Description	Inputs	Outputs
combine_sql_query		start_date stop_date sql_base sql_where table	sql_string

Outputs (1)

Name	Description
HEC_output	VOTable format

Datalinks (9)

Source	Sink
sql_input:output	sql:parameters
combine_sql_query:sql_string	sql_input:arg0
sql_base:value	combine_sql_query:sql_base
HEC_stop_date	combine_sql_query:stop_date
HEC_start_date	combine_sql_query:start_date
HEC_table	combine_sql_query:table
HEC_sql_where	combine_sql_query:sql_where
sql:parameters	sql_output:input
sql_output:return	HEC_output

Coordinations (0)

Information Workflow Type

Taverna 2

Information Uploader

Anja Le Blanc

Information License

All versions of this Workflow are licensed under:

Information Version 1 (of 1)

Information Credits (0)

(People/Groups)

None

Information Attributions (0)

(Workflows/Files)

None

Information Tags (0)

None

Log in to add Tags

Information Shared with Groups (1)

HELIO

Information Featured In Packs (0)

None

Log in to add to one of your Packs

Information Attributed By (1)

(Workflows/Files)

retrieve data for all instruments for events during a time span

Information Favourited By (0)

No one

Information Statistics

1812 viewings

1565 downloads

[ see breakdown ]

Citations (0)

None

Version History

In chronological order:

HEC standard query

Created by Anja Le Blanc on Friday 16 April 2010 15:00:51 (UTC)

Reviews (0)

No reviews yet

Be the first to review!

Comments (1)

View Timeline

Log in to make a comment

Anja Le Blanc

This workflow is now deprecated. Please use 'simple HEC query' for this functionality.

http://www.myexperiment.org/workflows/1285

Other workflows that use similar services (2)

Taverna 2

Uploader

Anja Le Blanc

find events in xray and radio (7)

Download

instruments: hessiEC, phoenix2 attention: hessi name has changed!

Created: 2010-03-16 | Last updated: 2010-03-16

Credits: Anja Le Blanc

Taverna 2

Uploader

Anja Le Blanc

retrieve data for all instruments for even... (1)

Download

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 DPASThis 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 wi...

Created: 2010-04-21

Credits: Anja Le Blanc

Attributions: DPAS general query HEC standard query Retrieve all data for all instruments for a given periode of time

HEC standard query

Preview

Run

Run this Workflow in the Taverna Workbench...

Workflow Components

Wsdl

Wsdl Operation

Value

Script

Reviews (0)

Comments (1)

Other workflows that use similar services (2)