Hi Alice

The parameters available for the taxon search are at https://indicia-docs.readthedocs.io/en/ … arch.html. You can then use an option called @extraParams to pass this through to the [species] control, e.g.:

[species]
@extraParams={"min_taxon_rank_sort_order":300}

In our case, the taxon rank for species has sort order set to 300, and higher taxa have a lower value, so this limits the search to species and subspecies only.

Best wishes
John

Hi Alice,

Unless you're running very old iForm code (i.e. several years old) the extraParams code should automatically get merged with the read authorisation, so you don't need to do anything about this in your setup. I've just tested this and it works OK, so something else must be happening.

Have you been able to observe an error in the warehouse logs when trying this? Or use the browser developer tools to check the response from the network request?

Best wishes
John

Hi Alice

It looks like the query isn't broken as such, but the data are wrong so nothing is returned.

Can you run a query against the database:

SELECT count(*) FROM cache_taxon_searchterms WHERE taxon_rank_sort_order>=300 AND allow_data_entry=t;

That should return a count of the names that are associated with species or lower level taxon ranks, so if it returns zero then it's possible that this table is not populated correctly.

You could also try (replace ... with a species name you know should exist):

SELECT taxon_rank_sort_order FROM cache_taxon_searchterms WHERE taxon='...';

Does that return 300?

Similarly the following query should show that the same species is species rank and sort order 300 (in the raw data, rather than the cached data).

select tr.rank, tr.sort_order
from taxa t
join taxon_ranks tr on tr.id=t.taxon_rank_id and tr.deleted=false
where t.taxon='...'

Finally, the last place to look is in the warehouse logs, first setting log_threshold to 4 temporarily (in application/config/config.php). Then run the autocomplete so that it finds no results and you should find the query it ran near the end of the log. That should be useful for diagnosis.

Best wishes
John