Number of items in Elements Connect select lists are limited to 1000. If you need to access more values, you can add a dependency to the '
$userInput' that can filter values according to what the user is typing
Let's take the same query:
Query without user input
SELECT product FROM catalog
If there are more than 1000 products, they would not all be available in the Connected item select list.
$userInput allows your query to update as your are typing!
Query with user input
SELECT product FROM catalog WHERE product ILIKE '%$userInput%'
(the % are wildcards, the variable itself is just
The query will be updated and resent as the user is typing in the select list.
If you want to search for the product "Pavilion x360", you just need to start typing the model in the Connected item select list and the request will be updated:
Query updated with user input
SELECT product FROM catalog WHERE product ILIKE '%pav%'
We can now fetch our option, that was not initially available because of the 1000 options limit.
You can read more about
$userInput on this other page.