Dynamic method to pass Laravel Eloquent query parameters

Question

I have the following query parameters in string format

$query = '->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request(' startTime'), request('endTime')])';

How do I pass it to Eloquent? I'm trying to achieve something like this

InboundMessage::query()->{$query};

I got the following error

Properties[->whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime' ), request('endTime')])] does not exist on the Eloquent builder instance. 

Answer 1

The problem with the above query is that it looks like this

InboundMessage::query()->->whereIn('short_code', ["9999"])..

Since you used -> in both the query builder and the $query string. So just adjust your $query to

$query = 'whereIn('short_code', ["9999"])->whereBetween('request_timestamp', [request('startTime'), request('endTime')])';