Find method on embedded document is returning null in symfony mongo

Question

I am new to symfony and creating project using mongodb as database. I am using embedded document in order to achieve multi-level database. Below are two document files I am using:
Documents:

namespace AppBundle\Document;

/**
 * @MongoDB\Document()
 */
class State
{
    /**
     * @MongoDB\Id()
     */
    protected $id;

    /**
     * @MongoDB\Field(type="string")
     */
    protected $name;

    /**
     * @MongoDB\Field(type="string")
     */
    protected $code;

    /**
     * @MongoDB\EmbedMany(targetDocument="City")
     */
    protected $cities = array();

    /**
     * State constructor.
     */
    public function __construct()
    {
        $this->cities = new ArrayCollection();
    }

    /**
     * @return mixed
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * @param mixed $id
     */
    public function setId($id)
    {
        $this->id = $id;
    }

    /**
     * @return mixed
     */
    public function getName()
    {
        return $this->name;
    }

    /**
     * @param mixed $name
     */
    public function setName($name)
    {
        $this->name = $name;
    }

    /**
     * @return mixed
     */
    public function getCode()
    {
        return $this->code;
    }

    /**
     * @param mixed $code
     */
    public function setCode($code)
    {
        $this->code = $code;
    }

    /**
     * @return City[]
     */
    public function getCities()
    {
        return $this->cities;
    }

    /**
     * @param City $city
     */
    public function addCities(City $city)
    {
        $this->cities[] = $city;
    }
} 

/**
 * @MongoDB\EmbeddedDocument()
 */
class City
{
    /**
     * @MongoDB\Id
     */
    protected $id;

    /**
     * @MongoDB\Field(type="string")
     */
    protected $name;

    /**
     * @return mixed
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * @param mixed $id
     */
    public function setId($id)
    {
        $this->id = $id;
    }

    /**
     * @return mixed
     */
    public function getName()
    {
        return $this->name;
    }

    /**
     * @param mixed $name
     */
    public function setName($name)
    {
        $this->name = $name;
    }

}

I am properly able to add data to database and preview of it displayed below:

{
    "_id" : ObjectId("59783f79d6faef0dc13cc8ce"),
    "name" : "New South Wales",
    "code" : "NSW",
    "cities" : [
        {
            "_id" : ObjectId("59783f79d6faef0dc13cc8cf"),
            "name" : "Sydney"
        }
    ]
}

And now I am getting data using method "find()" with it's id:

$city = $this->get('doctrine_mongodb')
->getManager()
->getRepository('AppBundle:City')
->find("59783f79d6faef0dc13cc8cf");

So, Problem here is:

I am receiving null in $city. How can I get details of city like name?

malarzm · Accepted Answer · 2017-07-27 08:37:41Z

1

You have mapped City as an embedded document thus it can't exist without its parent document. The only way you can get it is fetching the State and then iterating through $state->getCities(). If you need to query for cities, you need references so City would become a first class document with its own collection Mongo can scan.

answered Jul 27, 2017 at 8:37

malarzm

2,9862 gold badges17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AnkitJ Over a year ago

So, Is it possible to find parent "State" details from available id of city using document manager?

malarzm Over a year ago

Yes, you'll need to employ Query Builder and read about $elemMatch

Collectives™ on Stack Overflow

Find method on embedded document is returning null in symfony mongo

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related