Add order_project_path to package graphql API sort
🔬 What does this MR do?
This MR adds two additional sort options for the package GraphQL API:
PROJECT_PATH_DESC
PROJECT_PATH_ASC
🐘 Database
The new query was reviewed when the scopes were updated here, so no further review should be necessary.
For reference, here is a query using the new sort options and an explain plan: https://explain.depesz.com/s/7wBT
📷 Screenshots (strongly suggested)
Does this MR meet the acceptance criteria?
☑ Conformity
-
I have included a changelog entry, or it's not needed. (Does this MR need a changelog?) -
I have added/updated documentation, or it's not needed. (Is documentation required?) - [-] I have properly separated EE content from FOSS, or this MR is FOSS only. (Where should EE code go?)
-
I have added information for database reviewers in the MR description, or it's not needed. (Does this MR have database related changes?) -
I have self-reviewed this MR per code review guidelines. -
This MR does not harm performance, or I have asked a reviewer to help assess the performance impact. (Merge request performance guidelines) -
I have followed the style guides.
Availability and Testing
-
I have added/updated tests following the Testing Guide, or it's not needed. (Consider all test levels. See the Test Planning Process.) - [-] I have tested this MR in all supported browsers, or it's not needed.
- [-] I have informed the Infrastructure department of a default or new setting change per definition of done, or it's not needed.
Related to #328212 (closed)
Edited by Steve Abrams