mysql - 如何在 MongoDB 查询中编写此 SQL 查询？

Question

1.这里@xyz 是变量
2.我在MongoDB 中需要这个查询

SELECT AdminUserID,AdminUserName,Email,ProfileImage,AU.IsActive,CreatedDt,LastUpdatedDt,AU.UserID,U.Username,U.Password
FROM AdminUser AS AU WITH(NOLOCK) LEFT JOIN [User] AS U ON U.UserID = AU.AdminUserUserID AND U.IsDeleted = 0  
WHERE AU.IsDeleted = 0  
    AND AU.IsActive = ISNULL(@IsActive, AU.IsActive)  
    AND AdminUserID = ISNULL(@AdminUserID, AdminUserID)  
    AND AdminUserName = ISNULL(@AdminUserName, AdminUserName)   
    AND AU.UserID=ISNULL(@UserID,AU.UserID)  
    AND ISNULL(AU.AdminUserUserID,'') = ISNULL(@AdminUserUserID,ISNULL(AU.AdminUserUserID,''))  
ORDER BY AdminUserName  

标签： mysqlmongodb