How to horizontal filter a json value?

[dnk8n]

e.g. A plain get: GET http://localhost:3000/projects

[
	{
		"id": 3,
		"members": [
			{
				"id": 2,
				"name": "[email protected]"
			}
		],
		"name": "Project Name",
		"activities": [
			{
				"id": 24,
				"name": "Finance"
			}
		],
		"areas_of_work": [
			{
				"id": 4,
				"name": "Observatory"
			}
		]
	}
]

I want to filter where areas_of_work.id == 4

I thought it should be GET http://localhost:3000/projects?areas_of_work-->id=eq.4 but that doesn't work.

Error:

{
	"code": "PGRST100",
	"details": "unexpected \"-\" expecting \">\", letter or digit",
	"hint": null,
	"message": "\"failed to parse tree path (areas_of_work-->id)\" (line 1, column 15)"
}

[laurenceisla]

Hi, it could be done more easily with a jsonb column and the @> operator (cs in PostgREST). You could change the column from a json to jsonb or add a new computed column that casts areas_of_work to jsonb.

Then the request would be:

GET /projects?areas_of_work=cs.[{"id":1}]