doolo00026 2016-10-14 06:51
浏览 137

$ ne使用golang(mgo)检查MongoDb中的两个字段

I am using go lang in the back end and mongoDB as my database.In my mgo pipeline i m selecting some values from my mongoDB. Below is the go lang equivalent condition which is working

if status !="Processing"{
//then select or project the values
}

The mgo query is as follows and this is working

pipe10 := c.Pipe([]bson.M{
            {
                "$unwind": "$" + type,
            },
            {
                "$match": bson.M{
                    type + ".status": bson.M{
                        "$ne": "Processing",
                    },
                },
            },
            {
                "$project": bson.M{
                    "name": 1,
                },
            },
        },
        )

but when i try to add another value for $ne this is not working.This doesnt throw error but just it skips this != condition. Below is the go lang equivalent condition which i need to implement and not working

if status !="Processing" || status !="Denied{
    //then select or project the values
    }

I tried as following in mgo

 1.   pipe10 := c.Pipe([]bson.M{
                    {
                        "$unwind": "$" + type,
                    },
                    {
                        "$match": bson.M{
                            type + ".status": bson.M{
                                "$ne":[]interface{"Processing","Denied"}
                            },
                        },
                    },
                    {
                        "$project": bson.M{
                            "name": 1,
                        },
                    },
                },
                )
  2.   pipe10 := c.Pipe([]bson.M{
                    {
                        "$unwind": "$" + type,
                    },
                    {
                        "$match": bson.M{
                            type + ".status": bson.M{
                                "$ne":bson.M{
                              "$in":[]interface{"Processing","Denied"}
                                    },
                                },
                            },
                        },
                    },
                    {
                        "$project": bson.M{
                            "name": 1,
                        },
                    },
                },
                ) 
 3.   pipe10 := c.Pipe([]bson.M{
                    {
                        "$unwind": "$" + type,
                    },
                    {
                        "$match": bson.M{
                            type + ".status": bson.M{
                                "$ne":bson.M{
                              "$or":[]interface{"Processing","Denied"}
                                    },
                                },
                            },
                        },
                    },
                    {
                        "$project": bson.M{
                            "name": 1,
                        },
                    },
                },
                ) 

But these are not working.Appreciate any help.Thanks

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 求lingo代码和思路
    • ¥15 公交车和无人机协同运输
    • ¥15 stm32代码移植没反应
    • ¥15 matlab基于pde算法图像修复,为什么只能对示例图像有效
    • ¥100 连续两帧图像高速减法
    • ¥15 如何绘制动力学系统的相图
    • ¥15 对接wps接口实现获取元数据
    • ¥20 给自己本科IT专业毕业的妹m找个实习工作
    • ¥15 用友U8:向一个无法连接的网络尝试了一个套接字操作,如何解决?
    • ¥30 我的代码按理说完成了模型的搭建、训练、验证测试等工作(标签-网络|关键词-变化检测)