Ash FrameworkAF
Ash Framework7mo ago
9 replies
Vahagn

AshGraphQL or query does not parse to correct sql

query: SELECT d0."id", d0."user_id" FROM "doctors" AS d0 LEFT OUTER JOIN "public"."users" AS u1 ON d0."user_id" = u1."id" WHERE (ash_elixir_or(u1."id"::uuid, ARRAY[$1,$2]::uuid)) AND (d0."entity_id"::uuid = $3::uuid::uuid) ORDER BY d0."id" LIMIT $4

this log is from a query
    query Doctors($query: String!) {
        doctors(filter: { user: { or: [{ firstName: { like: $query } }, { lastName: { like: $query }}] }}) {
            results {
                user {
                    firstName
                    lastName
                    phone
                    picture {
                        id
                        url
                    }
                }
            }
        }
    }


* ** (Postgrex.Error) ERROR 42846 (cannot_coerce) cannot cast type text[] to uuid
Was this page helpful?