The best method to query date array in couchbase lite with N1QL?

  updated: [2022-09-08T00:00:00.000, 2022-09-08T10:00:00.000, 2022-09-09T00:00:00.000, 2022-09-10T00:00:00.000, 2022-09-12T00:00:00.000, 2022-10-15T00:00:00.000]
  1. How to search data updated in 2022-09-08 (in a day)
  2. How to search data updated in 2022-09 and 2022-10 (in two months)


Hi @Tonny,

SQL++ for CB Lite supports array and date operations. You can go with an approach similar to the one shown in this blog post.

Another option might be to use the full text search to perform date range queries. For reference on using full text search with couchbase lite, you can check this question on the forum: Weird behaivor from CB Lite Full Text Search on string lists