I’m in the process of migrating from Geo Service to Spatial Data and want to create a timer that syncs between both services for the migration period.
My idea is to have a metadata flag that marks already migrated GeoPoints and take only those that miss the flag.
geoQuery.setWhereClause("migrated IS NULL");
HashMap metaSearch = new HashMap();
However, both approaches return 0 GeoPoints even though none of the GeoPoints have it. What is the correct approach to query for the GeoPoints that miss this metadata? Or maybe you can suggest an alternative approach?
P.S. I can take the whole dataset and enumerate it checking each GeoPoint individually but that not efficient at all!