FT.SEARCH is not returning items

Redis commands & data structures
1

Hello,
I have the next item in redisjson structure:

127.0.0.1:6379> JSON.GET 1
"{\"CreationDate\":\"2023-05-04T09:21:02.56Z\",\"Id\":\"1\",\"ANI\":\"1\",\"CampaignId\":\"1\",\"Language\":\"es\",\"Level\":\"1\",\"State\":\"1\"}"

I am not getting items when I execute the search:

127.0.0.1:6379> FT.SEARCH index_tasks '@Id:(1)'
1) (integer) 0

Any idea why is returning me 0 items having this index created:

127.0.0.1:6379> FT.INFO index_tasks
 1) index_name
 2) index_tasks
 3) index_options
 4) (empty array)
 5) index_definition
 6) 1) key_type
    2) JSON
    3) prefixes
    4) 1) item:
    5) default_score
    6) "1"
 7) attributes
 8) 1) 1) identifier
       2) CreationDate
       3) attribute
       4) CreationDate
       5) type
       6) TEXT
       7) WEIGHT
       8) "1"
    2) 1) identifier
       2) Id
       3) attribute
       4) Id
       5) type
       6) TEXT
       7) WEIGHT
       8) "1"
    3) 1) identifier
       2) ANI
       3) attribute
       4) ANI
       5) type
       6) TEXT
       7) WEIGHT
       8) "1"
    4) 1) identifier
       2) CampaignId
       3) attribute
       4) CampaignId
       5) type
       6) TEXT
       7) WEIGHT
       8) "1"
    5) 1) identifier
       2) Language
       3) attribute
       4) Language
       5) type
       6) TEXT
       7) WEIGHT
       8) "1"
    6) 1) identifier
       2) Level
       3) attribute
       4) Level
       5) type
       6) NUMERIC
    7) 1) identifier
       2) State
       3) attribute
       4) State
       5) type
       6) TEXT
       7) WEIGHT
       8) "1"
 9) num_docs
10) "0"
11) max_doc_id
12) "0"
13) num_terms
14) "0"
15) num_records
16) "0"
17) inverted_sz_mb
18) "0"
19) vector_index_sz_mb
20) "0"
21) total_inverted_index_blocks
22) "0"
23) offset_vectors_sz_mb
24) "0"
25) doc_table_size_mb
26) "0"
27) sortable_values_size_mb
28) "0"
29) key_table_size_mb
30) "0"
31) records_per_doc_avg
32) "-nan"
33) bytes_per_record_avg
34) "-nan"
35) offsets_per_term_avg
36) "-nan"
37) offset_bits_per_record_avg
38) "-nan"
39) hash_indexing_failures
40) "1"
41) total_indexing_time
42) "0"
43) indexing
44) "0"
45) percent_indexed
46) "1"
47) number_of_uses
48) (integer) 1
49) gc_stats
50)  1) bytes_collected
     2) "0"
     3) total_ms_run
     4) "0"
     5) total_cycles
     6) "0"
     7) average_cycle_time_ms
     8) "-nan"
     9) last_run_time_ms
    10) "0"
    11) gc_numeric_trees_missed
    12) "0"
    13) gc_blocks_denied
    14) "0"
51) cursor_stats
52) 1) global_idle
    2) (integer) 0
    3) global_total
    4) (integer) 0
    5) index_capacity
    6) (integer) 128
    7) index_total
    8) (integer) 0
53) dialect_stats
54) 1) "dialect_1"
    2) (integer) 0
    3) "dialect_2"
    4) (integer) 0
    5) "dialect_3"
    6) (integer) 0
2

Can you please share the FT.CREATE that you used?

3

Of course, I am using NRediSearch in C# and with wireshark i have seen that the FT.CREATE executed is the next one:

image
image1178×54 3.62 KB

Regards

4

Hello,
More information:

  1. the index is created with this command:
    FT.CREATE index_tasks ON Json PREFIX 1 item: SCHEMA CreationDate TEXT Id TEXT ANI TEXT CampaignId TEXT Language TEXT Level NUMERIC State TEXT
  2. the item is added with this command:
    JSON.SET item:1 . {“CreationDate”:“2023-05-09T08:36:52.669Z”,“Id”:“1”,“ANI”:“1”,“CampaignId”:“1”,“Language”:“en”,“Level”:“1”,“State”:“1”}
  3. the search is requested with this command:
    FT.SEARCH index_tasks @ANI:(1) WITHPAYLOADS also I have tried with FT.SEARCH index_tasks ‘@ANI:(1)’ WITHPAYLOADS
    In both cases it is not getting results.

If I execute them in redis-cli happens the same.
I have executed JSON.GET item:1 from redis-cli and it is giving me the next result:

127.0.0.1:6379> JSON.GET item:1
“{"CreationDate":"2023-05-09T08:36:52.669Z","Id":"1","ANI":"1","CampaignId":"1","Language":"en","Level":"1","State":"1"}”

Any idea why FT.SEARCH is not returning me items in the step 3?
Thanks a lot in advance!!

5

fixed with AddTextField(new FieldName(“$.field1”, “field1”)) using NRedisStack