Bidirectional sync between project board columns and labels

[VannTen]

Problem statement

As a Thoth developer, I would like to be able to filter issues by project board
colum when :

• searching issues
• using the github API
• ...

Ex: gh search issues --project thoth-station/16 --label status:new

High-level Goals

• Issues on a project board searchable by project board column

Proposal description

I think there is some Github Actions which can do the bidirectionnal sync
(update the labels when using the project board UI, update the project board
when modifying the label) with two labels dimension (one for which project, one
for which column), but I didn't investigate for now.

Alternatives

No change.

Acceptance Criteria

• "Project -> labels" sync works
• "labels -> Project" sync works

[sesheta]

@VannTen: This issue is currently awaiting triage.
If a refinement session determines this is a relevant issue, it will accept the issue by applying the
triage/accepted label and provide further guidance.

The triage/accepted label can be added by org members by writing /triage accepted in a comment.

Details

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the kubernetes/test-infra repository.

[VannTen]

/sig devsecops

[goern]

sounds helpful, could you put an hour or so in and figure out if we can do it easily for our repos and [OSG][SCRUM][Project OSG] (view)

@schwesig

[VannTen]

Ok, I'll take a look.

[VannTen]

So, not that easy it would seem. From the github docs (workflows do not support org projects)[ https://docs.github.com/en/actions/using-workflows/events-that-trigger-workflows#project_card] (third note). Beside, I've seen several projects doing one of the sync direction, but not both. So that would need at least some work. I've not checked the new API for beta projects, but it might be relevant. Related #424 /triage needs-information

[VannTen]

@harshad16 Could we pull that into the devsecops project ? Feels relevant.

[VannTen]

Gitlab has issue
boards which do
exactly that.

Regarding the new project version, they don't appear to provide that
functionality either. (might be in the API, but managing that ourselves seems
more trouble than it's worth)

[codificat]

An earlier attempt to implement this using prow: thoth-station/thoth-application#2450

This was only uni-directional (auto-add issues to project boards), and it's not really working though. Oh, and it is only meant to work with the "classic" projects, not the new ones.