search

quanted / hem_app

django app for the human exposure model
2 stars 0 forks source link

populating chemical drop-down menu #144

Closed kdionisio closed 7 years ago

kdionisio commented 7 years ago

There appears to be a bug in how the chemical drop-down menu is being populated with the list of chemicals. The drop-down menu should be populated with the list of unique chemicals which appear in the hem_app_dose table, which have runparams_id = 1.

So, populate drop down with list of chemicals resulting from the following query:

SELECT DISTINCT chemical_id FROM dev_hem_dave.hem_app_dose WHERE runparams_id=1;

It appears the drop-down is currently being populated with the full set of unique chemicals appearing in the dose table, ie


SELECT DISTINCT chemical_id FROM dev_hem_dave.hem_app_dose
dmlyons2 commented 7 years ago

Still deleting chems, but it is working faster with correct chems