Loading...

XML

Word

Printable

JSON

Type: Question
Resolution: Duplicate
Priority: Major - P3
Fix Version/s: None
Affects Version/s: 3.2.1
Component/s: Querying
Labels:
None

Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
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 ?