I'm working with a GraphQL API and I'm trying to implement a search feature that allows users to search for patients by their first name, last name, or full name. I'm currently using a search condition with the ILIKE operator, but I'm having trouble getting it to work when searching for full names with a space in between, such as "Mary John". Here's an example of the search condition I'm using: { _text: { field: "patient.firstName", op: ILIKE, value: "doe%john" } } This condition is supposed to match a patient whose first name contains "Doe" followed by "John", but it's not returning the expected results. I'm not sure if the GraphQL API I'm working with supports the ILIKE operator with wildcards in the way I'm expecting, or if there's a different approach I should take. Here are my questions: Does the GraphQL API typically support the use of the ILIKE operator with wildcards like % for pattern matching in string fields? If so, what is the correct syntax to perform a search that includes a space, such as searching for a full name "Mary John"? Are there any best practices or alternative approaches for implementing a full name search in GraphQL that can handle spaces and partial matches? Continue reading...
