Hi all,
i'm trying to build a query in select dynamic field (located in the submission form) to substitute article related field (which gives me list of articles in category instead of current user articles)
So I made query:
SELECT #__content.catid, #__content.id AS value, #__content.title AS text, #__users.id, #__content.created_by
FROM #__content
INNER JOIN #__users
ON #__users.id=#__content.created_by
WHERE #__content.catid=12 AND #__content.created_by=626
where 12 is category i need and, actually, 626=logged in user. But I must use an variable or something else to exchange "626" by real ID of logged in user.
Solution:
#__content.created_by=#__users.id
doesn't work as I want because I see the same list of articles from the category 12.
And another issue, to completely substitute article related field (as far as i understand) I can add simply css class "cck_form cck_form_joomla_article". Is it enpugh?