find not returning all fields

[biancalana]

Hi,

I added some fields to the gfs_file record:

-record(gfs_file, {recindex = 3, docid, filename, contentType, length, chunkSize, uploadDate, aliases, metadata, md5, delId}).

When I find some file using:

Mongo:find(?MONGO_FILES_COLLECTION,#search{criteria = #gfs_file{docid = Docid}})

The filename and metadata fields are never returned.

Any hint about that ?

[SergejJurecko]

Did you recompile both mongoapi and mongodb?

[biancalana]

yes

[SergejJurecko]

Check with mongo program, are they stored in the DB correctly?

[biancalana]

already checked, the data is stored in the DB.

[SergejJurecko]

Are the fields in mongo int he same sequence as in the record?

[biancalana]

I will check that, but this is a requirement ?

[SergejJurecko]

Yes record serialization does not work properly if field sequence in the DB is not the same as the record. It's a purposeful limitation to avoid a double loop when deserializing BSON from the DB (for every field in BSON, search for a matching field in the record).

[biancalana]

I understand.

Do I have any alternative to avoid this limitation ?

[SergejJurecko]

Proplists :)

[biancalana]

So the query using Proplists could be this ?

Mong:find(?MONGO_FILES_COLLECTION, [{"_id", DocId}]).

I'm without access to the environment now, could you say what this will return ?

Thank you for your time.

[SergejJurecko]

findOne
It should return the document in proplist format. Something like [{<<"_id">>,ID},{<<"filename">>,Name},....]