When using the select-list filter in a row the list is incomplete.
When using the select-list filter in a row the list is incomplete.
Laravel
Bootstrap 4
I'm attached images to illustrate the problem. My partner enable one of the select list rows and we can selectively choose which columns to display the list. What I found is that the list does not display complete results. The results are limited to what displays upon initial page load according to:
pageLength: 10,
If a choice is beyond the first 10 it will not display even if we click on List entries and update to a large number. The workaround solution is to set pageLength to a number greater than the number of rows.
Image 1 - selected 25 to show what is beyond #10 in the email column.
Image 2 - compare result in email filter with the complete list. Both bobs are missing.
Is there a way to make it show all elements regardless of pageLength?
Answers
One of a couple things comes to mind.
data
parameter (see the SSP parameters) sent and when it is1
, (the initial table load) build the select lists and return it with the first response. Then useajax.dataSrc
to process the options to build the client side select options.Kevin
I will have to defer to my associate who knows this stuff better than me. It will be one-two weeks before he can check in.
In the mean time I changed the pageLength to a really high number so it loads all the records and we can choose to switch to 10 if that makes the eyes hurt.
If you sign up for the account according to my instructions in the other posts, you can now test this behavior using either Businesses/Contacts or Businesses/Contracts 2 forms.
I set the length to 10. There are 14 records so 4 extend beyond the first 10. In the City select list filter you will see 4 cities listed.
San Juan Capistrano and City of Angels fall beyond the 10 limit and don't display.
I am not the technical authority here. If you need a tech question answered I will have to ask my associate. Tx
If you sign up for the account according to my instructions in the other posts, you can now test this behavior using either Businesses/Contacts or Businesses/Contracts 2 forms.
I set the length to 10. There are 14 records so 4 extend beyond the first 10. In the City select list filter you will see 4 cities listed.
San Juan Capistrano and City of Angels fall beyond the 10 limit and don't display.
I am not the technical authority here. If you need a tech question answered I will have to ask my associate. Tx
I adjusted the pageLength to 5 to make the problem more obvious.
Please sign up for an account on www.smokeymo.xyz. Ignore the email. Let me know when you have signed up and I will adjust your access level to be able to access the form.
www.smokeymo.xyz/bin/businesses
I posted a couple questions above. Answering those would give us a good idea of what the problem might be. Maybe you or your associate can answer them.
Kevin
I thought he looked at that but I will double-check. Couple days.
We are using server side processing and yes it is currently showing select filters of the visible records.
How do we keep the server side processing functionality which helps performance especially with lots of rows - and still populate the select filters with all available distinct options?
As I said above:
Kevin