Sort 1000 fastest CMEs from a given list according to their pa_width (measured visible angle).

None

sqlfrom="( select * from "+ cme_list +" order by v limit 1000) as tab1  group by width";

Name	Type	Description
SQLSelect	wsdl	Wsdl http://msslkz.mssl.ucl.ac.uk/helio_hec/HelioTavernaService?wsdl Wsdl Operation SQLSelect
SQLSelect_sql_select	xmlsplitter
ORDER_BY_value	stringconstant	Value width
WHAT_value	stringconstant	Value CAST(round(CAST(pa_width as numeric),-1) as int) as width, count(1) as count
construct_from	beanshell	Script sqlfrom="( select * from "+ cme_list +" order by v limit 1000) as tab1 group by width";

Source	Sink
SQLSelect_sql_select:output	SQLSelect:sql_select
ORDER_BY_value:value	SQLSelect_sql_select:ORDER_BY
WHAT_value:value	SQLSelect_sql_select:WHAT
construct_from:sqlfrom	SQLSelect_sql_select:FROM
cme_list	construct_from:cme_list
SQLSelect:response	SQLSelect_response

Reviews (0)