大家好，

我正在做一个客户可以发送帐户停用请求的项目，作为管理员，我可以看到列表并在页面上停用它们，在同一页面上我有一个搜索过滤器，可以按姓名、电子邮件和电话号码进行过滤。我有一个集合来保存客户，另一个集合来保存停用请求。我已经完成了列表部分，因为它使用选择查询很简单，但面临通过搜索过滤器获取列表的问题，我在 Go lang 中有以下 2 个结构来获取记录:

 type DeactivationRequest struct {
        Id                          int         `json:"id" bson:"id"`
        Uid                         int         `json:"uid" bson:"uid"`
        RequestTime                 int64       `json:"request_time" bson:"request_time"`
        Status                      int         `json:"status" bson:"status"`
        Note                        string      `json:"note" bson:"note"`
    }

    type User struct {
        Id                         int         `json:"id" bson:"_id,omitempty"`
        FirstName                  string      `json:"first_name,omitempty" bson:"first_name,omitempty"`
        LastName                   string      `json:"last_name,omitempty" bson:"last_name,omitempty"`
        EmailId                    string      `json:"email_id,omitempty" bson:"email_id,omitempty"`
        Password                   string      `json:"password,omitempty" bson:"password,omitempty"`
        PhoneNumber                string      `json:"phone_number,omitempty" bson:"phone_number,omitempty"`
        AltPhoneNumber             string      `json:"alt_phone_number,omitempty" bson:"alt_phone_number,omitempty"`
        Status                     int         `json:"status" bson:"status"`
        Role                       string      `json:"role,omitempty" bson:"role,omitempty"`
    }

I am facing problem with join query to get records based on search keywords for which I have written following code.

    result := []bson.M{}
        skip := 0
        limit := 20
        c := mongoSession.DB("database").C("deactivation_requests")
        pipe := c.Pipe([]bson.M{bson.M{"$match": bson.M{ "status" : 0 }},
                                bson.M{"$lookup": bson.M{
                                                    "localField"    : "_id",
                                                    "from"          : "users",
                                                    "foreignField"  : "uid",
                                                    "as"            : "profile"}},
                                bson.M{"$unwind": "$profile"},
                                bson.M{"$skip": skip},
                                bson.M{"$limit": limit},})
        err = pipe.All(&result)
        if err != nil {
            return result, err
        }

Expected format for the result is as given below:

What is the best way to do this?

Thanks in advance.

<table>
        <tr>
            <th>Name</th>
            <th>Email</th>
            <th>Phone Number</th>
            <th>Note</th>
        </tr>
        <tr>
            <td>Swati Sharma</td>
            <td>swati@swatii.com</td>
            <td>987-999-9999</td>
            <td>I don't want my acount</td>
        </tr>
        <tr>
            <td>James Black</td>
            <td>james@jamess.com</td>
            <td>999-999-3120</td>
            <td>I don't want my acount</td>
        </tr>
    </table>

最佳答案

你好

我找到了查询的答案。我尝试了以下代码，它对我有用。

    result := []bson.M{}
            skip := 0
            limit := 20
            c := mongoSession.DB("database").C("deactivation_requests")
            pipe := c.Pipe([]bson.M{
                                    bson.M{"$lookup": bson.M{
                                                        "localField"    : "_id",
                                                        "from"          : "users",
                                                        "foreignField"  : "uid",
                                                        "as"            : "profile"}},
                                    bson.M{"$unwind": "$profile"},
                                    bson.M{"$match": bson.M{"$or": []bson.M{ 
                                                        bson.M{"profile.first_name":bson.RegEx{"(?i).*"+name+".*", "i"} },
                                                        bson.M{"profile.last_name": bson.RegEx{ "(?i).*"+name+".*", "i"} }, 
                                                        bson.M{"profile.email_id": bson.RegEx{"(?i).*"+name+".*", "i"} }, 
                                                        bson.M{"profile.phone_number": bson.RegEx{".*"+keyword+".*", "i"} }, 
                                                        bson.M{"profile.alt_phone_number": bson.RegEx{".*"+keyword+".*", "i"} }, 
                                    }}},
                                    bson.M{"$skip": skip},
                                    bson.M{"$limit": limit},})
            err = pipe.All(&result)
            if err != nil {
                return result, err
            }

关于mongodb - 如何在 MongoDB 中执行带有搜索的 Joinquery 然后继续？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/46313971/