Collectors are sorted by collectorID, not orderNumber in grid view

[grantfitzsimmons]

The order is the default ordering by collectorID. It should be by orderNumber, as this is the intended use of that field.

select c.CollectorID, c.CollectingEventID, c.OrderNumber, a.LastName, a.FirstName 
from collector c 
join agent a ON c.AgentID = a.AgentID
where c.CollectingEventID = 260;

This conflicts with Specify 6's behavior

https://coldfish-edge.test.specifysystems.org/specify/view/collectingevent/260/

[grantfitzsimmons]

orderNumber increments properly, it just does not display properly.

[grantfitzsimmons]

https://discourse.specifysoftware.org/t/collector-order-in-groups-and-multiple-collectors/1012

Just as Heather reported, in a subview, it displays in the correct order based on the orderNumber.

[maxpatiiuk]

So we just have to make sub views in sp7 use orderNumber instead of id for order for tables that have orderNumber?

[grantfitzsimmons]

Form view in 7 correctly order by orderNumber.
Grid view in 7 does not order based on orderNumber.

Both should use orderNumber to determine priority.

[specifysoftware]

This issue has been mentioned on Specify Community Forum. There might be relevant details there:

https://discourse.specifysoftware.org/t/specify-7-8-7-release-announcement/1079/1