Returns "$numberLong" instead of number

Working with Data Developer Tools
,
1

Hi,
I’m trying to retrieve JSON document from the mongodb using Compass. I queried using the “_id” and copied the document. Below is the document I see:


 {
      "Status": "Completed",
      "Score": [
        {
          "score": {
            "$numberLong": "25"
          },
          "title": "Screen Test",
          "maxScore": {
            "$numberLong": "41"
          }
        },
        {
          "score": [
            {
              "score": {
                "$numberLong": "5"
              },
              "comments": [
                {
                  "text": "Range of grammar structures"
                },
                {
                  "text": "Errors"
                },
                {
                  "text": "Range and control of vocabulary"
                },
                {
                  "text": "Control of mechanics"
                }
              ],
              "maxPoints": {
                "$numberLong": "5"
              },
              "description": "Test",
              "_id": "60e061d1b1aab9d7e4be0525",
              "label": "Language"
            },
            {
              "score": {
                "$numberLong": "5"
              },
              "comments": [
                {
                  "text": "Chat management"
                },
                {
                  "text": "Coherence and cohesion"
                }
              ],
              "maxPoints": {
                "$numberLong": "5"
              },
              "description": "Test",
              "_id": "60e061d1b1aab9d7e4be0523",
              "label": "Discourse"
            },
            {
              "score": {
                "$numberLong": "5"
              },
              "comments": [
                {
                  "text": "Positive relationship"
                },
                {
                  "text": "Managing feelings"
                },
                {
                  "text": "Age/culture/gender awareness"
                },
                {
                  "text": "Interactive strategies"
                }
              ],
              "maxPoints": {
                "$numberLong": "5"
              },
              "description": "test",
              "_id": "60e51ae3c80f6a2528e0589d",
              "label": "Interpersonal"
            },
            {
              "score": {
                "$numberLong": "5"
              },
              "comments": [
                {
                  "text": "Understanding and addressing purpose of task"
                }
              ],
              "maxPoints": {
                "$numberLong": "5"
              },
              "description": "test",
              "_id": "60e51ae3c80f6a2528e0589c",
              "label": "Solution"
            }
          ],
          "title": "Conduent Chat Assessment"
        },
        {
          "score": [
            {
              "score": {
                "$numberLong": "5"
              },
              "comments": [],
              "maxPoints": {
                "$numberLong": "5"
              },
              "description": "Pronunciation",
              "_id": "5bced1234f238d8eb40b84f5",
              "label": "Pronunciation"
            },
            {
              "score": {
                "$numberLong": "5"
              },
              "comments": [],
              "maxPoints": {
                "$numberLong": "5"
              },
              "_id": "5bced1234f238d8eb40b84f4",
              "label": "Language"
            },
            {
              "score": {
                "$numberLong": "5"
              },
              "comments": [],
              "maxPoints": {
                "$numberLong": "5"
              },
              "_id": "5bced1234f238d8eb40b84f3",
              "label": "Discourse"
            },
            {
              "score": {
                "$numberLong": "3"
              },
              "comments": [],
              "maxPoints": {
                "$numberLong": "5"
              },
              "_id": "5bced1234f238d8eb40b84f2",
              "label": "Interactive"
            }
          ],
          "title": "Voice Assessment"
        }
      ],
      "PDF": "",
      "Assessment Order ID": "12345",
      "Candidate Email Address": "tester1234@mailinator.com",
      "Assessment Name": "Screentest-Chat-VA",
      "Completed Date": "2023-09-22T20:08:00.725Z"
    }

My expectation is that I should not see $numberLong as I’ve not inserted those values. I tried the same using Mongoshell by running the command:
.find({_id:“req-1695414301196-60dadd30-f6e0-4e73-b538-0ff68cd30dcb”});
I got the below result:

 {
Status: 'Completed',
Score: [
  {
    score: 25,
    title: 'Screen Test',
    maxScore: 41
  },
  {
    score: [
      {
        score: 5,
        comments: [
          {
            text: 'Range of grammar structures'
          },
          {
            text: 'Errors'
          },
          {
            text: 'Range and control of vocabulary'
          },
          {
            text: 'Control of mechanics'
          }
        ],
        maxPoints: 5,
        description: 'Test',
        _id: '60e061d1b1aab9d7e4be0525',
        label: 'Language'
      },
      {
        score: 5,
        comments: [
          {
            text: 'Chat management'
          },
          {
            text: 'Coherence and cohesion'
          }
        ],
        maxPoints: 5,
        description: 'Test',
        _id: '60e061d1b1aab9d7e4be0523',
        label: 'Discourse'
      },
      {
        score: 5,
        comments: [
          {
            text: 'Positive relationship'
          },
          {
            text: 'Managing feelings'
          },
          {
            text: 'Age/culture/gender awareness'
          },
          {
            text: 'Interactive strategies'
          }
        ],
        maxPoints: 5,
        description: 'test',
        _id: '60e51ae3c80f6a2528e0589d',
        label: 'Interpersonal'
      },
      {
        score: 5,
        comments: [
          {
            text: 'Understanding and addressing purpose of task'
          }
        ],
        maxPoints: 5,
        description: 'test',
        _id: '60e51ae3c80f6a2528e0589c',
        label: 'Solution'
      }
    ],
    title: 'Conduent Chat Assessment'
  },
  {
    score: [
      {
        score: 5,
        comments: [],
        maxPoints: 5,
        description: 'Pronunciation',
        _id: '5bced1234f238d8eb40b84f5',
        label: 'Pronunciation'
      },
      {
        score: 5,
        comments: [],
        maxPoints: 5,
        _id: '5bced1234f238d8eb40b84f4',
        label: 'Language'
      },
      {
        score: 5,
        comments: [],
        maxPoints: 5,
        _id: '5bced1234f238d8eb40b84f3',
        label: 'Discourse'
      },
      {
        score: 3,
        comments: [],
        maxPoints: 5,
        _id: '5bced1234f238d8eb40b84f2',
        label: 'Interactive'
      }
    ],
    title: 'Voice Assessment'
  }
],
PDF: '',
'Assessment Order ID': '12345',
'Candidate Email Address': 'tester1234@mailinator.com',
'Assessment Name': 'Screentest-Chat-VA',
'Completed Date': '2023-09-22T20:08:00.725Z'
}
}

Result from mongshell appears fine. How could I get a similar result from compass? I’m on Mac and compass version is Version 1.39.4 (1.39.4) which is the latest.

2

When you do the export, have you tried changing the Advanced JSON format setting? Example:

image
image1118×838 68.1 KB

Regards,
Jason

3

Procedure noted here. However, for Relaxed Extended JSON the note on the docs state:

This format is not recommended for data integrity.

4

Thanks for the reply. I’m not talking about export, but I’m copy pasting directly from Mongo Compass.

image
image2178×870 66.3 KB

I’m copying the document using the icon and pasting it in text editor.

5

Gotcha. Thanks for clarifying. I think it may have to do with the data type, for example:

image
image2850×1164 233 KB

Field a and b with Int32 and Int64 respectively. When copying these and pasting onto a text editor:

{
  "_id": {
    "$oid": "6514dafb852b55cce0fb68c3"
  },
  "a": 1,
  "b": {
    "$numberLong": "1"
  }
}

Perhaps using the embedded mongosh might be work for you? (as per screenshot above).

Regards,
Jason