Hi team,
We have a requirement to select the vertex based on the vertex id , example , Vertex type Email which stores the email into id field , when user search for the email id , it works fine if we pass exact email id , but when we pass the mail id with one of letter as upper/ lower , it seems like gsql is not fetching the email vertex. It looks like tigergraph is case senstive , so could you please help me how to do the case insenstive search on the id field in the gsql?
In GSQL, you can use the same technique that’s used in other programming languages: convert both to the same case (say, lowercase), then compare.
STRING id_lower = gsql_lower(v.email),
STRING input_lower = gsql_lower(search_parameter),
IF id_lower == input_lower THEN …
In fact, you might want to convert the emails to lowercase when you load them. Then you only need to convert the search parameter when you have a query.