# \#query-workbench **URL:** https://forum.opensearch.org/tag/query-workbench/17.md [Latest](https://forum.opensearch.org/latest.md) · [Categories](https://forum.opensearch.org/categories.md) · [Tags](https://forum.opensearch.org/tags.md) --- ## [How 'gte', 'gt', 'lte', and 'lt' operators handle millisecond precision?](https://forum.opensearch.org/t/how-gte-gt-lte-and-lt-operators-handle-millisecond-precision/22771)
**Author:** [@1Tsw0ld](https://forum.opensearch.org/u/1Tsw0ld)\ **Replies:** 1\ **Last updated:** [December 13, 2024, 4:17pm UTC](https://forum.opensearch.org/t/how-gte-gt-lte-and-lt-operators-handle-millisecond-precision/22771 "2024-12-13T16:17:24Z")
Could you clarify the precise behavior of Elasticsearch’s range query when dealing with timestamp fields that include milliseconds? Specifically, I’m interested in understanding how ‘gte’, ‘gt’, ‘lte’, and ‘lt’ operator… --- ## [Is there a where clause that can be used for ip type in opensearch query workbench (plugin/\_sql)?](https://forum.opensearch.org/t/is-there-a-where-clause-that-can-be-used-for-ip-type-in-opensearch-query-workbench-plugin-sql/17019)
**Author:** [@F1rstMan](https://forum.opensearch.org/u/F1rstMan)\ **Replies:** 0\ **Last updated:** [December 10, 2023, 4:14pm UTC](https://forum.opensearch.org/t/is-there-a-where-clause-that-can-be-used-for-ip-type-in-opensearch-query-workbench-plugin-sql/17019 "2023-12-10T16:14:34Z")
Versions (relevant - OpenSearch/Dashboard/Server OS/Browser): opensearch 2.10 Describe the issue: Is there a where clause that can be used for ip type in opensearch query workbench (plugin/\_sql)? is null and is not n… --- ## [Should + vector search](https://forum.opensearch.org/t/should-vector-search/16636)
**Author:** [@ardito.bryan](https://forum.opensearch.org/u/ardito.bryan)\ **Replies:** 0\ **Last updated:** [November 11, 2023, 6:19pm UTC](https://forum.opensearch.org/t/should-vector-search/16636 "2023-11-11T18:19:11Z")
Suppose my index has: A vector field called “text\_encoded” A field called “field1”, that can contain one or more of the following classes: “A”, “B”, “C” as list (ex. “field1” : \[“A”\], or “field1” : \[“A”, “C”\]) I would… --- ## [Need help with a query](https://forum.opensearch.org/t/need-help-with-a-query/15022)
**Author:** [@localforecast391](https://forum.opensearch.org/u/localforecast391)\ **Replies:** 1\ **Last updated:** [July 13, 2023, 4:09pm UTC](https://forum.opensearch.org/t/need-help-with-a-query/15022 "2023-07-13T16:09:15Z")
Describe the issue: I need help with a query to group the results. GET user\_info,user\_auth\_cards\_info/\_search { “from”: 0, “size”: 20, “query”: { “bool”: { “filter”: \[ { “match”: { “e\_name.autocomplete”: { “q… --- ## [Simple\_query\_string or query\_string with fuzziness in some fields](https://forum.opensearch.org/t/simple-query-string-or-query-string-with-fuzziness-in-some-fields/12864)
**Author:** [@basitmm](https://forum.opensearch.org/u/basitmm)\ **Replies:** 1\ **Last updated:** [March 3, 2023, 1:48pm UTC](https://forum.opensearch.org/t/simple-query-string-or-query-string-with-fuzziness-in-some-fields/12864 "2023-03-03T13:48:06Z")
Hi, is it possible to use simple\_query\_string with fuzziness only on special fields? As I know the query should be “ifhone~1” =\> to match iPhone. But no user will type “~1” in a simple search filed. So I want to set f… --- ## [DLQ Query if field contains GUID](https://forum.opensearch.org/t/dlq-query-if-field-contains-guid/10502)
**Author:** [@mmkt](https://forum.opensearch.org/u/mmkt)\ **Replies:** 3\ **Last updated:** [September 16, 2022, 12:38pm UTC](https://forum.opensearch.org/t/dlq-query-if-field-contains-guid/10502 "2022-09-16T12:38:19Z")
I have a field named chainOfIds. This field has up to 15 GUIDs with indices appended and separated by commas. See example: chainOfIds: caf5d635-20cf-4fd0-99a1-d8ef7a94721e.0, 77c5eb92-17d5-4382-ba89-41e053a5f520.1, 4de… --- ## [Reduce the response size by adding some logic to query](https://forum.opensearch.org/t/reduce-the-response-size-by-adding-some-logic-to-query/10604)
**Author:** [@eveliou](https://forum.opensearch.org/u/eveliou)\ **Replies:** 1\ **Last updated:** [August 16, 2022, 7:47pm UTC](https://forum.opensearch.org/t/reduce-the-response-size-by-adding-some-logic-to-query/10604 "2022-08-16T19:47:39Z")
I have the following Request body: {“size”:10000,“query”:{“bool”:{“must”:\[{“terms”:{“rule.id”:\[“3357”,“3335”,“43432”\]}}\],“filter”:\[{“range”:{“timestamp”:{“gte”:“now-1h/h”,“lte”:“now”}}}\]}}} And I get the following resp…