-
Type:
Question
-
Status: Closed
-
Priority:
Major - P3
-
Resolution: Duplicate
-
Affects Version/s: 3.2.1
-
Fix Version/s: None
-
Component/s: Querying
-
Labels:None
I am testing MongoDB to find out if it would be a solution to automate a task.
To achieve this task, I have to import around 20,000 xml files in to MondoDB collection which I think it's really suite for MondodB.
I tested with mongo v3.2 and mongo compass to verify most possible queries what I need to use.
While I am testing after import 2 xml files after I converted to json format, found some of queries are returned with no values but some of them are OK.
Following is successful case;
> a.find ( {"ChangeHolderProfile.SequenceOrderPerMedia":1} ).pretty()
|
{
|
"_id" : ObjectId("56d15af5c1b54590d5dc1f50"),
|
"ActionList" : {
|
"publishedDateID" : "20140104000021",
|
"xsdVersion" : 2,
|
"externalVersion" : 487,
|
"managerRefNumber" : 2
|
},
|
"ReloadTPurse" : {
|
"CardGenerationNumber" : 0,
|
"CardSerialNumber" : NumberLong("1184365732964992"),
|
"ExpirationDate" : "2014-03-04T00:00:00.000+13:00",
|
"RefNumber" : 284617,
|
"SequenceOrderPerMedia" : 4,
|
"ValueToAdd" : 2975,
|
"FeeValue" : 25,
|
"FeeGSTValue" : 0
|
},
|
"ChangeHolderProfile" : {
|
"CardGenerationNumber" : 0,
|
"CardSerialNumber" : NumberLong("1201849732246144"),
|
"ExpirationDate" : "2014-03-04T00:00:00.000+13:00",
|
"RefNumber" : 284616,
|
"SequenceOrderPerMedia" : 1,
|
"HolderBirthDate" : "1996-03-08+13:00",
|
"HolderProfileID" : 0,
|
"HolderProfileValidityDate" : "1990-01-01+13:00"
|
}
|
}
|
Following case has returned no values
> db.actionlist1.find( {"ReloadTPurse.CardSerialNumber":1208467063778432})
|
>
|
I have tested same case with Mongo compass but result are same.
All of data in this case is test data so I have attached a sample json file here so please advise me why I could not get any data when I query with CardSerialNumber ?
- duplicates
-
SERVER-6439 Duplicate fields at the same level should not be allowed
-
- Open
-