Skip to content

Instantly share code, notes, and snippets.

@nfabian13
Created August 5, 2015 15:42
Show Gist options
  • Save nfabian13/83a94238304c2d654fe4 to your computer and use it in GitHub Desktop.
Save nfabian13/83a94238304c2d654fe4 to your computer and use it in GitHub Desktop.
this is the structure of the documents of my database mongoDB collection (mongosails4.case)
{
"_id" : ObjectId("55a907962109d0860b71aff1"),
"appointment" : {
"appointment_time" : null,
"customer_requested_appointment_time" : null,
"label" : "",
"service_slot" : ""
},
"asset" : {
"in_service_date" : null,
"fleet_info" : "WALKJ WILKC",
"asset_description" : "",
"description" : "",
"identifier" : "650190",
"engine" : "----",
"hours" : 0,
"make" : "Freightliner",
"model" : "Cascadia",
"year" : 2015,
"serial" : "FSFN2753",
"unit" : "650190",
"vin" : "3AKJGLD53FSFN2753",
"location" : {
"street" : "",
"city" : "",
"state" : "",
"zip" : "",
"country" : ""
},
"mileage" : 0,
"mileage_units" : "miles",
"pm" : "current"
},
"asset_arrived" : null,
"attachments" : 1,
"authorization_number" : "440889",
"case_status" : "",
"case_url" : "http://dsmppg.decisiv.net/shared/estimates/1305340",
"closed_at" : null,
"complaint" : {
"complaint_description" : "ONGUARD FAULT\r\nLEAK @ DOME\r\nAUTH# 440889",
"vmrs" : {
"system" : "000",
"assembly" : "000",
"component" : "000",
"position" : "",
"identifier" : ""
}
},
"completion_time" : {
"estimated_completion_time" : ISODate("1970-01-01T00:00:00.000Z"),
"actual_completion_time" : null,
"customer_requested_completion_time" : null
},
"correction" : {
"correction_description" : "ONGUARD FAULT\r\nLEAK @ DOME\r\nAUTH# 440889",
"vmrs" : {
"system" : "",
"assembly" : "",
"component" : "",
"position" : "",
"work_accomplished" : ""
}
},
"created_at" : null,
"created_by" : "Jennifer Linder",
"dealer" : {
"identifier" : "57",
"description" : "Springfield Freightliner North",
"location" : {
"identifier" : "DCV-SPFN",
"description" : "Springfield Freightliner North",
"street" : "3759 E Evergreen",
"city" : "Springfield",
"state" : "MO",
"country" : "US",
"zip" : "65803"
},
"person" : {
"identifier" : "Lara Shotwell"
},
"url" : ""
},
"description" : {
"mfr_function_group" : "",
"priority" : "High",
"severity" : 0,
"program_type" : ""
},
"estimate" : {
"estimate_url" : "http://dsmppg.decisiv.net/shared/estimates/1305340/print_redirect",
"description" : "",
"estimate" : 0,
"identifier" : "",
"url" : "http://dsmppg.decisiv.net/shared/estimates/1305340",
"core" : 0,
"core_exempt" : false,
"freight" : 0,
"hazwaste" : 0,
"labor" : 0,
"parts" : 0,
"shop" : 0,
"tax" : 0,
"tax_exempt" : false,
"total" : 0
},
"fleet" : {
"identifier" : "PRIMEFLEET",
"description" : "Prime Inc.",
"location" : {
"identifier" : "10362",
"description" : "Prime Inc.",
"street" : "2740 N. Mayfair",
"city" : "Springfield",
"state" : "MO",
"country" : "US",
"zip" : "65803"
},
"person" : {
"identifier" : ""
}
},
"followup_time" : {
"fleet_followup" : "",
"provider_followup" : ""
},
"identifier" : 1.30534e+06,
"invoice" : {
"case_id" : "",
"description" : "",
"identifier" : "",
"total" : 0,
"core" : 0,
"core_exempt" : false,
"freight" : 0,
"hazwaste" : 0,
"labor" : 0,
"parts" : 0,
"shop" : 0,
"tax" : 0,
"tax_exempt" : false,
"estimate" : 0
},
"notes" : {
"notes_url" : "http://dsmppg.decisiv.net/shared/estimates/1305340/notes_redirect",
"number_ext_notes" : 9,
"last_note" : ISODate("2015-04-23T16:04:09.000Z"),
"last_note_from" : "Prime Inc.",
"year" : 0
},
"operations" : {
"labor_hours" : "",
"ops_status" : "Not Started",
"ops_started_on" : "",
"ops_completed_on" : ""
},
"po_number" : "repairs complete",
"repair_order" : {
"case_id" : "",
"description" : "",
"identifier" : "66270",
"total" : 0,
"core" : 0,
"core_exempt" : false,
"freight" : 0,
"hazwaste" : 0,
"labor" : 0,
"parts" : 0,
"shop" : 0,
"tax" : 0,
"tax_exempt" : false,
"estimate" : 0
},
"stage_fleet_status" : "Open",
"stage_as_label" : "Closed",
"stage" : 12,
"sub_stage_as_label" : "Complete",
"sub_stage" : 3,
"stage_description" : "Complete (gone)",
"stage_updated_at" : null,
"stage_updated_by" : "JOHN MORTON",
"tags" : "",
"tag_number" : "",
"total_downtime" : "",
"updated_at" : null,
"service_request_time" : ISODate("2015-04-02T14:11:51.000Z"),
"source_id" : 277,
"fleet_status_as_label" : "Open",
"fleet_status" : 9,
"return_to_operations_completed_on" : null,
"createdAt" : ISODate("2015-07-17T13:48:06.142Z"),
"updatedAt" : ISODate("2015-07-20T15:28:57.407Z")
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment