Get Free Trial
Get Free Trial

Filters for Values (eg. Top/Bottom X) when connected to MongoDB

posted on October 30th, 2024

Answered
Chern Yu Zi asked on October 30, 2024

Hi,

I realised there's no way to set filters onto 'Values' to get 'Top 10' (for example) when connected to MongoDB via the MongoDB connector. 

Is there a way to activate these filters? 

Thanks!

4 answers

Public
Nadia Khodakivska Nadia Khodakivska ⋅ Flexmonster ⋅ October 31, 2024

Hello,

Thank you for reaching out to us.

The current implementation of Flexmonster MongoDB Connector does not support filtering by values (top/bottom filters). We are not planning to add this feature for the Connector out of the box in the near future. However, you can use the MongoDB Connector source code and customize it for your needs: https://github.com/flexmonster/flexmonster-mongodb-connector. Please check the following guides for reference:

You are welcome to contact us if other questions arise.

Kind regards,
Nadia

Public
Chern Yu Zi ⋅ November 1, 2024

Hi Nadia,

Can I just confirm as well that other filters onto 'Values' are not supported as well - for eg. filters like 'greater than', 'less than', 'between' etc.

Thanks!

Public
Chern Yu Zi ⋅ November 1, 2024

Additionally, 2 more questions:

  1. Even if I customize the MongoDB connector source code to enable filtering on 'Values' for my own needs, how do I enable the button 'Values' and its respective dialog box to appear on the UI level? Currently it's not appearing (only 'Labels' is shown).
  2. Is this filtering on 'Values' feature not supported just for a data source that connect via MongoDB connector or for other custom APIs as well? May I have the full list of data sources and the features they support/not support so my team and I can make an informed choice to choose a data source?

Thanks!

Public
Nadia Khodakivska Nadia Khodakivska ⋅ Flexmonster ⋅ November 1, 2024

Hello,

Thank you for the response.

You are correct that other value filter types are also not supported for the MongoDB data source type.

Regarding other questions, please find our answers below:

  1. We want to explain that the Connector retrieves information about each column from your MongoDB index and maps these types to those Flexmonster recognizes. This mapping is included in the fields response, allowing the component to configure itself for interaction with your index. The response describes the capabilities for each field, such as available aggregation and filters. To enable the "Values" filter, you will first need to add the logic of the necessary value filters. Then, you can adjust the server configuration within the custom data source API protocol. In this step, you can specify which filters are supported and which are not. Once this configuration is complete, the information is communicated to the user interface, allowing the "Values" filter option to appear as needed.
  2. The value filters are supported for the following data sources: JSON/CSV, Flexmonster Data Server (databases, JSON, and CSV), MS Analysis Services, and Custom data source API. More details on supported features based on different data sources can be found in our Technical Specifications: https://www.flexmonster.com/technical-specifications/#filter. Also, we recommend checking the following guide on how to choose the best data source for your use case: https://www.flexmonster.com/blog/how-to-choose-the-best-data-source-to-use-with-flexmonster/.

Please let us know if other questions arise.

Kind regards,
Nadia

Please login or Register to Submit Answer