Create Query based on User selection

Hi! I am working on a project with Laravel 8 and one of the requiraments is to export data to Excel I found the library Laravel Excel and it is working fine. Then I have created a view where the user selects a table then It show all related tables to it and the user can continue selecting the related tables he wants after that the user selects all attributes he needs from each table. So the issue or what I can not find how to solve is to create a query based on what the user has selected. I hope someone has an idea how can I do this.

SilenceBringer

3 years ago

Level 55

@esamuhammad403 you can check GraphQL https://graphql.org/ - it serves exactly for this reason

Alternatively, you can try something like https://spatie.be/docs/laravel-query-builder/v5/introduction it allows to send requesred relationships https://spatie.be/docs/laravel-query-builder/v5/introduction#content-including-relations-based-on-a-request-usersincludeposts and fields you need https://spatie.be/docs/laravel-query-builder/v5/introduction#content-selecting-fields-for-a-query-usersfieldsidemail via query

asss02

3 years ago

Level 2

@SilenceBringer Thanks, I'll give it a try.

Please or to participate in this conversation.