How use @where directive to query by the same data on 3 differents field with orWhere clasule?

[IgorDePaula]

Is your feature request related to a problem? Please describe.

Yes. I would like query the same data in 3 differents fields with OR Where clasule.
I tried this but not work
#831

Describe the solution you'd like

I would like query the same data in 3 differents fields with OR Where clasule.

Describe alternatives you've considered
I tried this but not work

donators(count: Int!, page: Int!, payment_form_id: [Int] @in(key:"payment_form_id"), donator_status_id: [Int]  @in(key:"donator_status_id"), donator_type_id: [Int]  @in(key:"donator_type_id"), shipping_method_id: [Int]  @in(key:"shipping_method_id"), full_name: String @where(operator: "like", clasule:"orWhere", key: "full_name") @where(operator: "like", clasule:"orWhere", key: "document") @where(operator: "like", clasule:"orWhere", key: "email")): [User!]!  @paginate(scopes:["donator"])

[IgorDePaula]

[milewski]

@IgorDePaula wow I know you ... good old MSN time haha

I think the problem in your query is that you mistyped: clause with clasule :P

[IgorDePaula]

@milewski that little world...haha

How I can write my where clasule? I need search the same data in 3 differents fields.

[milewski]

@IgorDePaula I mean, did you try this:

-@where(operator: "like", clasule: "orWhere", key: "email")
+@where(operator: "like", clause: "orWhere", key: "email")

[IgorDePaula]

I'll try.

[IgorDePaula]

=/ I need search the same information in 3 fields of table, but only search in one field, I need specify 3 fields search in schema?

[IgorDePaula]

I change full_name to search field in schema.

I need search the same information in 3 fields: document, full_name and email.
It only search in document and full_name, but not in email field. =/

[IgorDePaula]

How I detected that no search in document too, only full_name, the first clause. =/

[olivernybroe]

Look into the directive whereConstraints.

[olivernybroe]

This question looks more like it belongs on StackOverFlow or our Slack support.