mongodb - Multiple $and with multiple $or in $match mongoose -

-

expected condition

if(pid==req.session.pid &&     ((status==0 && statusdate1>=somedate)||(status==1 && statusdate2>=somedate)||     (status==2 && statusdate3>=somedate)||(status==0 && statusdate1>=somedate)))

i have tried writing below $match statement meet above condition, reason not expected.

var match =  { $match: {      $and: [          { practiceid: req.session.p_id },           {             $or:[{status : 0, statusdate1:{$gte:somedate}}]          },          {                        $or:[{status : 1, statusdate2:{$gte:somedate}}]          },         {                        $or:[{status : 2, statusdate3:{$gte:somedate}}]          },         {                        $or:[{status : 3, statusdate4:{$gte:somedate}}]          }]     } }

could please point me in right direction?

update

tried below versions, still did not expecting.

attempt 1

var match =  { $match: {      $and: [          { practiceid: req.session.p_id }],     $and:[           {             $or:[{status : 0, statusdate1:{$gte:somedate}}]          },          {                        $or:[{status : 1, statusdate2:{$gte:somedate}}]          },         {                        $or:[{status : 2, statusdate3:{$gte:somedate}}]          },         {                        $or:[{status : 3, statusdate4:{$gte:somedate}}]          }]     } }

attempt 2

var match =  { $match: {      practiceid: req.session.p_id ,     $and:[           {             $or:[{status : 0, statusdate1:{$gte:somedate}}]          },          {                        $or:[{status : 1, statusdate2:{$gte:somedate}}]          },         {                        $or:[{status : 2, statusdate3:{$gte:somedate}}]          },         {                        $or:[{status : 3, statusdate4:{$gte:somedate}}]          }]     } }

attempt 3

var match =  { $match: {      practiceid: req.session.p_id,         $and:[           {             $or:[{status : 0,statusdate1:{$gte:somedate}}],              $or:[{status : 1,statusdate2:{$gte:somedate}}],              $or:[{status : 2,statusdate3:{$gte:somedate}}],              $or:[{status : 3,statusdate4:{$gte:somedate}}]          }     ]   }

}

syntax :- { $or: [ expression1, expression2, ... ] }

see if you:- 

var match =  { $match: {  $and: [      { practiceid: req.session.p_id },       {         $or:[{status : 0, statusdate1:{$gte:somedate}},              {status : 1, statusdate2:{$gte:somedate}},              {status : 2, statusdate3:{$gte:somedate}},              {status : 3, statusdate4:{$gte:somedate}}]      }] } }

added , separated condition inside $or . see $or


Comments

Post a Comment

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

-
so when requesting group sequelize follows: return models.workingcalendar .findall({ attributes: [ 'workingcalendar.periodid', 'workingcalendar.date', 'period.name' ], include: [ { model: models.period, attributes: [] } ], where: { getsudoid: currentgetsudo.id, unitplantid: unitplantid }, group: ['workingcalendar.periodid', 'workingcalendar.date', 'period.name'], }); sequelize run query: select [workingcalendar].[id], [workingcalendar].[periodid], [workingcalendar].[date], [period].[name] [workingcalendars] [workingcalendar] left outer join [periods] [period] on [wor...
Read more

delphi - Take screenshot in webcam using VFrames in Console Application -

-
i'm doing program take picture of webcam using delphi xe2 , vframes achieve this, problem have figured out, in graphic application works fine, when use unit in console application, returns me error saying first chance exception @ $76b6b727. exception class eaccessviolation message 'access violation @ address 004a271b in module 'console.exe'. read of address 00000260'. process console.exe (3676) my unit : unit webcam; interface uses sysutils, windows, vcl.imaging.jpeg, vcl.graphics, vsample, vframes, classes; type twebcam = class private procedure newvideoframeevent(sender: tobject; width, height: integer; dataptr: pointer); public constructor create; destructor destroy; override; procedure capture_webcam(take_name: string); end; var web_image: tvideoimage; name_screen: string; implementation constructor twebcam.create; begin inherited create; end; destructor twebcam.destroy; begin inherited destroy; end; ...
Read more

ubuntu - Executors lost when starting pyspark in YARN client mode -

-
i able run pyspark in yarn client mode in laptop , trying setup in laptop. however, time can't running. when try start pyspark in yarn client mode, gives me following error. using dynamic resource allocation, have set spark_executor_memory less yarn container memory. using hadoop 2.6.4, spark 1.6.1, ubuntu 15.10 is possible error due network issues? 16/06/12 01:49:34 info scheduler.dagscheduler: executor lost: 1 (epoch 0) in [1]: 16/06/12 01:49:34 info cluster.yarnclientschedulerbackend: disabling executor 1. 16/06/12 01:49:34 info storage.blockmanagermasterendpoint: trying remove executor 1 blockmanagermaster. 16/06/12 01:49:34 info storage.blockmanagermasterendpoint: removing block manager blockmanagerid(1, 192.168.2.16, 37900) 16/06/12 01:49:34 error client.transportclient: failed send rpc 9123554941984942265 192.168.2.16/192.168.2.16:47630: java.nio.channels.closedchannelexception java.nio.channels.closedchannelexception 16/06/12 01:49:34 info storage.blockmanagermast...
Read more