Dynamic sql custom field

[fotonio]

Hi,
I have an sql custom field inside a subform for content aritcles.
If i put in the query SELECT created_by AS value, created_by AS text FROM #__content WHERE id = 6 , i get the user id that created the article.
I would like to have SELECT created_by AS value, created_by AS text FROM #__content WHERE id = article_id ,so the query can take dynamically the article_id when each article is edited without user input.

I have tried to override the render.php but as i learned from searching around, the field value of sql is assigned on onCustomFieldsPrepare before it renders.

Chatgpt suggests this code but i am not sure in which file to use it.

Code: Select all

use Joomla\CMS\Factory;

class PlgFieldsDynamicSQL extends \Joomla\CMS\Plugin\CMSPlugin
{
    public function onCustomFieldsPrepareField($field, $context, $item)
    {
        // Ensure this applies only to the specific custom field and context
        if ($field->type === 'sql' && $context === 'com_content.article')
        {
            // Get the article ID dynamically
            $app = Factory::getApplication();
            $articleId = $app->input->getInt('id', 0); // Get the article ID from the request

            // Replace the placeholder with the article ID in the SQL query
            if ($articleId && strpos($field->element, ':article_id') !== false)
            {
                $field->element = str_replace(':article_id', $articleId, $field->element);
            }
        }
    }
}

[ceford]

You could look at the exisiting plugins/xxx for inspiration. There is one for sql field.

You could look at the plugin coding examples: https://manual.joomla.org/docs/building ... n-sqlfile/

Or you could search a current Joomla test installation for onCustomFieldsPrepare - there are none with that whole word but plenty with that as a root.

It is not clear whether you will have to write your own plugin.

[fotonio]

I tried something else. Instead of sql i made a text field and following this solution by Sharky i managed to get the created_by value by creating an override to html/layouts/com_fields/field/cust-render.php with the code

Code: Select all

$created_by = $displayData['item']->created_by;
if ($field->id == '75')  { $value = $created_by; }

And it works. But when i put the text field inside the subform it stops working.

I see that subfield values probably are prepared in plugins/fields/subform/src/Extension/Subform.php

Any tips?