Hello,
how would I go about troubleshooting the reason FT.AGGREGATE isn’t returning data when using a certain query:
For instance using (@CheckNumber:(2019*))" returns no results:
“FT.AGGREGATE” “checks_hash_index_1” “(@CheckFromID:{3062}) (@CheckNumber:(2019*))” “APPLY” “@CheckID” “AS” “CheckID” “APPLY” “@CheckDate” “AS” “CheckDate” “APPLY” “@CreatedDateTimeUTC” “AS” “CreatedDateTimeUTC” APPLY “@CheckNumber” AS “CheckNumber” “SORTBY” “6” “@CheckDate” “DESC” “@CreatedDateTimeUTC” “DESC” “@CheckID” “DESC”
``
whereas using (@CheckNumber:(201904*))" returns the correct ones:
“FT.AGGREGATE” “checks_hash_index_1” “(@CheckFromID:{3062}) (@CheckNumber:(201904*))” “APPLY” “@CheckID” “AS” “CheckID” “APPLY” “@CheckDate” “AS” “CheckDate” “APPLY” “@CreatedDateTimeUTC” “AS” “CreatedDateTimeUTC” APPLY “@CheckNumber” AS “CheckNumber” “SORTBY” “6” “@CheckDate” “DESC” “@CreatedDateTimeUTC” “DESC” “@CheckID” “DESC”
``

(integer) 3

 CheckID

“89825”

CheckDate

“6.36911424e+17”

CreatedDateTimeUTC

“6.36905194659e+17”

CheckNumber

“20190410\3”


 CheckID

“89824”

CheckDate

“6.36911424e+17”

CreatedDateTimeUTC

“6.36905194659e+17”

CheckNumber

“20190410\2”


 CheckID

“89823”

CheckDate

“6.36911424e+17”

CreatedDateTimeUTC

“6.36905194659e+17”

CheckNumber

“20190410\1”

``
Here is part of the index, CheckNumber is TEXT SORTABLE:
ft.info checks_hash_index_1

index_name

checks_hash_index_1

index_options

 “NOOFFSETS”

fields


 CheckID


type

NUMERIC

SORTABLE

 CheckNumber

type

TEXT

WEIGHT

“1”

SORTABLE
``
Thank you!