Multi value delimiter

Sometimes values to filter for could include commas. This is why you can specify the delimiter symbol using the QueryBuilderRequest to overwrite the default behaviour.

// GET /api/endpoint?filter=12,4V|4,7V|2,1V QueryBuilderRequest::setArrayValueDelimiter('|'); QueryBuilder::for(Model::class) ->allowedFilters(AllowedFilter::exact('voltage')) ->get(); // filters: [ 'voltage' => [ '12,4V', '4,7V', '2,1V' ]] 

Note that this applies to ALL values for filters, includes and sorts

##Usage

There are multiple opportunities where the delimiter can be set.

You can define it in a ServiceProvider to apply it globally, or define a middleware that can be applied only on certain Controllers.

// YourServiceProvider.php public function boot() { QueryBuilderRequest::setArrayValueDelimiter(';'); } // ApplySemicolonDelimiterMiddleware.php public function handle($request, $next) { QueryBuilderRequest::setArrayValueDelimiter(';'); return $next($request); } 

You can also set the delimiter for each feature individually:

QueryBuilderRequest::setIncludesArrayValueDelimiter(';'); // Includes QueryBuilderRequest::setAppendsArrayValueDelimiter(';'); // Appends QueryBuilderRequest::setFieldsArrayValueDelimiter(';'); // Fields QueryBuilderRequest::setSortsArrayValueDelimiter(';'); // Sorts QueryBuilderRequest::setFilterArrayValueDelimiter(';'); // Filter 

You can override the default delimiter for single filters:

// GET /api/endpoint?filter[id]=h4S4MG3(+>azv4z/I<o>,>XZII/Q1On AllowedFilter::exact('id', 'ref_id', true, ';');