how can I choose the fields to retrieve with FT.AGGREGATE?

Asked Feb 12 '22 at 12:19

Active Feb 12 '22 at 12:19

Viewed 618 times

I need to sort the documents by the field type equals folder and I only need the id to be retrieved, however, I can't seem to make only the id to be returned.

FT.AGGREGATE Query:DirectoryItem * APPLY "@type == 'folder'" as isFolder LIMIT 0 50 SORTBY 2 @isFolder DESC APPLY @id as id

The above query returns the type, isFolder and id fields.

Can I only retrieve id somehow?

asked Feb 12 '22 at 12:19

Jonathan

4,724
7
45
65

1

Currently, you cannot. Are you trying to optimize the network traffic? – Ariel Feb 13 '22 at 14:40
not only that but my calls are dynamic, so would be much easier to retrieve only the ID. If not I will have to make the generic method count the APPLY to know where the id field is – Jonathan Feb 14 '22 at 13:24
1

Support for the RETURN clause as in FT.Search would solve this. – Pieter Cailliau Feb 19 '22 at 17:25
@PieterCailliau created an issue there: https://github.com/RediSearch/RediSearch/issues/2591 – Jonathan Feb 20 '22 at 20:06

how can I choose the fields to retrieve with FT.AGGREGATE?

0 Answers0