When it comes to joined values (connections) in the search component, can we possibly get a “Contains” option in the Operators section. Or possibly a value lookup search option for that search field.
If the field has hundreds or thousands of records, it’s more efficient to be able to give the user the ability to search for that record by a value lookup, instead of a dropdown. (Also, the dropdown automatically defaults to the first record in the dropdown list).
Maybe use the same functionality as in the Form Component, where it searches the record and you can add multiple connected values in a join-connection field.