Using MongoDB and needing countDocuments instead of count as an Action Type or Alternative Route

💬 Queries and Resources
1

Hi there,

Still learning my way around ReTool. Is there a way to change the Action Type when I'm writing a mongodb query?

I have:

image
image694×84 3.6 KB

and need it to actually call countDocuments()

When I run count() on Studio3T for example, my query comes back as:

DeprecationWarning: Collection.count() is deprecated. Use countDocuments or estimatedDocumentCount.

103

If I do countDocuments(), I get:

103

I need to get the 103 as my response in ReTool, if I can't add countDocuments(), can I just get the number part of the response I get from count()?
Thanks!

2

Alternatively, I am just trying to just pass the countDocuments as a command()

and trying this code:

{
  countDocuments: "accountstats",
  query: {
    accountId: "abc123",
    createdAt: { $gte: {{moment("2023-03-01")}} }
  }
}

ReTool then tells me:

  • message:"no such command: 'countDocuments'"

But I know that this command works find when I query the db directly:

db.accountstats.countDocuments({ accountId: "abc123", createdAt: { $gte: ISODate("2023-03-01") } });

3

Got it to work by adding a $date to the $gte:

$gte: {$date : {{ moment(`${year1.value}-${month1.value}-01`).startOf('month').format('YYYY-MM-DD') }}