How to make query with project fields?

[adil659]

I finally managed to integrate your plugin with grafana OSS. I was able to make basic queries using the MongoDb Compass way to making queries. I was wondering if there are other query methods it accepts such as the cli way?

I can't seem to show only certain columns when making the query, it gives all of the columns. In MongoDb examples it seems possible by using the Project filter . like so: { item: 1, status: 1, "instock.qty": 1 } . but I'm not sure how I can achieve this using the plugin.

[ludovicm67]

Thank you @adil659 for using the Grafana plugin and for your question!

Regarding the current state, it's returning all entries, but it's possible to only select fields that have a specific value by using {"field": "value"} in the query zone.

The current implementation is doing find operations, and provides the query as the query parameter (first one), see reference here: https://www.mongodb.com/docs/manual/reference/method/db.collection.find/#mongodb-method-db.collection.find

In the future, I might add other fields to allow the user to set the projection, options, and also add support for other methods to query data than find.

[adil659]

oh okay, thankyou!