Weekly issue metrics with JSON output #4

	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

Provide feedback