search by substring in mongodb from powershell

Question

I am trying to make the following mongodb query on powershell:

collection.find({"field1":"valueA","field2":"valueB","field3":/subStr_ValueC/})

I tried to do the following but doesn't work:

$query = @{
            "field1" = $notification["A"]
            "field2" = $notification["B"]
            "field3" = "/" + $notification["C"] + "/"
        }

$cursor = $collection.find([MongoDB.Driver.QueryDocument]$query)

Any idea, how to do this?

thank you very much

Sebastian · Accepted Answer · 2014-05-10 11:38:53Z

2

Give this a try:

$query = @{
  'field1' = $notification['A']
  'field2' = $notification['B']
  'field3' = @{ '$regex' = '.*' + $notification['C'] + '.*'; '$options' = 'i' }
}

$cursor = $collection.find([MongoDB.Driver.QueryDocument]$query)

edited May 10, 2014 at 11:38

answered May 10, 2014 at 11:00

Sebastian

17.6k5 gold badges51 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Sebastian Over a year ago

what do you have in $notification["C"]? Try with "field3" = @{ "$regex" = ".*"; "$options" = "i" } to see if this works.

masber Over a year ago

field3 is a string. It is giving me this error Duplicate keys '' are not allowed in hash literals. using your 2 suggestions

Sebastian Over a year ago

I forgot that it tries to evaluate things in double quotes. Try the updated version (with single quotes).

masber Over a year ago

Yep that worked, why id did not work with double quotes? also I'm wondering if the "i" option is taking more resources as it will compare also capital leters?

Sebastian Over a year ago

Great. You can omit '$options' = 'i' if you want case sensitivity. When you are using double quotes powershell replaces $regex and $options with respective variable values (in this case no variable $regex and $option was there and it resulted in an empty string)

Collectives™ on Stack Overflow

search by substring in mongodb from powershell

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related