N1QL search function with date returning 0 results

[2023-12-19 18:00:08,232] - [remote_util:3685] INFO - extract_remote_info-->distribution_type: Ubuntu, distribution_version: debian 11

{'datetime': ['join_date'], 'boolean': ['is_manager'], 'text': ['manages_reports'], 'vector': ['l_vector']}

[2023-12-19 18:00:15,299] - [fts_base:972] INFO - {

   "mapping": {

      "default_mapping": {

         "enabled": false,

         "dynamic": true,

         "default_analyzer": ""

      },

      "type_field": "type",

      "default_type": "_default",

      "default_analyzer": "standard",

      "default_datetime_parser": "dateTimeOptional",

      "default_field": "_all",

      "analysis": {},

      "types": {

         "emp": {

            "dynamic": false,

            "enabled": true,

            "fields": [],

            "properties": {

               "join_date": {

                  "dynamic": false,

                  "enabled": true,

                  "properties": {},

                  "fields": [

                     {

                        "include_in_all": true,

                        "include_term_vectors": true,

                        "index": true,

                        "name": "join_date",

                        "store": false,

                        "type": "datetime",

                        "analyzer": ""

                     }

                  ]

               },

               "is_manager": {

                  "dynamic": false,

                  "enabled": true,

                  "properties": {},

                  "fields": [

                     {

                        "include_in_all": true,

                        "include_term_vectors": true,

                        "index": true,

                        "name": "is_manager",

                        "store": false,

                        "type": "boolean",

                        "analyzer": ""

                     }

                  ]

               },

               "manages": {

                  "dynamic": false,

                  "enabled": true,

                  "fields": [],

                  "properties": {

                     "reports": {

                        "dynamic": false,

                        "enabled": true,

                        "properties": {},

                        "fields": [

                           {

                              "include_in_all": true,

                              "include_term_vectors": true,

                              "index": true,

                              "name": "reports",

                              "store": false,

                              "type": "text",

                              "analyzer": "standard"

                           }

                        ]

                     }

                  }

               },

               "l_vector": {

                  "dynamic": false,

                  "enabled": true,

                  "properties": {},

                  "fields": [

                     {

                        "index": true,

                        "name": "l_vector",

                        "store": false,

                        "type": "vector",

                        "analyzer": "",

                        "dims": 384,

                        "similarity": "dot_product"

                     }

                  ]

               }

            }

         }

      }

   },

   "store": {

      "kvStoreName": "mossStore",

      "mossStoreOptions": {},

      "indexType": "scorch"

   }

}

[2023-12-19 18:05:02,225] - [task:1800] INFO - ----------------------------------------------------- Query # 8 ----------------------------------------------------

[2023-12-19 18:05:02,333] - [fts_base:2809] INFO - Running query {"indexName": "custom_index", "size": 10000000, "from": 0, "explain": false, "query": {"field": "join_date", "start": "1987-03-07T05:02:00", "end": "2023-12-19T18:04:21.100065", "inclusive_start": true, "inclusive_end": true}, "fields": [], "ctl": {"consistency": {"level": "", "vectors": {}}, "timeout": 60000}} on node as 172.23.121.105 : Administrator:

[2023-12-19 18:05:02,333] - [on_prem_rest_client:1167] INFO - Making a rest request api=http://172.23.121.105:8094/api/index/custom_index/query verb=POST params=b'{"indexName": "custom_index", "size": 10000000, "from": 0, "explain": false, "query": {"field": "join_date", "start": "1987-03-07T05:02:00", "end": "2023-12-19T18:04:21.100065", "inclusive_start": true, "inclusive_end": true}, "fields": [], "ctl": {"consistency": {"level": "", "vectors": {}}, "timeout": 60000}}' client_cert=None verify=False

[2023-12-19 18:05:02,348] - [task:1815] INFO - Status: {'total': 1, 'failed': 0, 'successful': 1, 'errors': {}}

[2023-12-19 18:05:02,349] - [task:1852] INFO - FTS hits for query: {"field": "join_date", "start": "1987-03-07T05:02:00", "end": "2023-12-19T18:04:21.100065", "inclusive_start": true, "inclusive_end": true} is 47 (took 0.806427ms)

[2023-12-19 18:05:02,349] - [es_base:517] INFO - ES query '{'query': {'filtered': {'filter': {'range': {'join_date': {'gte': '1987-03-07T05:02:00', 'lte': '2023-12-19T18:04:21.100065'}}}}}}' 

[2023-12-19 18:05:02,444] - [task:1871] INFO - ES hits for query: {"query": {"filtered": {"filter": {"range": {"join_date": {"gte": "1987-03-07T05:02:00", "lte": "2023-12-19T18:04:21.100065"}}}}}} on es_index is 47 (took 56ms)

[2023-12-19 18:05:02,445] - [task:1884] INFO - SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified

[2023-12-19 18:05:02,445] - [task:1941] INFO - Running N1QL query: select meta().id from default where type='emp' and search(default, {"field": "join_date", "start": "1987-03-07T05:02:00", "end": "2023-12-19T18:04:21.100065", "inclusive_start": true, "inclusive_end": true},{"index": "custom_index"})

[2023-12-19 18:05:02,568] - [on_prem_rest_client:4510] INFO - query params : statement=select+meta%28%29.id+from+default+where+type%3D%27emp%27+and+search%28default%2C+%7B%22field%22%3A+%22join_date%22%2C+%22start%22%3A+%221987-03-07T05%3A02%3A00%22%2C+%22end%22%3A+%222023-12-19T18%3A04%3A21.100065%22%2C+%22inclusive_start%22%3A+true%2C+%22inclusive_end%22%3A+true%7D%2C%7B%22index%22%3A+%22custom_index%22%7D%29

[2023-12-19 18:05:02,929] - [task:1953] INFO - N1QL hits for query: "select meta().id from default where type='emp' and search(default, {\"field\": \"join_date\", \"start\": \"1987-03-07T05:02:00\", \"end\": \"2023-12-19T18:04:21.100065\", \"inclusive_start\": true, \"inclusive_end\": true},{\"index\": \"custom_index\"})" is 0 (took 357.316694ms)

[2023-12-19 18:05:02,930] - [task:1958] ERROR - FAIL: FTS hits: 47, while N1QL hits: 0

[2023-12-19 18:05:02,930] - [task:1973] ERROR - FAIL: Following 47 doc(s) were not returned by N1QL,but FTS, printing 50: ['emp10000024', 'emp10000054', 'emp10000059', 'emp10000041', 'emp10000007', 'emp10000055', 'emp10000027', 'emp10000058', 'emp10000090', 'emp10000013', 'emp10000001', 'emp10000009', 'emp10000073', 'emp10000097', 'emp10000015', 'emp10000010', 'emp10000087', 'emp10000031', 'emp10000035', 'emp10000053', 'emp10000018', 'emp10000026', 'emp10000022', 'emp10000048', 'emp10000050', 'emp10000038', 'emp10000089', 'emp10000064', 'emp10000078', 'emp10000095', 'emp10000092', 'emp10000086', 'emp10000084', 'emp10000023', 'emp10000042', 'emp10000099', 'emp10000016', 'emp10000043', 'emp10000025', 'emp10000077', 'emp10000067', 'emp10000005', 'emp10000063', 'emp10000039', 'emp10000081', 'emp10000085', 'emp10000100']

[2023-12-19 18:05:02,930] - [task:1941] INFO - Running N1QL query: select meta().id,* from default where type='emp' and search(default, {"field": "join_date", "start": "1987-03-07T05:02:00", "end": "2023-12-19T18:04:21.100065", "inclusive_start": true, "inclusive_end": true},{"index": "custom_index"})

[2023-12-19 18:05:03,037] - [on_prem_rest_client:4510] INFO - query params : statement=select+meta%28%29.id%2C%2A+from+default+where+type%3D%27emp%27+and+search%28default%2C+%7B%22field%22%3A+%22join_date%22%2C+%22start%22%3A+%221987-03-07T05%3A02%3A00%22%2C+%22end%22%3A+%222023-12-19T18%3A04%3A21.100065%22%2C+%22inclusive_start%22%3A+true%2C+%22inclusive_end%22%3A+true%7D%2C%7B%22index%22%3A+%22custom_index%22%7D%29

[2023-12-19 18:05:03,417] - [task:1953] INFO - N1QL hits for query: "select meta().id,* from default where type='emp' and search(default, {\"field\": \"join_date\", \"start\": \"1987-03-07T05:02:00\", \"end\": \"2023-12-19T18:04:21.100065\", \"inclusive_start\": true, \"inclusive_end\": true},{\"index\": \"custom_index\"})" is 0 (took 367.628533ms)