title: mongoexport JSON assertion: 10340 Failure parsing JSON string
body: <p>I'm trying to export CSV file list from mongoDB and save the output file to my directory, which is /home/asaj/. The output file should have the following columns: name, file_name, d_start and d_end.
  The query should filter data with status equal to "FU" or "FD", and d_end > Dec. 10, 2012.</p>
  
  <p>In mongoDB, the query is working properly. The query below is limited to 1 data output. See query below:</p>
  
  <pre><code>&gt; db.Samples.find({ $or : [ { status : 'FU' }, { status : 'FD'} ], d_end : { $gte : ISODate("2012-12-10T00:00:00.000Z") } }, {_id: 0, name: 1, file_name: 1, d_start: 1, d_end: 1}).limit(1).toArray();
  [
      {
              "name" : "sample"
              "file_name" : "sample.jpg",
              "d_end" : ISODate("2012-12-10T05:1:57.879Z"),
              "d_start" : ISODate("2012-12-10T02:31:34.560Z"),
      }
  
  ]
  &gt;
  </code></pre>
  
  <p>In CLI, mongoexport command looks like this:</p>
  
  <pre><code>mongoexport -d maindb -c Samples -f "name, file_name, d_start, d_end" -q "{'\$or' : [ { 'status' : 'FU' }, { 'status' : 'FD'} ] , 'd_end' : { '\$gte' : ISODate("2012-12-10T00:00:00.000Z") } }" --csv -o "/home/asaj/currentlist.csv"
  </code></pre>
  
  <p>But i always ended up with this error:</p>
  
  <pre><code>connected to: 127.0.0.1
  Wed Dec 19 16:58:17 Assertion: 10340:Failure parsing JSON string near: , 'd_end
  0x5858b2 0x528cb4 0x52902e 0xa9a631 0xa93e4d 0xa97de2 0x31b441ecdd 0x4fd289
  mongoexport(_ZN5mongo11msgassertedEiPKc+0x112) [0x5858b2]
  mongoexport(_ZN5mongo8fromjsonEPKcPi+0x444) [0x528cb4]
  mongoexport(_ZN5mongo8fromjsonERKSs+0xe) [0x52902e]
  mongoexport(_ZN6Export3runEv+0x7b1) [0xa9a631]
  mongoexport(_ZN5mongo4Tool4mainEiPPc+0x169d) [0xa93e4d]
  mongoexport(main+0x32) [0xa97de2]
  /lib64/libc.so.6(__libc_start_main+0xfd) [0x31b441ecdd]
  mongoexport(__gxx_personality_v0+0x3c9) [0x4fd289]
  assertion: 10340 Failure parsing JSON string near: , 'd_end
  </code></pre>
  
  <p>I'm having error in "<strong>, 'd_end'</strong> " in mongoexport CLI. I'm not so sure if it is a JSON syntax error because query works on MongoDB.
  Please help.</p>