Get Free Trial

flexmonster-mongo-connector does not return 'distinctcount' aggregator for string fields

Re-Open
test0test0test asked on September 3, 2020

Hi,
 
I am currently running flexmonster-mongo-connector 2.8.14 and mongodb 3.3.0.
 
When the fields are returned from the flexmonster-mongo-connector, the aggregation available for the string field is only [“count”], and the default ‘distinctcount’ aggregator for string does not appear.
We have tried forcing the ‘distinctcount’ aggregator into the react pivot table by modifying the response returned from flexmonster-mongo-connector, but after trying to do a ‘distinctcount’ on the react pivot table, the flexmonster-mongo-connector returns the following error, from mongodb.
 
“the field ‘title_!distinctcount’ must be an accumulator object”
 
May I know how I should proceed from here?

2 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster September 4, 2020

Hi,
 
Thank you for posting your question.
 
Kindly note that the Distinct Count aggregation is not provided in the Flexmonster MongoDB Connector by default because Distinct Count is not represented in MongoDB in the first place.
 
Still, we are currently considering implementing this aggregation on the side of the MongoDB Connector – we cannot provide you with a precise ETA at the moment but we’ll make sure to inform you when it is introduced.
 
Please let us know if you have any other questions we can help you with in the meantime.
 
Regards,
Mykhailo

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster June 2, 2021

Hi,
 
Hope you’re doing well!
 
Major MongoDB Connector updates have been introduced in the latest Flexmonster release, including performance optimization, logging, and cache management. Expanding all values is now possible with MongoDB as well – we thought you might find this interesting.
 
If so, feel free to check out the following blog post for more details: https://www.flexmonster.com/blog/mongodb-pivot-table/.
 
This is included in Flexmonster v. 2.9.0: https://www.flexmonster.com/release-notes/
 
You are welcome to update the component. Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
 
Best regards,
Mykhailo

Please login or Register to Submit Answer