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 fovx<= " + x + " and fovx+cdelt1 >=" + x +" and fovy <=" + y + " and fovy + cdelt2 >= " + 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 fovx<= " + x + " and fovx+cdelt1 >=" + x +" and fovy <=" + y + " and fovy + cdelt2 >= " + 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)