List & Search Type: in the "Search Form" section there is a "my_field" field of type "Select Dynamic" (i.e. drop-down list). In addition, this section has a field of type "Search Query", in which - query to the database. The "List" section contains the corresponding fields for the table output.
Question:
How to make the SQL query "Search Query" use the value after selecting the "select Dynamic" type in the "my_field" field and change the output content without reloading the page?
With built in options this won't work - search query works on server side and values from select field are only passed from the client to the server when the form is submited. You could simulate this by using some javascript like ajax form submit script like https://www.sanwebe.com/2016/07/ajax-form-submit-examples-using-jquery
Thank you. I will study