Guest User

Untitled

a guest
Jan 22nd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.66 KB | None | 0 0
  1. db.VERISK_METADATA_COLLECTION.aggregate([
  2. { "$match":{contentType:"FRM"}},
  3. { "$project":{ "appCount": {$size:"$applicability"}}},
  4. { "$group": { "_id":null, Total: {$sum:"$appCount" } }},
  5. { "$project": {Total:1,"_id":0}}
  6. ])
  7.  
  8. {
  9. "_id" : "04c64247-7030-4b0e-a2f9-da77d27b8667",
  10. "_class" : "com.mongodb.BasicDBObject",
  11. "documentType" : "doc",
  12. "stateType" : "AZ",
  13. "availabilityDate" : "",
  14. "multiState" : "false",
  15. "language" : "E",
  16. "title" : "ARIZONA LIMITED EXCLUSION OF ACTS OF TERRORISM (OTHER THAN CERTIFIED ACTS OF TERRORISM); CAP ON LOSSES FROM CERTIFIED ACTS OF TERRORISM; COVERAGE FOR CERTAIN FIRE LOSSES",
  17. "displayFormNumber" : "FP 10 53 09 05",
  18. "mandatory" : "N",
  19. "client_id" : "VERISK_001",
  20. "ignored_record_type" : "new_publish_insert",
  21. "formLobType" : "FR",
  22. "formNumber" : "FP10530905",
  23. "job_queue_id" : "f8ac839f-24ee-4063-bc3c-7ed00eb91f11",
  24. "contentType" : "FRM",
  25. "directoryName" : "FRFORMS",
  26. "formsType" : "E",
  27. "objectTypeCode" : "13",
  28. "documentName" : "FP10539O",
  29. "doc_id" : [
  30. "f3f528e2-32ca-49f8-b287-b436befae779"
  31. ],
  32. "update_date" : "2017-12-27 21:05:21.189 EST",
  33. "earliestEffectiveDate_dt" : "2005-09-01T00:00:00Z",
  34. "formStatus" : "H",
  35. "applicability" : [
  36. {
  37. "filingId_dbValue_str" : "CL-2005-OFOTR",
  38. "jurisdiction" : "AZ",
  39. "withDrawnDate" : "2008-10-01T00:00:00Z",
  40. "filingId" : "CL-2005-OFOTR",
  41. "derivedFrom" : "",
  42. "id" : "0ef65042-6b35-460e-b12a-46766c64ff27",
  43. "circularNumber" : "LI-FR-2005-121",
  44. "lob" : "FR",
  45. "effectiveDate" : "2005-09-01T00:00:00Z",
  46. "circularDate" : "2005-07-15T00:00:00Z"
  47. }
  48. ],
  49. "created_date" : "2017-12-27 21:05:21.106 EST",
  50. "uri" : "VERISK_001/FRM/FP10530905"
Add Comment
Please, Sign In to add comment