Skip to main content
R
Ru_0114-Alexandrite
14-Alexandrite
January 19, 2021
Question

How to compare database input with another input using case sensitivity?

  • January 19, 2021
  • 2 replies
  • 1813 views

hiii,

 

i have one javascript where i have one database service called to getWorkoutName.

Now i want to compare that workout names with the input by using case sensitive. here is a javascript code which is giving me database workoutnames. when i am giving input  "pushup" then result is showing already exist which is correct output but when i am giving an input "Pushup" then it's showing result as "Error executing service caseSensitive. Message :: TypeError: Cannot call method "toLowerCase" of null" instead of "already exist" so help me with this peoblem.

 

javascript:-

// result: INFOTABLE dataShape: ""
var result1 = Things["Database"].getWorkoutName({
workout_name: workout_name /* STRING */
});

var name1 = result1.workout_name;
var a = name1.toLowerCase();
var name2 = workout_name.toLowerCase();
if(name2.toLowerCase() === name1.toLowerCase())
{
result = ' Already exists';
}
else
{
result = ' Not Exists';

}

 

below are some snapshots of output please refer for better understanding;

 

2 replies

A
Ashritha15-Moonstone
15-Moonstone
January 19, 2021

Hi @Ru_01 ,

 

Please refer the following Link .

 

Hope it Helps !!!

M
mnarang5-Regular Member
5-Regular Member
January 19, 2021

I tried reproducing it, but it is working fine at my end. As per your error when you pass Pushup as an input and execute this service, one of the variable is coming as null and you are doing .toLoweCase() on that variable which is why it is failing. Can you apply some logger in this service to catch the culprit ? for example, before this line 

var name1 = result1.workout_name; add logger.warn("value of workoutname is" + result1.workout_name);

 

You can add more logger like above.

 

Also as per your code when you have already done this:
var name1 = result1.workout_name;
var a = name1.toLowerCase();
var name2 = workout_name.toLowerCase();

 

then why you are putting up if(name2.toLowerCase() === name1.toLowerCase()) in if block ?
as i can see you already have toLowerCase in variables so why you are doing toLowerCase again on the same variable ?

 

instead of this you can use if(name2 === a). I hope i understood your code in right direction, if there is something which I have misinterpreted please let me know.

R
Ru_0114-AlexandriteAuthor
14-Alexandrite
January 19, 2021

"pushup" is a workout_name which is present in my database. Now i want to compare "Pushup" with database's "pushup". i just want to check spelling of the workout_name present in my database. so whenever i create a workout and giving that workout_name as "pushup" or 'Pushup" or "PUSHUP" i want it must show an error the Workout_name is already exist

Terms & ConditionsCookie settingsAccessibility statement