Skip to content

ALMA: Cannot select multiple science keywords #2094

@keflavich

Description

@keflavich

I attempted this query:

result = Alma().query(payload={'spatial_resolution':'<0.1', 'science_keyword':
                               ['High-mass star formation',
                                'Disks around high-mass stars']},
                      public=True)

resulting in an exception DALQueryError: ADQL syntax error: Encountered " <S_IDENTIFIER> "High "" at line 1, column 81.

The problem was a malformed ADQL query:

TAP query: select * from ivoa.obscore WHERE spatial_resolution<=0.1 AND science_keyword='['High-mass star formation', 'Disks around high-mass stars']' AND science_observation='T' AND data_rights='Public'

The solution is to do the query correctly, e.g.:

AA.tap.search("select * from ivoa.obscore WHERE spatial_resolution<=0.1 AND science_keyword in ('High-mass star formation', 'Disks around high-mass stars') AND science_observation='T' AND data_rights='Public'")

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions