Nested GraphQL request does not work

[ksk-waqs]

Bug report

Describe the bug

If I use an un-nested query, everything works correctly.

System

• Node.js version: 12.18.4
• Yarn Version: 1.22.4
• Strapi version: 3.2.4
• Database: SQLite
• Operating system: Windows 10

Additional context

DMehaffy could reproduce the problem, which is confirmed in this forum topic:
https://forum.strapi.io/t/nested-request-does-not-work/893/4

[derrickmehaffy]

This issue has been mentioned on Strapi Community. There might be relevant details there:

https://forum.strapi.io/t/nested-request-does-not-work/893/5

[nsoticek]

I have the same issue. It is only possible to filter by id. Nested where conditions are not possible.

This throws an error:
query {
listingsCount(where: {city: {name: "Bludesch"}})
}

Error (take a look at the where condition of the query):
"message": "select distinct count(*) as "count" from "listings" left join "immodb"."public"."cities" as "cities_1" on "cities_1"."id" = "listings"."city" where "cities_1"."id" = $1 - ungültige Eingabesyntax für Typ integer: »{"name":"Bludesch"}«",

Is there a workaround?

[nsoticek]

I have the same issue. It is only possible to filter by id. Nested where conditions are not possible.

This throws an error: query { listingsCount(where: {city: {name: "Bludesch"}}) }

Error (take a look at the where condition of the query): "message": "select distinct count(*) as "count" from "listings" left join "immodb"."public"."cities" as "cities_1" on "cities_1"."id" = "listings"."city" where "cities_1"."id" = $1 - ungültige Eingabesyntax für Typ integer: »{"name":"Bludesch"}«",

Is there a workaround?

Found a solution here

[derrickmehaffy]

should not be an issue in Strapi v4 but if others do hit this in v4 let us know.