Cannot remove apostrophe in a whereClause

Server Code Codeless
1

Hi there,
I am trying to remove an apostrophe from a whereClause in Codeless, but for some reason it is not working.

Here is what I am doing:

image
image1758×700 81.4 KB

I am receiving code 1017 Where clause 'tutor_name = 'Brandy O'Donnell'' is invalid.

Indeed, the tutor_name is Brandy O’Donnell. I have checked that the replacement block is a double apostrope (‘’) and not a quotation mark ("). With other tutor names that contain apostrophes, I do not have this issue, the RegExp block works fine.

In the console, the double apostrophe works:

image
image2566×546 73.6 KB

Any thoughts?

2

Hi, @Andreas_Marinopoulos

In order to search for this query you need to use two single quotes in the replacement field. According to the documentation:

https://backendless.com/docs/rest/data_search_with_where_clause.html

There might also be a problem with exactly what you are sending, so I would suggest that you log the getproperty data.

Regards,
Marina

3

Hi Marina,
this is what I am doing.

This
image

prints this:

Brandy O'Donnell

and this
image

prints this
Brandy O''Donnell

which is exactly what I need going into a where clause.

But then this

image
image1016×520 49.2 KB

throws this:
Error: Where clause 'tutor_name = 'Brandy O'Donnell'' is invalid

4

Hello @Andreas_Marinopoulos

I see you use “tutor_name” in where clause in Load Table objects block, but i dont see column “tutor_name” in your table

If that doesn’t solution, could you provide us with your app ID

Regard, Viktor

5

Hi @viktor.liablin , there’s a tutor_name column in the tutors table

image
image748×736 52.9 KB

It’s the 2 apostrophes at the end of the where clause that are causing the error.

6

App ID: 4A47197B-AE30-FA84-FF56-0071F4010900

1 Like
7

@Andreas_Marinopoulos

Which service is using this?

8

https://develop.backendless.com/brilliant_grades/bl/codeless/services/86FD5A96-0A9F-ADD5-FF0F-AA69C1C31900/updateTutorsSlots

1 Like
9

@Andreas_Marinopoulos

I’ve created same tables and logic and names in my app and this logic works good.
Can I use “invoke” in your service? Is it safety for your data?

10

Yes it is @viktor.liablin , only you will need a data set. I will send it to you on slack DM

11

@Andreas_Marinopoulos

I’ve created in your app service “BackendlessSuportTesting” to test the logic with your Tables
And this logic works fine here. Can you check it?

Regard, Viktor

12

Indeed, it works in your service but not in mine, despite the code being identical. Is this some sort of bug? How do I prevent it from happening? What shall I do to solve this in production?

13

I would recommend gradually removing logic from your implementation until it starts working. There’s got to be a problem somewhere in there