New query for group-level dependency list page sorting by 'license'
Why are we doing this work
Following !154054 (merged), we need to implement sorting by license so that we can support all the existing dependency list functionality. Since licenses are currently stored in a JSON array, we need to add a primary_license_id
1 column in order to facilitate this.
Implementation plan
closedno longer relevant Add primary_license_xid
column
- Add
primary_license_xid TEXT
column tosbom_occurrences
- During ingestion, set this to the SPDX ID of the first license
workflowin dev Sort by primary_license_xid
- Add a composite index on
(traversal_ids, primary_license_xid, component_id, component_version_id)
. - Map
'license' => :primary_license_xid
inGroups::DependenciesController
. - Add
:primary_license_xid
toSUPPORTED_SORT_COLUMNS
inAggregationsFinder
- Update specs
Edited by Michael Becker