Is is possible to use URL parameters or reference other fields in a Select Dynamic field's SQL query? I need to include a parameter in the WHERE clause of my query (X in the example below). The value will be different for every user and should be equal to the current user's 'dealer_id'. Is this possible? And if so, how?
SELECT sales_associate_name AS text, id AS value FROM #__cck_store_form_sales_associate WHERE sales_associate_dealer_id = X
Thanks in advance for your help!
2 replies have been added to this thread, and the topic is marked as solved. You should subscribe to a club in order to read all posts.