laravel MongoDB /Jessnegers aggregate get selected columns[Question]

[nrjgit]

My Code

	$cnt = custt::raw(function($collection) {
			return $collection->aggregate(
			[['$match' => ['custstate' => 'MI']]],
			 [

			'$group'    => [
				'_id'   => '$custstate',
				'count' => [
					'$sum'  => 1
				]
				]
			],
			[[
			'$lookup' => [
				'as'=>'info',
				'from'=>'contacts',
				'foreignField'=>'custid',
				'localField'=>'custid'												
						]
					]]);			
			});
			

I only want to retrieve custstate column only , but getting all column from tables .How Can I get only few columns in output . I tried Groupby , but I thnk it is now what meant to do this ..Please suggest

[nrjgit]

I want to use lookup/ join + match/ where / projection/ selected columns combine

…

On Thu, 4 Jun, 2020, 9:50 PM federeggiani, ***@***.***> wrote: Check this https://laracasts.com/discuss/channels/eloquent/select-specific-columns-using-eloquent-orm — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://github.com/jenssegers/laravel-mongodb/issues/2046#issuecomment-638960888>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADA776KE62OCM6F4DOU6U3TRU7CUHANCNFSM4NSJY5NQ> .

[Smolevich]

You can use pipe $project for selecting fields