Allow magnitude filtering in catalogues

Dear Pedro,

The latest release of ESASky allows catalogues to be queried with ADQL (which is based on SQL), via the External Data Centres button. Please note, the catalogues in ESASky can also be queried with ADQL if you select the ESASky TAP, and this new feature also includes all tables in VizieR. I wonder if this now meets your needs for an SQL-like filtering capability? 

Please see this page and the video for details on how to query catalogues with ADQL:  https://www.cosmos.esa.int/web/esdc/esasky-5.0-release

Best regards,

Debbie

Thanks!. 

Pedro

Of course, you are right.. I suspected you were actually asking for numerical sorting, rather than alphanumeric sorting.. I move the ticket to open again and will close it is done.

Thats nice!. I suggest to maintain the issue open util the numeric filtering is implemented.

I wonder if a SQL-like filtering capability can be implemented for sources so advanced queries can be performed.

For example to query based on magnitude:

"mag > 10 AND mag <15 ORDERED BY Name DEC"

Thanks !

Currently you can order any columns numerically by clicking on the column headers. Version 2.0 of ESASky, to be released on the 24th of October of 2017, will also have filtering capability in columns although it will be only text-based, but your request to do arithmetic filtering is in the list and will get higher priority thanks to your request.

We will let you know when it is implemented..