Retrieve document and all nested documents in Cloud Firestore

[lazharichir]

Hello,

I have a collection called Articles containing article documents. Each article document has some fields (title, author, you get the gist) and a sub-collection Blocks which represent paragraphs, sub-titles, images, etc.

I am easily getting the Article object but I have to do another query to receive the Block objects it contains; i.e. two network round-trips, which is not ideal.

Is there are way to query the article in question and retrieve its sub-collections and their documents in full?

/**
 * Populates this object from a database document
 * @param  Google\Cloud\Firestore\DocumentReference &$document Document reference
 * @return object            The populated object
 */
public function populate( &$document ) {

	$snapshot = $document->snapshot();

	$this->setId($snapshot->id() ?? null);

	$this->account 	= $snapshot['account'];
	$this->title 	= $snapshot['title'] ?? 'No title ('.time().')';
	$this->status 	= $snapshot['status'] ?? 'draft';
	$this->seeds 	= [];
	$this->blocks 	= [];

	$blockCollection = $this->firestore()->collection($document->path().'/Blocks');
	# now i have to fetch the documents from this Article's Block subcollection.
}

[jdpedrie]

Hey @lazharichir, I'm working on getting an answer for this. We'll follow up shortly.

[jdpedrie]

@lazharichir we currently do not have support for this operation. It is planned, but I can't give an estimate at this time.

[lazharichir]

Awesome, no rush on my side, but would be a very useful and handy feature:)

…

On Wed, Nov 29, 2017, 19:04 John Pedrie ***@***.***> wrote: @lazharichir <https://github.com/lazharichir> we currently do not have support for this operation. It is planned, but I can't give an estimate at this time. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#761 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ALpkTGiYRWFsqmEktxB4o4ceVk4jUCnkks5s7ZzGgaJpZM4QsEbl> .

[jdpedrie]

Moving this to the new Feature Request wiki page.