weekly_issue_metrics_json.yml

name: Weekly issue metrics with JSON output
on:
  workflow_dispatch:
  schedule:
    # 2:33 AM every Monday
    - cron: '33 2 * * 1'

permissions:
  issues: write
  pull-requests: read

jobs:
  build:
    name: weekly issue metrics json
    runs-on: ubuntu-latest
    steps:
    - name: Get dates for last week
      shell: bash
      run: |
        # Calculate the first day of the previous week (and as we all know
        # weeks start on Mondays ;))
        first_day=$(date -d "last Sunday - 6 days" +%Y-%m-%d)

        # Calculate the last day of the previous week
        last_day=$(date -d "last Sunday" +%Y-%m-%d)

        #Set an environment variable with the date range
        echo "$first_day..$last_day"
        echo "last_week=$first_day..$last_day" >> "$GITHUB_ENV"

    - name: Run issue-metrics tool
      uses: github/issue-metrics@v2
      env:
        GH_TOKEN: ${{ secrets.GITHUB_TOKEN }}
        SEARCH_QUERY: 'repo:redwoodjs/redwood is:issue created:${{ env.last_week }} -reason:"not planned"'

    - name: Print output of issue metrics tool
      run: |
        cat ./issue_metrics.json
        cat ./issue_metrics.json | jq .total_item_count
        cat ./issue_metrics.json | jq .average_time_to_first_response