Field validation builder: relations can't be selected directly

[Dominic-Marcelino]

Preflight Checklist

• I have completed all Troubleshooting Steps.
• I'm on the latest version of Directus.
• There's no other issue that already describes my problem.

Describe the Bug

In order to create some validations and presets we need to compare the value for relational fields.
The builder only allows to select the sub-fields from the relation, but not the field itself.

Example below.

To Reproduce

1. Create two user-roles "role A" and "role B"
2. Open directus_user >> create option for role_A
3. Try to limit the user_creation to users with role_A or role_B
4. The permissions-builder will not let you select the "role" field, but role_id
5. If you select role_id field and enter the ID user of role_a won't be able to create any users (validation fails, needs to be type of object.

Instead we can add the validation manually to the role value and it work's as expected

{
	"_and": [
		{
			"_or": [
				{
					"role": {
						"_eq": "8556537d-450f-4303-92e1-e0a9936f73fc"
					}
				},
			[.......]
	]
}

Errors Shown

No response

What version of Directus are you using?

9.6.0

What version of Node.js are you using?

16.14

What database are you using?

mySql 8

What browser are you using?

Chrome

What operating system are you using?

Mac

How are you deploying Directus?

locally