Fixes #5311, #5073, #3120, #2153, #1515, #584, #364, specify/specify6#1210, specify/specify6#1213, specify/specify6#1229, specify/specify6#1232, #4591, #5020, #2016 and specify/specify6#1223

This PR is intended to update underlying app resources necessary for the geology discipline as well as improve other defaults where possible.

Geo-focused Improvements

CollectionObject form for Geology

Common Views

RelativeAge

Added AbsoluteAge form

Added TectonicUnit form

Added TectonicUnitTreeDef form

Added TectonicUnitTreeDefItem form

Major Improvements

Type Searches

• You can now search for Collection, Institution, and SpecifyUser, improving a number of places around the app!
• Instructions for users modifying this file are now included in the app resource itself

Record Sets

• You can now transfer ownership of a record set to another user!

Agent

• Person is now the default value (huge improvement)
• Only when the Agent is type Group will the members subview display
• Agent Identifiers now displays properly, and subview is included on the default form

Taxon

• Form is now conditional, displaying HybridParent fields only when IsHybrid is checked

Collection Relationships

Old form:

New form:

• Can now easily create a Collection Relationship via the form
• Using the updated TypeSearches, "Collection" can be searched and displayed properly

App Resources

AppResource

Reports

• You can now easily find who owns the query and what the query is named from the app resource editor for a given report or label!
• The Reports subview button only appears when the mimetype is jrxml/label
• New SpReport form for the first time

SpViewSetObj

Pick List

Old form:

New form:

• Removed redundant header
• Now users can remove the pick list limit by setting it to -1

Tree Definition

Old Tree Definition form:

New Tree Definition form:

• Can now change full name direction for all trees

Miscellaneous Improvements

• Preparation countAmt can no longer be set to a negative number by default
• Default form definition files and DataObjFormatters have finally been reformatted by the built-in Specify 7 system
• Removed a number of invalid fields on all default forms
• Updated hard-coded field labels to use schema-assigned captions instead

Testing instructions

THIS MUST BE TESTED LOCALLY UNTIL THE TEST PANEL SUPPORTS STATIC FILES

Okay, so this PR is big, but it is almost entirely XML changes. This touches a lot of the default forms, so I have a big ask– please test the following XML resources in Specify. You are likely to find issues that aren't related to this PR which I am happy to resolve, so report them. If it grows outside the scope of this, I'll open another and we'll resolve it in the future.

Remember to delete any custom form definitions / app resources before testing this as those will be used first.

• Create a new DataObjFormatters app resource and verify that all table formats and aggregations appear as expected
• Build queries and return the (formatted) and (aggregated) results of as many tables as you can, with a focus on new Geo tables. If a table format or aggregation is missing where it should be included, let me know. Some tables (e.g. *property, *attribute, *groupjoin) do not have a table format or aggregation defined as it is ambiguous as to which fields we should display.
• Create a new TypeSearches app resource and verify that it is working as expected. Delete this resource after it is populated as you should be using the default.
• Open the CollectionRelType form and search for a collection. You should be able to type the name of a collection and select it. You will encounter HierarchyException when loading Collectionreltype #4989, but that is not in the scope of this issue, and you can safely dismiss it.
• Create an ExportFeed app resource and verify that you can search for a user in the database by name. You should see the name appear correctly and you should be able to search for a user in the query combo box without the 🔍 QB function.
• Create a new WebLinks app resource and verify that all web links (~5) appear and work as expected. See this guide for setting up a conditional form on AgentIdentifier to leverage those new web links.
• Verify that the geology.views.xml can be used as the basis of a new form (create a new form definition and select Geology). Let me know what you think. This is subjective to some extent, and I welcome suggested changes (especially via XML snippets).

• Test that these new view definitions (mostly shown in this issue's body) are displayed properly (compare to defaults on production):
  • CollectionRelType
    • Verify that you can create a Collection Relationship without the query builder (ignoring this error)
  • Agent should default to Person instead of Organization finally!
    • Agent conditional: If the agent is not a Group, the Members subview should not be shown.
  • TectonicUnit
  • TectonicUnitTreeDef
  • TectonicUnitTreeDefItem
  • TaxonTreeDef
  • Taxon
    • Taxon conditional: Verify that when you check IsHybrid the fields HybridParent1 and HybridParent2 appear. When it is not checked, they should not appear.
  • GeographyTreeDef
  • StroageTreeDef
  • LithoStratTreeDef
  • GeologicTimePeriodTreeDef
  • RelativeAge
  • AbsoluteAge
  • PickList
    • Set the size limit to -1 and verify that you can add any number of pick list items (>500– and you can use the workbench to add the first 500)
  • PickListItem
  • SpAppResource (click pencil next to the title of an app resource)
    • SpAppResource conditional (should show Reports subview button if the resource is a report/label)
      • SpReport form should show ownership, associated query, title, in a read-only view
  • SpViewSetObj (click pencil next to the title of a form definition)
  • SpQuery (click pencil next to a query title)
    • Verify that you can change the ownership of a query
  • RecordSet (click pencil next to a record set title)
    • Verify that you can change the ownership of a record set
  • AgentIdentifier – navigate directly to the form via the data entry menu or by modifying the URL. It should no longer be auto-generated

• Double-check that your testing covers all cases reported in Add support for the Geology discipline and default forms #5311, Support choosing the Full Name Direction in Sp7 tree def editing interface #5073, Enable creating Collection Object Relationships in Specify 7 #3120, deaccessionPreparations is a phantom field #2153, When changing a pick list to read only, it requires a size limit of at least two #1515, GUID and Hybrid Parent fields are editable on the Taxon form #584, Change default forms to hide portions of agents form depending on agent type using conditional forms #364, Stop hard-coding labels into default form XML specify6#1210, Front-end limit on pick list items still in place specify6#1213, Data model class for Taxon Attribute is incorrect specify6#1229, The Accession table does not have a deaccessions field. specify6#1232, bug(default-forms): Form is named AgentIdentifiers, but table is named AgentIdentifier #4591, Visual Export Feed QCBX displays all users as <Formatter not defined.> #5020, Paleocontext should have an accepted field for lithostrat of chronostrat #2016, and common/common.views.xml: PHSub Form: Cell is missing proper closing element /> specify6#1223