# Query like Mongodb query

**URL:** <https://discourse.getcockpit.com/t/query-like-mongodb-query/2572>\
**Category:** Uncategorized\
**Created:** [November 25, 2022, 11:26am UTC](https://discourse.getcockpit.com/t/query-like-mongodb-query/2572 "2022-11-25T11:26:30Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![jbeuria](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@jbeuria](https://discourse.getcockpit.com/u/jbeuria)\
**Post date:** [November 25, 2022, 11:26am UTC](https://discourse.getcockpit.com/t/query-like-mongodb-query/2572/1 "2022-11-25T11:26:30Z")

</div>

Hello,

I am trying to query like mentioned in [https://www.mongodb.com/docs/manual/reference/operator/query/regex/#mongodb-query-op.-regex](https://www.mongodb.com/docs/manual/reference/operator/query/regex/#mongodb-query-op.-regex)

When I try using  
GET “[http://localhost:8400/api/content/items/Books?filter={Code:/^BG-/}&populate=1](http://localhost:8400/api/content/items/Books?filter=%7BCode:/%5EBG-/%7D&populate=1)”

It does not return any valid response.

Any suggestions?

Best regards  
JB

---

<div class="post-metadata">

**Author:** ![faridbouchdak](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.getcockpit.com/faridbouchdak/32/1132_2.png) [@faridbouchdak](https://discourse.getcockpit.com/u/faridbouchdak)\
**Post date:** [November 25, 2022, 12:29pm UTC](https://discourse.getcockpit.com/t/query-like-mongodb-query/2572/2 "2022-11-25T12:29:07Z")

</div>

Hi JB,  
I am assuming its a public accessible API, so no token required.  
It seems you want to filter out every document which has the field “Code” and its content starts with “BG-”.  
try:  
[http://localhost:8400/api/content/items/Books?filter=](http://localhost:8400/api/content/items/Books?filter=){Code: {$regex: “/^BG-/”}}&populate=1

---

<div class="post-metadata">

**Author:** ![jbeuria](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@jbeuria](https://discourse.getcockpit.com/u/jbeuria)\
**Post date:** [November 25, 2022, 12:30pm UTC](https://discourse.getcockpit.com/t/query-like-mongodb-query/2572/3 "2022-11-25T12:30:11Z")

</div>

Hi there,

I found some solution. It would be great if someone can elaborate a bit.

GET “[http://localhost:8400/api/content/items/Books?filter={Code:{‘$regex’:‘/^BG-/’}](http://localhost:8400/api/content/items/Books?filter=%7BCode:%7B'%24regex':'/%5EBG-/'%7D)}&populate=1”

with OR

GET “[http://localhost:8400/api/content/items/Books?filter=](http://localhost:8400/api/content/items/Books?filter=){ ‘$or’: [{‘Code’ : {‘$regex’ : ‘/^G-H/’}}, {‘Code’ : {‘$regex’ : ‘/^G-E/’}}]}&populate=1” works

---

<div class="post-metadata">

**Author:** ![jbeuria](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@jbeuria](https://discourse.getcockpit.com/u/jbeuria)\
**Post date:** [November 25, 2022, 12:31pm UTC](https://discourse.getcockpit.com/t/query-like-mongodb-query/2572/4 "2022-11-25T12:31:16Z")

</div>

thanks. I also figured out. Could you share how to use other tags in mongo query.

---

<div class="post-metadata">

**Author:** ![faridbouchdak](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.getcockpit.com/faridbouchdak/32/1132_2.png) [@faridbouchdak](https://discourse.getcockpit.com/u/faridbouchdak)\
**Post date:** [November 25, 2022, 12:41pm UTC](https://discourse.getcockpit.com/t/query-like-mongodb-query/2572/5 "2022-11-25T12:41:01Z")

</div>

I am sorry but I am not sure what you mean with “other tags”.

---

<div class="post-metadata">

**Author:** ![jbeuria](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@jbeuria](https://discourse.getcockpit.com/u/jbeuria)\
**Post date:** [November 25, 2022, 12:47pm UTC](https://discourse.getcockpit.com/t/query-like-mongodb-query/2572/6 "2022-11-25T12:47:15Z")

</div>

I am referring to list of Query Selectors in [https://www.mongodb.com/docs/manual/reference/operator/query/](https://www.mongodb.com/docs/manual/reference/operator/query/)

---

<div class="post-metadata">

**Author:** ![faridbouchdak](https://yyz2.discourse-cdn.com/flex030/user_avatar/discourse.getcockpit.com/faridbouchdak/32/1132_2.png) [@faridbouchdak](https://discourse.getcockpit.com/u/faridbouchdak)\
**Post date:** [November 25, 2022, 1:04pm UTC](https://discourse.getcockpit.com/t/query-like-mongodb-query/2572/7 "2022-11-25T13:04:04Z")

</div>

unfortunately not.  
I found the solution to regex a while ago and could share this quickly 🙂

---

<div class="post-metadata">

**Author:** ![jbeuria](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@jbeuria](https://discourse.getcockpit.com/u/jbeuria)\
**Post date:** [November 25, 2022, 1:05pm UTC](https://discourse.getcockpit.com/t/query-like-mongodb-query/2572/8 "2022-11-25T13:05:44Z")

</div>

anyway, thanks a lot.