Greetings, Sebloders!
NOTE: I admit it, and I apologize... I've cross-posted this both here
and also in the VIP forum. As there has been no response in the VIP
forum yet, I'm reaching out to the larger community in hopes of some
answer.
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?
Example SQL:
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!
Denver