Dependencies to the user input

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

SQL

If there are more than 1000 products, they would not all be available in the Connected item select list.

Adding $userInput allows your query to update as your are typing!

Query with user input

SELECT product
FROM catalog
WHERE product ILIKE '%$userInput%'

SQL

(the % are wildcards, the variable itself is just $userInput)

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%'

SQL

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.