Ability to search on linked resources

[themerekat]

Users want to be able to search by the values that are stored in omoccurrassociations. Specifically, they want to search by "host". I think we want to make this functionality even a little more broad so that someone can search for any kind of association. So, I think this is going to be a new section of collections/search/index.php that allows people to search on:

• relationship type (omoccurassociations.relationship)
• relationshipID (not sure if this is necessary, but people could foreseeably want to search this) --> nevermind on this
• scientific name of the linked resource (omoccurassociations.verbatimSciname and/or omoccurassociations.tid)

We probably also want to be able to search on linked resources in the Record Search Form in occurrenceeditor and occurrencetabledisplay, but that's secondary to the ability to search in the public page.

[themerekat]

Example queries

• Give me all the occurrences that are found on Pinus ponderosa. (i.e., "hasHost" and occurrence with a taxonomic name Pinus ponderosa)
• What species (i.e., occurrences) are Scolytinae found on?

Notes:

• When you search on omoccurrences, you'll have to return both occid and occidAssociate values (the relationships AND their inverses)
• Only make this in collections/search/index.php (not harvestparams.php)
• How to display the associations in list.php? Just show when associations exist (icon that people can click?)

[themerekat]

Associated documentation: https://biokic.github.io/symbiota-docs/coll_manager/upload/links/