Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

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

Answered
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?

1 answer

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

Please login or Register to Submit Answer