Bugfix: Left join to creators for in progress query #77

	name: Pull Request CI

	on:
	pull_request:
	branches:
	- main
	workflow_dispatch: # Allows you to run this workflow manually from the Actions tab

	jobs:
	ci:
	name: "CI"
	runs-on: ubuntu-latest
	steps:
	- name: Setup PHP
	id: setup-php
	uses: shivammathur/setup-php@v2
	with:
	php-version: "8.3"

	- name: Checkout repo
	uses: actions/checkout@v3

	- name: Copy .env
	run: cp .env.example .env

	- name: Install node modules
	run: npm install

	- name: Prettier
	run: npm run format:check

	- name: Frontend build
	run: npm run build

	- name: Install composer dependencies
	run: composer install -q --no-ansi --no-interaction --no-scripts --no-suggest --no-progress --prefer-dist

	- name: Pint
	run: ./vendor/bin/pint --test

	- name: Generate key
	run: php artisan key:generate

	- name: Execute tests
	run: php artisan test

	services:
	postgres:
	image: postgres
	env:
	POSTGRES_USER: root
	POSTGRES_PASSWORD: password
	POSTGRES_DB: laravel
	ports:
	- 5432:5432
	options: >-
	--health-cmd pg_isready
	--health-interval 10s
	--health-timeout 5s
	--health-retries 5

Provide feedback