Level 1
you can first get request keys and foreach on it and do you filter
Jul 23, 2020
6
Level 3
Query and filter tips?
Hi, everyone, currently I'm using if condition on request to check for specific query param and filter it in eloquent query builder. I think you can imagine my problem! Is there a simple way to handle all of this?
Level 55
You can use "only" to select only the data you want from request
For example:
request()->only('brand', 'category', 'size')
will return array with the parameter from the requested set. For example, if only brand presented in request - you'll have array with 1 element only, if brand and size - result will have array with 2 elements
For more details you can check documentation
https://laravel.com/docs/master/requests#retrieving-input
subsection Retrieving A Portion Of The Input Data
Level 80
@gthell If only there were a video on this very site for that…
Level 3
@martinbean local scope it is :D
Level 80
@gthell Well, no. If you watch the video I gave you the link to, you could create a class that add clauses to your query builder instance based on items in the query string.
It means you then have a class solely responsible for filtering and sorting, and your models don’t get full of scopes that are inspecting HTTP requests (which they shouldn’t do).
Level 3
@martinbean I think I get the idea. Thank man! I've done it now and got my filtering working fine.
Back then I use to build a much complicated query builder to handle DevExpress datagrid but now I only want thing to be simpler haha
Please or to participate in this conversation.