Log file Viewer

[15:48:46] <pandaadb> Hi, i am a tad confused about text indices. Can you have a compound index taking advantage of key filtering and then doing a text search on the resulting objects?

[15:50:14] <pandaadb> never mind, i think i did something wrong. it now shows me an explain with a "indexPrefix" which is the ID, which i think is just want I want, then does the rest of it on a text index

[15:50:59] <pandaadb> though it seems to be impossible to have more than 1 index prefix

[15:54:11] <pandaadb> I guess that is the limitation? You can have a text index that is compound, but you can never query more than 1 key on the compound index. So { "id" : "asd", "words" : "this is text" } will support filtering by id = asd, but if I add asd $in [...] it gives me a prcessing error

[15:57:49] <pandaadb> I reckon that's what that means :) If the compound text index includes keys preceding the text index key, to perform a $text search, the query predicate must include equality match conditions on the preceding keys.

[16:01:30] <pandaadb> it seems reverting the entire thing makes it possible