replace joins with select #1273

	# This workflow will build a Java project with Maven
	# For more information see: https://help.github.com/actions/language-and-framework-guides/building-and-testing-java-with-maven

	name: Java CI with Maven

	on:
	push:
	branches:
	- master
	- v2
	- v2.2
	pull_request:
	branches:
	- master
	- v2
	- v2.2

	jobs:
	run-unit-tests:

	runs-on: ubuntu-latest

	steps:
	- uses: actions/checkout@v2
	with:
	submodules: recursive

	- name: Set up JDK 11
	uses: actions/setup-java@v1
	with:
	java-version: 11

	- name: Create multimedia dir
	run: sudo mkdir -p /opt/multimedia/patient_images && id

	- name: Grant read and write permissions to multimedia directory
	run: sudo chmod a+rwx /opt/multimedia/patient_images

	- name: Run Unit tests with Maven
	run: mvn -B clean test jacoco:report --file pom.xml --no-transfer-progress

	- name: Set Branch name Environment variable
	env:
	BRANCH_NAME_OR_REF: ${{ github.head_ref \|\| github.ref }}
	run: echo "BRANCH_NAME=${BRANCH_NAME_OR_REF#refs/heads/}" >> $GITHUB_ENV

	- name: Set PR Number Environment variable
	run: \|
	echo "PR_NUMBER=$(jq --raw-output .pull_request.number "$GITHUB_EVENT_PATH")" >> $GITHUB_ENV

	- name: Upload coveralls report
	env:
	COVERALLS_REPO_TOKEN: ${{ secrets.COVERALLS_TOKEN }}
	run: \|
	mvn -B coveralls:report --file pom.xml \
	--no-transfer-progress \
	-D repoToken="$COVERALLS_REPO_TOKEN" \
	-D serviceName=Github \
	-D branch="$BRANCH_NAME" \
	-D pullRequest="$PR_NUMBER" \

Provide feedback