When searching for issues within a project or group, `IssuableFinder`
has an optimization that uses a CTE to filter the list of authorized
issues before searching within the list for text. This CTE optimization
fence is currently only used when the user specifies a simple sorting
parameter, such as `created_at`, and not popularity. These attributes
are generally stored directly with the model, so the CTE can easily do
an `ORDER BY` without joining another table (e.g. `award_emoji` for
popularity).

This commit adds the remaining simple sort attributes (due date,
relative position) the `Issue` class. This should help speed up the
search query and avoid a database statement timeout.

Improves https://gitlab.com/gitlab-org/gitlab/issues/34661

Follow up for retry after import

Closes #199985

See merge request gitlab-org/gitlab!24281

Don't show keep path for non archive artifacts

See merge request gitlab-org/gitlab!23762

Fix a flaky feature spec

Closes #12613

See merge request gitlab-org/gitlab!24278

Non archive artifacts are not keepable so don't return
the keep_path for them.

Use has_expiring_archive_artifacts in BuildArtifactEntity.

Move has_expiring_artifacts to be private.

Preload job_artifacts_archive when loading bunch of pipelines
to avoid N+1 query.

Separate issue entities into own class files

See merge request gitlab-org/gitlab!24226

Document API desc block when released behind a feature flag

See merge request gitlab-org/gitlab!23586

Add mode field to snippet blob in GraphQL

See merge request gitlab-org/gitlab!24157

Fix display logic of Securty Report MR widget

Closes #200017

See merge request gitlab-org/gitlab!24204

The Security Report MR widget was being displayed if _only_ the license
compliance CI job was set up for the project, even though it would not
have any data to display for its report types.

This tightens up that logic, so that it is only displayed when one or
more of the security reports is set up for the project.

Fixes https://gitlab.com/gitlab-org/gitlab/issues/200017.

Fix URL parsing in IDE MRs

See merge request gitlab-org/gitlab!24206

Resolve "Code Review Analytics: Add approvers to table"

Closes #197883

See merge request gitlab-org/gitlab!23345

ide.scss: Use utility classes where possible

See merge request gitlab-org/gitlab!24264

Remove dead code in ide.scss

See merge request gitlab-org/gitlab!24145

Remove a not needed empty line from qa test

See merge request gitlab-org/gitlab!24289

Move approver routes under - scope

See merge request gitlab-org/gitlab!24282

Add suggest pipeline experiment feature flag

See merge request gitlab-org/gitlab!23989

Fix some stylelint issues by using utility classes where possible in
ide.scss

Test EE::Ci::JobArtifact in proper spec

See merge request gitlab-org/gitlab!24179

Web IDE: Fix encoding issues when uploading

See merge request gitlab-org/gitlab!23761

Improvement for branches list API performance

See merge request gitlab-org/gitlab!23458

Use an existing image for testing /help

See merge request gitlab-org/gitlab!24286

Nuget - metadata service endpoints

See merge request gitlab-org/gitlab!22524

1. .file-content has no img, .isZoomable, .isZoomed
2. There is no .multi-file-discard-btn anymore

- this is an incremental overall change and this
  will be the first step in getting the experiment implemented.

Add doc links to Dangerbot to explain reviewer roulette in more detail

See merge request gitlab-org/gitlab!24147

Remove unused utility/support code in License Management

See merge request gitlab-org/gitlab!24200

This removes various utility/support code that was needed during the
existence of the `parsed_license_report` feature flag.

Part of [Remove parsed_license_report flag from front end code][1].

[1]: https://gitlab.com/gitlab-org/gitlab/issues/37271

Remove unneeded indexes on projects table

See merge request gitlab-org/gitlab!24086

Related issue: https://gitlab.com/gitlab-org/gitlab/issues/195881

This removes indexes that we don't need anymore after changing the "tie
breaker" sorting direction. The indexes have been introduced with
https://gitlab.com/gitlab-org/gitlab/merge_requests/22623 to optimally
support the requests. This is not needed anymore since the tie breaker
now also changes its sorting direction.

For more details please refer to
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/22623.

I've validated that these indexes are not being used on GitLab.com
anymore:
https://gitlab.com/gitlab-org/gitlab/issues/195881#note_278816057

docs: Update the location of Go reviewers on Handbook after single codebase

See merge request gitlab-org/gitlab!23732

Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>

Search group-level objects among all ancestors during import

See merge request gitlab-org/gitlab!24079

See https://docs.microsoft.com/en-us/nuget/api/registration-base-url-resource
Add relevant presenters
Add nuget package finder

In spec/controllers/help_controller_spec.rb we test how an image is
rendered under /help. Given that we usually rename images as we
update them, we should use one that remains unchanged.

https://gitlab.com/gitlab-org/gitlab/-/merge_requests/24139 fixed
a failure and introduced a new image. Let's use one that we already
use in the docs and we're unlikely to change its name.

Fix query performance in PipelinesFinder

See merge request gitlab-org/gitlab!21092