I have a MongoDB database where people can enter relatively arbitrary search conditions (in this case they are vetted, but not restricted conceptually). An example of a condition a user could specify may look like:
This works well for searching, however, I want to be able to also generate statistics based on older data, for which I use an aggregation that looks something like:
The problem with such a query is MongoDB does not seem to allow using a $cond with something like $details.vulns . I understand a standard approach would be to unwind, however, due to the conditions being not known before my code executes, I have no way to know what fields to unwind unless I re-implement a MongoDB parsing engine in my own code.
Is there an alternative approach here I am missing, or does MongoDB simply lack the ability to apply an arbitrary search clause during an aggregation? If there is a slow way of doing it, I would be fine with that.
I can’t say that i understand what you need,but in case you need to save mongoQL code in database you can use $literal,and save that condition in database as a embedded document.
Also the use of function call inside of json can provide “dynamic” queries,like generate
the query json,from a function.For example dont write by hand the condition,have a function
that generated the mongoQL code.
Or the combination,save the condition,and generate queries that use that condition.
To demonstrate the issue more clearly, here is some example data. Keep in mind that this is simplified – the real data contains many different fields that I may wish to query against, hence the above statements about unwind not being a satisfactory solution: