Why is a list limited to a max of 31 items?
-
It looks like this only appears when the list has "Use for sets" set to Yes. What does "Use for sets" mean?
-
Thanks Gritly . I need to have 90 values in a "Select (multiple)" field. Do you know how to increase the 31 value limit?
-
Keith Fawcett what list is it where do i find it i can have a look around if you like?
-
Hello Keith Fawcett !
As UNA stores the results of similar fields as Bit mask it can't have too big values because the number of all stored variants easily may exceed the size of INT. That's why we have limits in the code like:
if (!defined('BX_DOL_INT_MAX'))
define('BX_DOL_INT_MAX', 2147483647);
in inc/params.inc.php
and this one:
define('BX_DOL_STUDIO_FIELD_PRE_VALUE_INT_MAX', round(log(BX_DOL_INT_MAX, 2)));
in studio/classes/BxDolStudioFormsPreValues.php
-
Thanks LeonidS. There really should be a way to add multiple items and be able to have the field reference more than 31 items.
As an example... this field, "Brand", has tons of values, and you can select multiples. If needed, also allows for searching. https://preview.algolia.com/instantsearch/
Other examples that perform a search and allow for multiple selections that references values in DB.
-
Andrew Boon Mark Purser Hi gents, this really could use some attention. Our system needs to allow users to select from 100+ values. Limiting to 31 is not good for us. Is there a way to enhance this part of the system? See some ideas above.
-
LeonidS is right, the limit of 31 values are needed for 32 bit system, if you have 64 bit system then you can increase this limit to 63 values, to do it add the following line in the beginning of your inc/header.inc.php file:
define('BX_DOL_INT_MAX', PHP_INT_MAX); -
Alex T⚜️ LeonidS I understand technically that there is a limit for the current select field because you're adding all values to page. Can you add a new field that allows a user to multi-select values by querying the database at selection time (i.e. Remote Data Loading)? This way you do not have to load all values to page and the user can search and multi-select.
Here are some examples.
https://selectize.github.io/selectize.js/
https://ej2.syncfusion.com/documentation/multi-select/data-binding/
-
Thank you for the examples, we'll plan it for the future:
https://github.com/unaio/una/issues/2411