License and project filters do not work when using dependency aggregations
Summary
License and project filters on the dependency list do not work when the rewrite_sbom_occurrences_query
feature flag is enabled.
Steps to reproduce
- Go to the group level dependency list
- Try to filter by project or license
What is the current bug behavior?
We receive same unfiltered results as before.
What is the expected correct behavior?
We should receive results filtered by project or license.
Possible fixes
If it works with current index coverage, then we should just add WHERE sbom_occurrences.licenses -> 0 ->> 'spdx_identifier' = <ID>
onto the
innermost query.