search

AllenInstitute / biofile-finder

An open-use web application created for easy access, collaboration, and sharing of datasets through rich metadata search, filter, sort, and direct viewing in common industry applications or in our web-based 3D Volume Viewer.
https://biofile-finder.allencell.org/
BSD 3-Clause "New" or "Revised" License
3 stars 1 forks source link

Only add where clause when applicable #299

Closed SeanLeRoy closed 1 month ago

SeanLeRoy commented 1 month ago

This was trying to create a where clause even when there was no actual clause to insert thereby creating a SQL error preventing Antoine from download a .csv

Resolves #298

kmitcham commented 1 month ago

A hack I've used before for constructed SQL is to start the WHERE with WHERE TRUE- then all the added useful clauses have the same 'AND' syntax, making it a little simpler to write.