mongodb - springdata mongo nested properties query -
i have below document corresponding pogo
class wrapper { string id //document id corresponding field string defaultversion string name list<versionedinfo> versions } class versionedinfo { string version .. few otherproperties }
as of document , findout default version corresponding versionedinfo, complete document , loop on versions property list , compare version defaultverion property i.e (groovy)
wrapper document = repository.findone ("id") versionedinfo defaultversionedinfo = document.versions.find { it.version == document.defaultversion }
is there better alternative query document pull defaultversion corresponding versionedinfo using projections? or querydsl?
i'm not sure if below considerations should you. me defines rules (similar).
if application retrieves versionedinfo data defaultversion information, application needs issue multiple queries resolve references. more optimal schema embed versionedinfo data entities in defaultversion (source docs mongodb). see: http://docs.mongodb.org/manual/tutorial/model-embedded-one-to-many-relationships-between-documents/
considerations on references: when using references, growth of relationships determine store reference. http://docs.mongodb.org/manual/tutorial/model-referenced-one-to-many-relationships-between-documents/
Comments
Post a Comment