Closed GoogleCodeExporter closed 9 years ago
Original comment by gtuco.bt...@gmail.com
on 8 Mar 2009 at 3:43
Should be resolved in r1275. Test this.
Original comment by gtuco.bt...@gmail.com
on 19 Mar 2009 at 12:49
Issue not resolve by r1275. Instead, this requires a more elaborate solution. I
believe the one way to do this would to require the ScientificName for a valid
record. There would need to be a new validation test for this, and a new error
message. The Error type list box in simple search would then have to contain
ScientificName as well.
A better solution (one with less impact on development and on the requirements
placed
on the user) is to create and populate ScientificName on upload if it isn't
already
populated. Here's how:
If ScientificName is empty or null, construct ScientificName as
if(genus==null){
if(family==null){
if(order==null){
if(class==null){
if(phylum==null){
if(kingdom==null) ScientificName="unidentified";
else ScientificName=kingdom;
}else ScientificName=phylum;
}else ScientificName=class;
}else ScientificName=order;
}else ScientificName=family;
}else{
if(SpecificEpithet==null) genus;
else{
if(InfraspecificEpithet==null) ScientificName=genus+" "+SpecificEpithet;
else ScientificName=Genus+" "+SpecificEpithet+" "+InfraspecificEpithet;
}
}
Then, need to add "or ScientificName equals" to the simple search algorithm.
So, the new simple search algorithm would be:
1) select blah where AcceptedSpecies='x' or VerbatimSpecies="x" or
ScientificName="x"
2) if no results from 1) select blah where AcceptedSpecies like 'x%' or
VerbatimSpecies like "x%" or ScientificName like "x%"
3) if no results from 2) blah where AcceptedSpecies like '%x%' or
VerbatimSpecies
like "%x%" or ScientificName like "%x%"
Original comment by gtuco.bt...@gmail.com
on 24 Mar 2009 at 6:41
Original comment by gtuco.bt...@gmail.com
on 24 Mar 2009 at 8:31
Original comment by gtuco.bt...@gmail.com
on 24 Mar 2009 at 9:41
Original issue reported on code.google.com by
eightyst...@gmail.com
on 12 Nov 2008 at 7:39