Question on filtering a role column that displays multiple roles using Laravel DataTables

Hello Laracasters, I am new to this forum and fairly new with using Laravel I am looking for some help with a couple of issues I am trying to resolve but I just want to concentrate on one issue for this post. I also hope I am through enough that you can understand what the issue is and able to assist me.

I working on displaying all users in a table.

The columns of the tables are as follows: Name UserName Enable (boolean) Activated (boolean) User Groups (M2MR joined users and roles in a trait class)(multiple roles displayed) Email Last Visit Date Registration Date ID

I have everything working with the datatable except for the four external dropdown filters. State (Enable) Active (Activated) Group (Group Users) Registration Date (Registration Date)

I am currently working on getting the Group dropdown to filter the User Groups columns that can contain multiple roles but I am not sure how to go about this. When I use the filter, I put on a role like Administrator and it appears that it filters because of a couple of users will disappear from the table. The users that are displayed in the table after the filter is applied still shows users not belonging to the administrator group with the users that are in the administrator. I found that the users that are filtered out contains the administrator group role.

The filter is passing the value which is a number. Since the filter is a dropdown control created by Chosen jQuery from the select control the value is being passed as the array element number. How could I get this filter to work to display the correct records on the screen?

I am not sure what code would be useful to display so please let me know what code you want to see and I will post it. If you need more information about what I am trying to do please do not hesitate to ask me.

Using: Laravel 5.4 Laravel-DataTable 7.x laravel-datatables-buttons 1.x laravel-datatables-html" 1.x Chosen jQuery 1.7.0