solgenomics / sgn

The code behind the Sol Genomics Network, Cassavabase and other Breedbase websites
https://solgenomics.net
MIT License
66 stars 35 forks source link

Histogram tool wont show calculated plot values #4349

Closed ch728 closed 1 year ago

ch728 commented 1 year ago

Histogram tool in the Phenotype Summary Statistics section of /breeders/trial/ wont show calculated plot values. By calculated plot values, I mean that I used the Compute New Phenotypes tool to create plot values from plants. They show up in the summary table, but the histogram tool says "This trait is not numeric, or there are fewer than 3 values. Unable to draw a histogram."

bellerbrock commented 1 year ago

@ch728 Thanks for the report, the cause of the problem is that the histogram tool was accessing the materialized views by default, which take a while to update after new trait values are computed. I've changed the default to do a native search, which should solve the problem.