Change mySql code to mongodb. any one know how to do it?

BEGIN

SET @sql = NULL; SELECT GROUP_CONCAT(DISTINCT CONCAT( ‘MAX(IF(c.role_id = ‘’’, c.role_id, ‘’’, true, false)) AS ‘’’, role_name, ‘’’’ ) ) INTO @sql FROM tbl_role c;
SET @sql = CONCAT('Select staff.user_name, ‘, @sql, ’ From tbl_staff staff Left Join tbl_staffRole staffRole On staff.user_name = staffRole.user_name Left Join tbl_role c On c.role_id = staffRole.role_id Group by staff.user_name’);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END

Hi :wave: @Hiral_Makwana,

I hope it helps!

Best,
Kushagra

@Kushagra_Kesav
Thanks for reply…
already find solution for half queries as i know mongodb aggregation up to middle level .