Add a Query Combobox Editor

[grantfitzsimmons]

Is your feature request related to a problem? Please describe.
Editing a query combobox is currently not possible in Specify 7.

Describe the solution you'd like

[grantfitzsimmons]

Requested by Garth at University of Michigan

[grantfitzsimmons]

I've updated the Specify 6 vs. 7 comparison as well to include this capability. I've added you as a requestor for this feature: #1321– it is not currently considered a "dependency" (or necessary to support before moving entirely to Specify 7). Since the display can be controlled by the table format, it simplifies the configuration. Configuring search columns is something we plan to support moving forward.

[bronwyncombs]

Requested Enhancements for this Feature

TypeSearches defines which fields a query combo box searches on and shows in results. I assume this is the back-end of the sp6 qcbx editor and we transferred it to sp7 by including it as an app resource.

Each <typesearch /> includes a standard set of attributes. Many also include HQL statements that further customize the querycbx behavior.

For example,

 <typesearch tableid="10"  name="CollectingEvent" searchfield="stationFieldNumber" displaycols="stationFieldNumber,startDate,loc.localityName,geo.fullName" format="%s; %s; %s; %s" uifieldformatter="" dataobjformatter="" system="true">
        SELECT %s1 FROM CollectingEvent ce LEFT JOIN ce.locality loc LEFT JOIN loc.geography geo JOIN ce.discipline as dsp WHERE dsp.disciplineId = DSPLNID AND %s2 ORDER BY stationFieldNumber
</typesearch>

The HQL was interpreted in Sp6 but is ignored in Sp7.

With the implementation of this feature request, in addition to the abilities shown in the description, it would be greatly appreciated by the community if users can also:

• choose a field to order results by and set asc or desc.
• filter the records that the qcbx can return by a field value (i.e., agentType=Person) or field state (i.e., text1=empty).

Use cases for those enhancements are described on the Speciforum:

1. Ordering results in Taxon qcbx, described in Genus 'hidden' in taxon searches
2. Filtering an agent qcbx so only institutions can be searched/added, described in Picklist as a subsert of a table

Requested by:

Nate Shoobs from OSU
Robyn Drinkwater from RBGE
Heather Cole from AAFC-AAC
Leo Brimblecombe from Queensland Herbarium

Additionally, this would also close discussion #8428