Check in UOC which instruments were observing at a given time period and place

None

where_string = "time_obs<= '"+ time_end +"' and time_end>= '" +time_start+"'" +
  " and fovc_x_arcsec-(fovx/2)<= " + x + " and fovc_x_arcsec+(fovx/2) >=" + x +" and fovc_y_arcsec-(fovy/2) <=" + y + " and fovc_y_arcsec+(fovy/2) >= " + y;

Name	Description
time_start
time_end	time end of the time period
x	x position on the Sun
y	y postion on the Sun

Name	Type	Description
UOC_sql	wsdl	Wsdl http://festung1.oats.inaf.it:8080/helio-uoc/HelioTavernaService?wsdl Wsdl Operation SQLSelect
SQLSelect_sql_select	xmlsplitter
FROM_value	stringconstant	Value pointed_instrument as pi inner join instrument_information as ii on pi.instrument_information_table_id = ii.id
WHAT_value	stringconstant	Value distinct ii.obsinst_key
UOC_where	beanshell	Script where_string = "time_obs<= '"+ time_end +"' and time_end>= '" +time_start+"'" + " and fovc_x_arcsec-(fovx/2)<= " + x + " and fovc_x_arcsec+(fovx/2) >=" + x +" and fovc_y_arcsec-(fovy/2) <=" + y + " and fovc_y_arcsec+(fovy/2) >= " + y;

Source	Sink
SQLSelect_sql_select:output	UOC_sql:sql_select
FROM_value:value	SQLSelect_sql_select:FROM
WHAT_value:value	SQLSelect_sql_select:WHAT
UOC_where:where_string	SQLSelect_sql_select:WHERE
time_end	UOC_where:time_end
time_start	UOC_where:time_start
x	UOC_where:x
y	UOC_where:y
UOC_sql:response	VOTable

Check in UOC which instruments were observing at a given time period and place

Preview

Run

Run this Workflow in the Taverna Workbench...

Workflow Components

Wsdl

Wsdl Operation

Value

Value

Script

Reviews (0)

Comments (0)

Other workflows that use similar services (0)