Invalid where clause error

Andriy_Konoz · January 31, 2023, 2:22pm

You should create additional column which will hold location as a point and use that column in queries. Unfortunately there is no other way.

Regards, Andriy

Ayaz_Khan · January 31, 2023, 3:31pm

@Andriy_Konoz ,

Thanks for your support.

Ayaz_Khan · February 1, 2023, 7:26am

@Andriy_Konoz,

I have a bulk of records in many tables which have separate latitude and longitude columns how can I create a new column and merge latitude and longitude in Point(…) because at a time query takes only 100 records. Is there any simple way?

Inna_Shkolnaya · February 1, 2023, 8:14am

Hello @Ayaz_Khan

You can use the generated column Introducing The Generated Columns Feature | Backendless

Regards,
Inna

Ayaz_Khan · February 1, 2023, 8:28am

Hi @Inna_Shkolnaya ,

There is no option for location points in generated columns.

I need to generate a column for location points(latitude longitude). I have separate columns for latitude and longitude

Andriy_Konoz · February 1, 2023, 8:36am

Hi @Ayaz_Khan ,

My colleague misguided you a little bit. Generated columns concept will not work for your case.
You will need to create a client side script which will iterate over each of those tables and generate value for new column of “Point” type. To iterate over all records you will need to use pagination since you can extract only up to 100 records per request. You can check this link to get more information about pagination in Backendless Data Service.

Regards, Andriy