ismissing(@field) not working

[zuhairamahdi]

Hi All,

when I try to check if a field is missing (with dialect 2 specified' it gives me the same error as if I didn't specify the dialect.

r.ft(f"idx:{INDEX}").search(Query('ismissing(@Name_Ar) AND @Active:[1 1]').dialect(2))

Output

Syntax error at offset 18 near Name_Ar

when I try using the CLI it works:

FT.SEARCH 'idx:my_index' 'ismissing(@Name_Ar) AND @Active:[1 1]' DIALECT 2

any idea?

[petyaslavova]

Hi @zuhairamahdi,
Can you please provide more info about the client version you are using and the index definition?
I tried your example with the current master code, and it is working without issues.

[zuhairamahdi]

Hi @petyaslavova

I think the issue is from my side. the index was created with INDEXEMPTY instead of INEDXMISSING. I still didn't try it. will try and see if it is working.

[zuhairamahdi]

@petyaslavova it seem to be working fine when querying except when I try to get the total:

r.ft(f"idx:{QUEUE_TABLE}").search(Query(query).paging(0, 0)).total

to be clear I get the same error when I try it using the cli:

FT.SEARCH 'idx:my_index' 'ismissing(@Name_Ar)' LIMIT 0 0

Error:

Syntax error at offset 18 near Name_Ar

Index definition:

[zuhairamahdi]

ok. the issue with the total is i didn't use dialect 2.