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

Advanced Search data filter doesn't work with shared table dataset types #31

Open
cseppan opened this issue Jun 11, 2018 · 0 comments
Open
Labels

Comments

@cseppan
Copy link
Collaborator

cseppan commented Jun 11, 2018

For example, the dataset type Plant Closures (CSV) stores all of its datasets in a single database table. The SQL query constructed by the Advanced Dataset Search needs to limit itself to the correct dataset id.

From DatasetDAO.filter()

String sqlStr = "SELECT * FROM " + this.qualifiedEmissionTableName(ds) + " WHERE " + dataValueFilter + " LIMIT 1;";
@cseppan cseppan added the bug label Dec 20, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant