AnsweredAssumed Answered

peform jdbc with case inscensitive

Question asked by PopleysYsb on Feb 27, 2019
Latest reply on Mar 12, 2019 by Mark_HE

Hi There,am using following query which is getting failed,essentially if receive in the request the capital letter i want to convert in to lower case search. I tried with the below which is failing.Pls advie.Since we store the resource owner in lower letters and in the json request we may receive few letter with capital.

${resource_owner} this is variable which resolves to an emailID.

SELECT custom FROM oauth_token where resource_owner = lower('${resource_owner}') ORDER BY created DESC

Outcomes