Hi

Just thinking out loud here while I'm walking my dog..,.

I would probably do a position override or variation (you choose)

and do a db query getting descriptions based upon the numbers stored prvtmat,

and then create your string that way

Make sense?

No doubt there are other options....

Thanks

But like I wrote. I'm a big-time newbie. Do you have any links/references, since I haven't got any idea, as were to start.

SQL pack won't work if you trying to use it in a form as $cck->get('fieldname') only works in content or list. In form you could only do it with javascript as form fields only get value when form is saved.

Sorry that I was unclear
It is in content :)

You will need to use code pack as value will be array if you have select with multiple values and sql can't work with arrays. 

In beforeStore event you can take value of your prvtmat field and loop trough it to get tags and cooencenate them to a single string, then push this value to your new field.

So, you are telling me, that I have to buy the Code Pack too?
I thought that working with arrays was quite normal in sql - which the sql pack should let me? But no?

So there is no way to get different id's, defined as a comma-seperated field-value, "translated" to the corresponding values of another column, and shown in one field?

If you have comma-seperated field-value, then it could work with sql only, but it will be complicated to get it working. Instead of using code fields you cna do it in an override as Buchlash suggested. 

All right. I guess me and google will have a crack at it :-)

If anyone is in the mood for helping, then please don't hold back.

- I have field 'prvmat' whoose value is one or more numbers separatet by a comma

- those numbers are the ID's of column: description in table #__tags

- I would like to have a resulting sql (in an SQL Query-field) that gives me the content of all descriptions in a single string

Hi

Not tried this but reding the tutorial it seems legit.

Quote from there:

$cck->get('fieldname')->someProperty

This way you can get properties from other fields in the same content type e.g. 

value, you can also use alternative syntax $cck->getValue('fieldname'). 

This ONLY works when SQL "as field" is used in the content or list view. 

See last 2 articles on  http://www.seblod.com/resources/manuals/designer/overriding-a-position for details. *

SELECT CONCAT(' ,', description) FROM #__tags WHERE id IN ($cck->getValue('prvtmat'))

Something like that....

Hi

Not tested this either, but if doing a position override then

could add an sql query in the php file for your override.

Joomla syntax examples here 

Override would be like this:

template_name/positions/my_cool_override/my_cool_override.php

In your view (content view probably) select the position override for the appropriate position

<?php
/**
* @version 			SEBLOD 3.x Core
* @package			SEBLOD (App Builder & CCK) // SEBLOD nano (Form Builder)
* @url				http://www.seblod.com
* @editor			Octopoos - www.octopoos.com
* @copyright		Copyright (C) 2009 - 2016 SEBLOD. All Rights Reserved.
* @license 			GNU General Public License version 2 or later; see _LICENSE.php
**/

defined( '_JEXEC' ) or die;

$value = $cck->getValue('prvtmat');

$db = JFactory::getDbo();

$query = $db->getQuery(true);

$query->select('description'); // <- could do concat here

$query->from($db->quoteName('#__tags'));
$query->where($db->quoteName('id').' IN ('.$db->quote($value).')');

// Reset the query using our newly populated query object.
$db->setQuery($query);

// load values as indexed array
$descriptions = $db->loadColumn();

// separate the descriptions with a comma and a space
$descriptions = implode(', ', $descriptions);

echo $descriptions;