search

biocodellc / geome-ui

MIT License
3 stars 4 forks source link

single sheet download for amphibianDisease #492

Open jdeck88 opened 4 years ago

jdeck88 commented 4 years ago

i thought we cleared this up in a recent issue: run a query at: https://geome-db.org/query?team=45 then download the results... it comes back in 3 tabs... should just be one tab for the AD portal project.

Can you look at this?

albarqmaria commented 4 years ago

OK, so it looks like Queries with multiple projects, such as

https://api.geome-db.org/records/Event/excel?access_token=zxWWaJsqWgTzxeJeN3GD&networkId=1&q=_projects_:292,240+_select_:%5BSample,Diagnostics%5D+

Are returning multiple sheets, but single project queries, such as:

https://api.geome-db.org/records/Event/excel?access_token=zxWWaJsqWgTzxeJeN3GD&networkId=1&q=_projects_:292+_select_:%5BSample,Diagnostics%5D+

are all coming back on the samples sheet as we want them to.

**** EDIT: this is how the API is currently structured. We will need to make a change in the backend to allow for multiple projects data to be downloaded onto a single sheet.