首页 \ 问答 \ MongoDB - 从对象内的数组中查找数据(MongoDB - Find Data from a array inside a object)

MongoDB - 从对象内的数组中查找数据(MongoDB - Find Data from a array inside a object)

 我有以下形式的数据库  
{
"_id" : ObjectId("56fc92adcf908c9f296e5885"),
"_class" : "com.abc.ppm.dto.AccessAttemptDTO",
"url" : "/myProject/edit",
"ipAddress" : "127.0.0.1",
"param" : {
    "iecode" : [ 
        "P1234"
    ],
    "id" : [ 
        "5696578c6d34f835dc632fdd "
    ]
},
"accessTime" : "30-3-2016 10:59:57",
"email" : "abc@gmail.com",
"entity" : "admin",
"entityCode" : ""
},

{
"_id" : ObjectId("56fc92adcf908c9f296e5887"),
"_class" : "com.abc.ppm.dto.AccessAttemptDTO",
"url" : "/myProject/edit",
"ipAddress" : "127.0.0.1",
"param" : {
    "iecode" : [ 
        "P1122"
    ],
    "id" : [ 
        "5696578c6d34f835dc632fdd "
    ]
},
"accessTime" : "30-3-2016 10:59:57",
"email" : "abc@gmail.com",
"entity" : "admin",
"entityCode" : ""
 
 }  
 现在我想找到iecode为'P1234'的所有enries。 我怎么做？ （注意：iecodes值以字符串数组格式存储。） 

I have my db in following form 
{
"_id" : ObjectId("56fc92adcf908c9f296e5885"),
"_class" : "com.abc.ppm.dto.AccessAttemptDTO",
"url" : "/myProject/edit",
"ipAddress" : "127.0.0.1",
"param" : {
    "iecode" : [ 
        "P1234"
    ],
    "id" : [ 
        "5696578c6d34f835dc632fdd "
    ]
},
"accessTime" : "30-3-2016 10:59:57",
"email" : "abc@gmail.com",
"entity" : "admin",
"entityCode" : ""
},

{
"_id" : ObjectId("56fc92adcf908c9f296e5887"),
"_class" : "com.abc.ppm.dto.AccessAttemptDTO",
"url" : "/myProject/edit",
"ipAddress" : "127.0.0.1",
"param" : {
    "iecode" : [ 
        "P1122"
    ],
    "id" : [ 
        "5696578c6d34f835dc632fdd "
    ]
},
"accessTime" : "30-3-2016 10:59:57",
"email" : "abc@gmail.com",
"entity" : "admin",
"entityCode" : ""
 
} 
Now I want to find all the enries where iecode is 'P1234'. How do I do that? (Note: iecodes value is stored in string array format.)

原文：https://stackoverflow.com/questions/37087048

更新时间：2022-09-06 13:09

最满意答案

 解决方案很简单，但IDE和调试器都没有说明它。 它只返回null 。 当您使用php artisan config:cache ，根据文档：  
 
  如果您在部署过程中执行php artisan config:cache命令，则应确保只从配置文件中调用env()函数。  
 
 显然我在配置文件之外有env变量，所以在缓存之后我再也无法在外面使用它了。 php artisan config:clear让它重新投入使用。  
 我发现更多关于env的用法，它只能在配置文件中使用。 您可以使用其他帮助程序方法config()从项目的其余部分访问env变量。 确保将其分配给配置文件中的另一个键，例如'key' => env('CACHE_DRIVER')  
 更重要的是，你必须记住每次你改变.env文件时运行php artisan config:cache 。 Laravel不会加载新值，直到它被缓存。 如果它没有被缓存，则不需要这样做。 

The solution is simple, but not IDE nor debugger tells anything about it. It just returns null. When you use php artisan config:cache, according to documentation: 
 
 If you execute php artisan config:cachecommand during your deployment process, you should be sure that you are only calling the env() function from within your configuration files. 
 
Obviously I have env variables outside the config files, so after caching I was not able to use it outside anymore. The php artisan config:clear puts it back to work. 
What I've found more about the usage of env, that it should be used only within config files. You can access env variables from the rest of the project using other helper method config(). Be sure to assign it to another key in config file, e.g. 'key' => env('CACHE_DRIVER') 
What is more, you have to remember to run php artisan config:cache each time you will change .env file. Laravel will not load the new values, until it's cached. If it's not cached, no need to do it.

MongoDB - 从对象内的数组中查找数据(MongoDB - Find Data from a array inside a object)

最满意答案

相关问答

Laravel 5.2没有阅读env文件(Laravel 5.2 not reading env file)[2022-04-08]

Laravel不会阅读env变量(Laravel does not read env variables)[2023-11-15]

Laravel 5基于.env.master加载env文件？(Laravel 5 load env file based on .env.master?)[2022-08-12]

如何在Laravel 5.1 TestCase中访问.env中的值(How do I access values from .env in Laravel 5.1 TestCase)[2022-07-21]

没有.env文件的命令行生成中的Laravel和环境变量(Laravel and environment variables in command line production without .env file)[2021-11-25]

如何获得ENV类型Laravel + VueJS + Homestead(How to get ENV type Laravel + VueJS + Homestead)[2022-04-28]

使用Figaro和Secrets.yml来管理Env变量(Using Figaro and Secrets.yml to Manage Env Variables)[2023-01-13]

Laravel Artisan - 重新加载.env变量或重启框架(Laravel Artisan - reload .env variables or restart framework)[2022-05-21]

circleci - 无法读取脚本中定义的env变量(circleci - cannot read env variables defined inside script)[2023-03-26]

用Angular阅读Laravel .env文件(Reading Laravel .env file with Angular)[2023-05-27]

相关文章

最新问答