Delete not related GEO Points

[martin-krajcir (Martin Krajčír)]

I have a relation from DATA Table to geo point. Now I want to remove all odd geo points without relation from data table? How can I do it from the backendless web console?

I need to run SQL like this:

DELETE FROM GeoCategory WHERE id NOT IN (
  SELECT t.id
  FROM (
    SELECT d.id
    FROM mydata d
      LEFT JOIN GeoCategory geo ON geo.id = d.geo
  ) as t
);

Thank you.

[sergey-chupovN0 (Sergey Chupov)]

Hi Martin,

This is the where clause to find those geo points:

YourDataTable[relationColumnName].objectId IS NULL

(reference: https://backendless.com/docs/rest/doc.html#data_inverted_relation_retrieval)

You may delete them from console or from your code using API.

[martin-krajcir (Martin Krajčír)]

Hello Segey,

unfortunately your suggested solution could be used to delete DataTable items. But I need to remove GeoPoint items.

[sergey-chupovN0 (Sergey Chupov)]

You can search geo points using where clause, too.

[martin-krajcir (Martin Krajčír)]

Thank you Sergey, I did not know that. So here is a documentation how to operate over geo point.