Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ALMA: Cannot select multiple science keywords #2094

Closed
keflavich opened this issue Jun 23, 2021 · 0 comments · Fixed by #2457
Closed

ALMA: Cannot select multiple science keywords #2094

keflavich opened this issue Jun 23, 2021 · 0 comments · Fixed by #2457
Labels

Comments

@keflavich
Copy link
Contributor

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'")
@keflavich keflavich added the alma label Jun 23, 2021
at88mph added a commit to at88mph/astroquery that referenced this issue Jul 4, 2022
bsipocz added a commit that referenced this issue Jul 11, 2022
BUG: alma fixes for list of keywords, fixes #2094
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant