0

I need your help please. I am using MongoDB aggregation pipelines for displaying a complex report. Requirements are changing often and product wants our DBA to be able to change quickly the report pipeline. Even more they want the report to differ based on the client using it, for multitenancy. We do not have a report builder because e use many different stages that would be hard to express. Currently I am using Spring Data MongoDB to execute the aggregation pipelines like this:

@Aggregation(pipeline = {...<pipeline JSON>
public AggregationResults<ReportBaseModel> runReport(...);

How could I store the aggregation pipeline in the database as a document so that I can easily read/modify it, and run it with some date period parameters?

Tried Spring Data MongoDB but that means the pipeline is hardcoded into the Java code. I do not want the JSON to be hardcoded.

craig1
  • 1
  • Does this answer your question? [MongoDB Stored Procedure Equivalent](https://stackoverflow.com/questions/3876049/mongodb-stored-procedure-equivalent) – ray Feb 20 '23 at 21:04
  • You can consider building [Views](https://www.mongodb.com/docs/manual/core/views/) with your pipelines. Example [here](https://stackoverflow.com/questions/73799456/creating-view-in-mongodb) – Noel Feb 23 '23 at 08:47

1 Answers1

0

You can save the pipelines in the database as any other document and do parameter substitution yourself before you execute the aggregation pipeline. You can also use a dedicated library like this one: https://github.com/MongoPipe/mongopipe-core

cris
  • 29
  • 3