mongo.comcloud.xyz Open in urlscan Pro
188.114.97.3  Public Scan

Form analysis
2 forms found in the DOM

GET https://mongo.comcloud.xyz/community/forums/search

<form role="search" method="GET" action="https://mongo.comcloud.xyz/community/forums/search" class="css-1c69emu">
  <div class="css-1q5aj3">
    <div class="css-36i4c2"><input type="text" placeholder="Search community forums..." class="css-etrcff" value=""></div>
    <div class="css-1hc92ka">
      <div class="css-aef77t"><button role="button" type="button" class="css-14k7wrz"><span data-testid="selected-value" class="css-6k4l2y">Community Forums</span>
          <div class="css-109dpaz"><svg data-testid="icon" width="16" height="9" viewBox="0 0 16 9" fill="none" xmlns="http://www.w3.org/2000/svg" class="css-1yzkxhp">
              <path d="M1.06689 0.799988L8.00023 7.73332L14.9336 0.799988" stroke-linecap="round" stroke-linejoin="round" class="css-1tlq8q9"></path>
            </svg></div>
        </button>
        <div class="css-hn9qqo">
          <ul data-testid="options" role="listbox" class="css-ac9zo2">
            <li role="option" tabindex="0" class="css-11dtrvq">General Information</li>
            <li role="option" tabindex="0" class="css-11dtrvq">All Documentation</li>
            <li role="option" tabindex="0" class="css-11dtrvq">Realm Documentation</li>
            <li role="option" tabindex="0" class="css-11dtrvq">Developer Articles &amp; Topics</li>
            <li role="option" tabindex="0" class="css-11dtrvq">Community Forums</li>
            <li role="option" tabindex="0" class="css-11dtrvq">Blog</li>
            <li role="option" tabindex="0" class="css-11dtrvq">University</li>
          </ul>
        </div>
      </div><input type="hidden" id="q" name="q" value="">
      <div class="css-1myrko"><button type="submit" tabindex="0" class=" css-13l1z36" data-track="true"><img alt="search icon" src="https://webimages.mongodb.com/_com_assets/cms/krc3hljsdwdfd2w5d-web-actions-search.svg?auto=format%252Ccompress"
            class="css-r9fohf"></button></div>
    </div>
  </div>
</form>

POST /community/forums/login

<form id="hidden-login-form" method="post" action="/community/forums/login" style="display: none;">
  <input name="username" type="text" id="signin_username">
  <input name="password" type="password" id="signin_password">
  <input name="redirect" type="hidden">
  <input type="submit" id="signin-button" value="Log In">
</form>

Text Content

MongoDB.local is coming to NYC! Use code Community50 for 50% off your
registration.
×
Community Forums

 * General Information
 * All Documentation
 * Realm Documentation
 * Developer Articles & Topics
 * Community Forums
 * Blog
 * University


 * Products
   Platform
   AtlasBuild on a developer data platform
   Platform Services
   DatabaseDeploy a multi-cloud databaseSearchDeliver engaging search
   experiencesVector SearchDesign intelligent apps with GenAIStream Processing
   (Preview)Unify data in motion and data at rest
   Tools
   CompassWork with MongoDB data in a GUIIntegrationsIntegrations with
   third-party servicesRelational MigratorMigrate to MongoDB with confidence
   Self Managed
   Enterprise AdvancedRun and manage MongoDB yourselfCommunity EditionDevelop
   locally with MongoDB
   Build with MongoDB Atlas
   Get started for free in minutes
   Sign Up
   Test Enterprise Advanced
   Develop with MongoDB on-premises
   Download
   Try Community Edition
   Explore the latest version of MongoDB
   Download
 * Resources
   Documentation
   Atlas DocumentationGet started using AtlasServer DocumentationLearn to use
   MongoDBStart With GuidesGet step-by-step guidance for key tasks
   
   Tools and ConnectorsLearn how to connect to MongoDBMongoDB DriversUse drivers
   and libraries for MongoDB
   AI Resources HubGet help building the next big thing in AI with
   MongoDBarrow-right
   Connect
   Developer CenterExplore a wide range of developer resourcesCommunityJoin a
   global community of developersCourses and CertificationLearn for free from
   MongoDBWebinars and EventsFind a webinar or event near you
 * Solutions
   Use cases
   Artificial IntelligenceEdge ComputingInternet of
   ThingsMobilePaymentsServerless Development
   Industries
   Financial ServicesTelecommunicationsHealthcareRetailPublic
   SectorManufacturing
   Solutions LibraryOrganized and tailored solutions to kick-start
   projectsarrow-right
   Developer Data Platform
   Accelerate innovation at scale
   Learn morearrow-right
   Startups and AI Innovators
   For world-changing ideas and AI pioneers
   Learn morearrow-right
   Customer Case Studies
   Hear directly from our users
   See Storiesarrow-right
 * Company
   CareersStart your next adventureBlogRead articles and
   announcementsNewsroomRead press releases and news stories
   PartnersLearn about our partner ecosystemLeadershipMeet our executive
   teamCompanyLearn more about who we are
   Contact Us
   Reach out to MongoDB
   Let’s chatarrow-right
   Investors
   Visit our investor portal
   Learn morearrow-right
 * Pricing



Skip to main content

Sign UpLog In
 * 
 * 
 * 
 * 

Welcome to the
MongoDB
Developer Community
Community GuidesTry MongoDB Atlas for Free



UNABLE TO USE EXPLAIN() WITH AGGREGATION PIPELINE

Working with Data
aggregationqueriesnode-js



You have selected 0 posts.

select all

cancel selecting


Umasankar_Swain
1
Sep '23


 1. In below code when ever I am trying to use explain() getting this
    error,“MongoInvalidArgumentError: Option “explain” cannot be used on an
    aggregate call with writeConcern”.But why where I am doing wrong?

 2. And another thing is this aggregation pipeline takes 30 sec to return 30000
    data,which is very slow how can i optimize this?

Note:I have alreday created Indexes in corresponding collection but still slow.
Please help me to achieve this, Thanks in advance…

const result1 = await this.qcInspectionModel.aggregate([
  {
    $match: {
      $and: [
        startDateQuery,
        endDateQuery,
        statusQuery,
        businessUnitFilterQuery,
        { isDeleted: false },
        { isSLCMQcInspection: true },
      ],
    },
  },
  {
    $lookup: {
      from: 'mastercommodities',
      localField: 'commodityId',
      pipeline: [
        {
          $project: {
            name: 1,
          },
        },
      ],
      foreignField: '_id',
      as: 'commodityData',
    },
  },
  {
    $unwind: '$commodityData',
  },
  {
    $lookup: {
      from: 'commodityvariants',
      localField: 'commodityVariantId',
      pipeline: [
        {
          $project: {
            name: 1,
          },
        },
      ],
      foreignField: '_id',
      as: 'commodityVariantData',
    },
  },
  {
    $unwind: '$commodityVariantData',
  },
  {
    $lookup: {
      from: 'businessunits',
      localField: 'businessUnitId',
      pipeline: [
        {
          $lookup: {
            from: 'businesses',
            localField: 'businessId',
            foreignField: '_id',
            as: 'businessClientName',
          },
        },
        {
          $unwind: '$businessClientName',
        },
        {
          $project: {
            name: 1,
            businessClientName: '$businessClientName.displayName',
          },
        },
      ],
      foreignField: '_id',
      as: 'businessUnitData',
    },
  },
  {
    $unwind: {
      path: '$businessUnitData',
      preserveNullAndEmptyArrays: true,
    },
  },
  {
    $lookup: {
      from: 'users',
      localField: 'createdBy',
      foreignField: '_id',
      as: 'userData',
      pipeline: [
        {
          $project: {
            firstName: 1,
            lastName: 1,
            _id: 0,
            name: { $concat: ['$firstName', ' ', '$lastName'] },
          },
        },
      ],
    },
  },
  {
    $unwind: {
      path: '$userData',
      preserveNullAndEmptyArrays: true,
    },
  },
  {
    $match: {
      $and: [
        commoditySearchQuery,
        variantSearchQuery,
        generalSearchQuery,
        cidNumberSearchQuery,
        lotNoSearchQuery
      ],
    },
  },
  {
    $sort: {
      createdAt:
        filters.sortOrder && filters.sortOrder != SortOrder.Ascending
          ? SortOrder.Descending
          : SortOrder.Ascending,
    },
  },
  {
    $project: {
      _id: 1,
      status: 1,
      commodityData: 1,
      commodityDetail: 1,
      commodityVariantData: 1,
      createdAt: 1,
      qcId: 1,
      sampleName: 1,
      businessUnitData: 1,
      userData: 1,
      location: 1,
      middlewareStatus: 1,
    },
  },
  {
    $facet: {
      records: [
        { $skip: (filters.pageNumber - 1) * filters.count },
        { $limit: filters.count * 1 },
      ],
      total: [{ $count: 'count' }],
    },
  }
]).explain();









Reply



NEW & UNREAD TOPICS

Topic Replies Views Activity

About maxTimeMS() and interrupt points
Working with Data
queries
5 799 May '23 regexMatch fails with a variable string
Working with Data
aggregation
1 309 Jul '23 Conditionally add to the end of a string
Working with Data
queriesnode-js
2 447 Aug '23 Defining a schema for a aircraft tracking website
Working with Data
aggregationqueriesdata-modelingpython
0 636 Sep '23 Replication secondary space utilization higher than primary node
space utilization
Working with Data
replicationstorage
3 401 Jan 11


WANT TO READ MORE? BROWSE OTHER TOPICS IN WORKING WITH DATA OR VIEW LATEST
TOPICS.









Invalid date Invalid date





© 2023 MongoDB, Inc.

About

 * Careers
 * Investor Relations
 * Legal Notices
 * Privacy Notices
 * Security Information
 * Trust Center

Support

 * Contact Us
 * Customer Portal
 * Atlas Status
 * Customer Support

Social

 * GitHub
 * Stack Overflow
 * LinkedIn
 * YouTube
 * Twitter
 * Twitch
 * Facebook

© 2023 MongoDB, Inc.
By clicking "Accept All Cookies", you agree to the storing of cookies on your
device to enhance site navigation, analyze site usage, and assist in our
marketing efforts. You can enable and disable optional cookies as desired.Read
our Privacy Policy
Manage Cookies Accept All Cookies



PRIVACY PREFERENCE CENTER

"Cookies" are small files that enable us to store information while you visit
one of our websites. When you visit any website, it may store or retrieve
information on your browser, mostly in the form of cookies. This information
might be about you, your preferences or your device and is mostly used to make
the site work as you expect it to. The information does not usually directly
identify you, but it can give you a more personalized web experience. Because we
respect your right to privacy, you can choose not to allow some types of
cookies, but essential cookies are always enabled. Click on the different
category headings to find out more and change our default settings. However,
blocking some types of cookies may impact your experience of the site and the
services we are able to offer.
MongoDB Privacy Policy
Allow All


MANAGE CONSENT PREFERENCES

STRICTLY NECESSARY COOKIES

Always Active

These cookies are necessary for the website to function and cannot be switched
off in our systems. They are usually only set in response to actions made by you
which amount to a request for services, such as setting your privacy
preferences, logging in or filling in forms. You can set your browser to block
or alert you about these cookies, but some parts of the site will not then work.
These cookies do not store any personally identifiable information.

PERFORMANCE COOKIES

Performance Cookies

These cookies allow us to count visits and traffic sources so we can measure and
improve the performance of our site. They help us to know which pages are the
most and least popular and see how visitors move around the site. All
information these cookies collect is aggregated and therefore anonymous. If you
do not allow these cookies we will not know when you have visited our site, and
will not be able to monitor its performance.

FUNCTIONAL COOKIES

Functional Cookies

These cookies enable the website to provide enhanced functionality and
personalisation. They may be set by us or by third party providers whose
services we have added to our pages. If you do not allow these cookies then some
or all of these services may not function properly.

TARGETING COOKIES

Targeting Cookies

These cookies may be set through our site by our advertising partners. They may
be used by those companies to build a profile of your interests and show you
relevant adverts on other sites. They do not store directly personal
information, but are based on uniquely identifying your browser and internet
device. If you do not allow these cookies, you will experience less targeted
advertising.

SOCIAL MEDIA COOKIES

Social Media Cookies

These cookies are set by a range of social media services that we have added to
the site to enable you to share our content with your friends and networks. They
are capable of tracking your browser across other sites and building up a
profile of your interests. This may impact the content and messages you see on
other websites you visit. If you do not allow these cookies you may not be able
to use or see these sharing tools.

Back Button


COOKIE LIST



Search Icon
Filter Icon

Clear
checkbox label label
Apply Cancel
Consent Leg.Interest
checkbox label label
checkbox label label
checkbox label label

Confirm My Choices