🐞 [Bug]: check the node region filter

[Omarabdul3ziz]

What happened?

calling this: https://gridproxy.grid.tf/nodes?country=United%20States returns some nodes
but adding the region filter: https://gridproxy.grid.tf/nodes?country=United%20States&region=Americas returns none, it should not be affected.
also: https://gridproxy.grid.tf/nodes?region=Americas&size=1000 didn't return any united-stated country

this looks with those three countries: United States, United Kingdom, Czechia.

it maybe conflict on the data and the nodes has conflicts on the names: United States of America, United Kingdom of Great Britain and Northern Ireland, Czech Republic

which network/s did you face the problem on?

Main

Twin ID/s

No response

Node ID/s

No response

Farm ID/s

No response

Contract ID/s

No response

Relevant log output

none

[Omarabdul3ziz]

there is already an open issue for the original cause of this on the graphql repo. i commented the findings there threefoldtech/tfchain_graphql#148 (comment)

we can still handle this on the proxy by replacing the exact matching with like

tfgrid-sdk-go/grid-proxy/internal/explorer/db/setup.sql

Line 140 in 8d88cb1

LEFT JOIN country ON LOWER(node.country) = LOWER(country.name)

but i think it is better to be handled from graphql

[Omarabdul3ziz]

the countries names are fixed in the graphql

and the region filter works fine now