fix customized formatters

Refactor picklist handling to improve null handling and type coercion…

… when building a case statement for the QB.

chore(changelog): add 7.11.2 release notes

Update CHANGELOG.md

Add changelog update

Resolve business rule

Support whitespaces between Django security variables

Merge pull request #6502 from specify/issue-6488

Don't trigger unload protect when re-opening to-one resource in dialog

Simplify find_tree_and_field

Hotfixes: Fullname query hotfix + catalog number cast hotfix for `7.1…

…0.2` (#6465)

* Handle case where rank name has spaces

* Use name as default tree rank query

* Handle edge case for fullname query

* Use name for fullname

* Skip test temporarily

* Revert mapping for fullname

* Fix case for fullName query with 1 space in rank
- Also adds a unit test to ensure this doesn't break again

* Cast catalogNumber to Numeric in query results if all formats are numeric

Fixes #6464
See related #5485 and #6245

This handles the most common case.
In the case where there exists both numeric and non-numeric formats for
catalogNumber, the numeric formats will still be cast as a string.
This also ONLY works with formats called CatalogNumberNumeric;
i.e., any other purely numeric format will not be considered as numeric
by the QueryBuilder

* Add comment to catalogNumber cast for queries

---------

Co-authored-by: melton-jason <meltonjason12@yahoo.com>