$where is not allowed in this context, but request correctly.

[Qu1eeeOJ]

Hello, I wrote such a request using laravel ORM.

If you insert this request directly into mongodb, then the request is correct, but in laravel it gives an error: $where is not allowed in this context

There my ORM Request:

Item::query()->select('account_id', 'item_id', 'offer_id', 'fbo_sku', 'fbs_sku', 'barcodes')
  ->orWhere('item_id', ''like,  "%{$searchable}%")
  ->orWhere('name', 'like', "%{$searchable}%")
  ->orWhereRaw(['$where' => "/^{$searchable}.*/.test(this.item_id)"])
  ->orWhereRaw(['$where' => "/^{$searchable}.*/.test(this.fbo_sku)"])
  ->orWhereRaw(['$where' => "/^{$searchable}.*/.test(this.fbs_sku)"])
  ->get();

Exception:

MongoDB\Driver\Exception\CommandException {#1421 // app/Services/DataTables/DataTableService.php:138
  #message: "$where is not allowed in this context"
  #code: 2
  #file: "/var/www/project/vendor/mongodb/mongodb/src/Operation/Aggregate.php"
  #line: 379
  #errorLabels: null
  #resultDocument: {#1422
    +"ok": 0.0
    +"errmsg": "$where is not allowed in this context"
    +"code": 2
    +"codeName": "BadValue"
  }

[GromNaN]

I just tried the provided request and didn't get any error. I used on version 4.0.0-rc1, what is your version?

Alternatively you should use MongoDB\BSON\Regex objects to perform regex queries. You could build the query like this instead of using $where.

use MongoDB\BSON\Regex;
Item::query()->select('account_id', 'item_id', 'offer_id', 'fbo_sku', 'fbs_sku', 'barcodes')
  ->orWhere('item_id', new Regex(preg_quote($searchable), 'i'))
  ->orWhere('name', new Regex(preg_quote($searchable), 'i'))
  ->orWhere('fbo_sku', new Regex('^'.preg_quote($searchable), ''))
  ->orWhere('fbs_sku', new Regex('^'.preg_quote($searchable), ''))
  ->get();

[Qu1eeeOJ]

I'm sorry, but how can I now correctly count documents by integer fields?

Will your answer above work for non-number type fields?

[GromNaN]

I don't understand your question. Please provide an example of your data and the expected results, and how you are trying to do.

[Qu1eeeOJ]

I have the fields fbo_sky, fbs_sky - these fields are of type int32, then how can I now count documents using regular expressions on them?

[GromNaN]

You need to create a raw aggregation and group by this fields. The type of this fields doesn't matter.

https://www.mongodb.com/docs/manual/reference/operator/aggregation/count/#behavior

With Laravel-mongodb, use the Model::raw()->aggregate() method.

[Qu1eeeOJ]

Understood, thank you very much for your help!