Could not found minus value.

[knoro]

Hi.

I tried found at cloudant data, but could not found minus value data.

success: lat = 90
failed: lat = -90

How to find the minus value data ?

source: --databasename--.js

.
--databasename--.find({"where":{"and":[{"lat":-90}]}},function(err, result) {
            if (err) {
                console.log("--- error ---";
            } else {
                console.log("---  lng: ",  result.lng);
            }
}
.

model.properties: --databasename--.json

.
  "properties": {
    "_id": {
      "type": "string",
      "id": 1
    },
    "_rev": {
      "type": "string"
    },
    "timestamp": {
      "type": "date"
    },
    "lat": {
      "type": "number"
    }
}
.

cloudant data:

{
  "_id": "{any_id}",
  "_rev": "{any_rev}",
  "timestamp": "2016-05-12T06:00:00Z",
  "lat": -90
  "lng": 130
}
,
{
  "_id": "{any_id}",
  "_rev": "{any_rev}",
  "timestamp": "2016-05-12T06:00:00Z",
  "lat": 90
  "lng": 135
}

I tried in cloudant query box , but also could not found.

query:

{
  "selector": {
    "loopback__model__name": "--databacename--",
    "lat": -90
  },
  "fields": ["_id", "_rev",  "lat", "lng" ]
}

[dhmlau]

@virkt25 could you please take a look? thanks.

[jannyHou]

Worked with @virkt25 on it, suspect it's a bug on Cloudant side, the Cloudant query only takes in JSON format query, then Cloudant query parser converts it to Lucene syntax query, while seems the parser doesn't handle minus value properly(e.g. escape dash)

I emailed Cloudant support team, waiting for reply.

[jannyHou]

ah, the latest release of Cloudant Local docker@3 fixes the problem.

Please make sure you update to the latest Cloudant version.