I’m having trouble figuring out the best way to accomplish a simple query within a date range:
Given an emit like so:
emit([text1, text2, year, mon, day], null)
and using the builtin _count reduce with the following query:
I see that because the index is concatenated together and sorted, my date ranges are completely ignored.
Is there no way to accomplish such a simple usecase? The alternative I thought of was to invert the emit and put the dates first, but I do not want to group by dates. I merely would like to filter the date range and only group by my 2 parameters. I guess if I can specify that the grouping start at an offset to my keys, then I could accomplish what I need…
Thanks for your assistance!