search

nightroman / Mdbc

MongoDB Cmdlets for PowerShell
Apache License 2.0
141 stars 16 forks source link

How can I use find with case insensitivity #41

Closed pressplay21 closed 4 years ago

pressplay21 commented 4 years ago

Powershell variable:

$site_name = "TestSite"

Get-MdbcData @{ site_name = @{ '$regex' = [regex]"/$site_name/i" } }

The above code does not find the site name "testsite" in mongodb.

pressplay21 commented 4 years ago

Nevermind. I figured it out.

Get-MdbcData @{site_name = @{ '$regex' = $site_name ; '$option' = 'i'} }

yvesgermain commented 1 year ago

I am trying to get a case insensitve search to work also. I am getting this error : get-mdbcData -filter @{"Server" = @{ '$regex' = "NWSVMED"; '$option' = 'i'}} Get-MdbcData: Command find failed: unknown operator: $option.

nightroman commented 1 year ago

@yvesgermain Try $options, see -- https://www.mongodb.com/docs/manual/reference/operator/query/regex/