Project Board Migration: refactoring of "Schedule Friday 0700" workflow

[t-will-gillis]

Dependency

• Prep for Project Board Migration: Configure "Automatic workflows" #6995

Overview

Many of our workflows need to be refactored due to the forced migration from the Project Board (classic) to the Project Board- Beta (PBB). This issue addresses changes that we need to make in order to ensure that our "Schedule Friday 0700" workflow works as it did previously.

Action Items

The "Schedule Friday 0700" workflow needs to be refactored to remove references to 'column' and refer instead to the PBB's 'status'.

• In schedule-fri-0700.yml remove the "IN_PROGRESS_COLUMN_ID".
• Then in add-label.js, refactor this file to function on the PBB, referencing 'status' == "In Progress (actively working)" instead of 'column'. The refactoring needs to use GraphQL.

Post migration issues needed:

• Refactor add-label.js to use GraphQL and 'status'.
• Important Note: the GraphQL queries/ operations must be modularized to avoid unnecessary repetition.

Resources/Instructions

• Sunset notice for Projects (classic)
• This issue initiated by Prep for Project Board Migration: GitHub Actions / Workflows Part 1 of 2  #6993

[github-actions]

Hi @t-will-gillis, thank you for taking up this issue! Hfla appreciates you :)

Do let fellow developers know about your:-
i. Availability: (When are you available to work on the issue/answer questions other programmers might have about your issue?)
ii. ETA: (When do you expect this issue to be completed?)

You're awesome!

P.S. - You may not take up another issue until this issue gets merged (or closed). Thanks again :)