TLDR dlonghi had trouble querying the field type 'string' with curl, specifically when running _search API. Prabhat suggested creating the query in the browser and getting the curl command from the dev console, which worked for dlonghi.
```curl
I am able to locate each one of then in the _search api with the commands below specifying numeric fields _timestamp and some_id:
```curl -sk -u '
The issue is this:
`AND building='B1'`
```curl -sk -u '
A simple technique that you can follow to get the right curl command from the browser is to run the query in the browser and get the request as curl from the dev console
Thanks a lot for sharing this trick.
Worked like a charm.
```curl -iku '
The document. ```{ _timestamp : 1689103202000000, building : R1, category : R, some_id : 222, some_text : Red building, }```
One thing that I noticed, if I match start_time and end_time to the same value of the document's _timestamp, I get 0 hit. Incrementing the end_time by 1, I get the 1 hit I'm looking for. 0 hits: ```"start_time":1689103202000000, "end_time":1689103202000000``` the 1 hit: ```"start_time":1689103202000000, "end_time":1689103202000001```
yeah that is how its implemented.
dlonghi
Tue, 11 Jul 2023 19:47:07 UTCNot able to send curl to _search API with an SQL statement containing a string. Number type works fine. Hello everyone, this may be more of a linux/bash/curl question than Openobserve's. I indexed 3 docs with curl as in the next message: