Show fields from one type in another based on parent

Programatically...?

Or by configuration:

Did you see and configure both relation field parameters? In Child- and Parent field there are according parameters. Look for parameter set "Show Parent" and "Show Children". Both allow to set a special template for full and list view. In template parameters include/exclude your fields.

pepperstreet Programatically...?>

Yes, I'm already using those templates in field for something else. This I need for "record info" which will include standard info, subscriptions info, parent info etc.

I remember that someone else has asked a similar question... sorry, can't recall the username, nor the exact topic. Maybe "jimie", or "Xtreame" ...?!

Found only the following topic. Hence Sergey's first comment:

• Using Cobalt API, can I get values of child fields?

First get your field value

$ids = $item->fields_by_id[12]->values;

Check if it is array or single value. If it is array you can get access to ID by $ids[0]. So now use records API to get list of articles and pass $ids as last parameter. At the end you have list of articles with field values.

Sergey First get your field value

But how will I get field value of related record? So if I'm using parent-child relation how will I get fields value from parent in child record list?

you use records API.

$ids = $item->fields_by_id[12]->values;
$items = $api=>records(........, $ids);

$item = $items['list'][0];

$item->field_by_id[10]->result.

Or if you only need a field falue use RenderField API.

$record_id = $item->fields_by_id[12]->values[0];
echo CobaltApi::renderField($record_id, 10, 'full')

Where 10 is ID of the related article field.

Thank you. I thought I have to do some custom condition to get those fields.

How can I exclude parameters here (for ex. I don't need $limit):

$data = $api->records(
    $section_id, 
    $view_what, 
    $orderby, 
    $type_ids,
    $user_id,
    $category_id, 
    $limit, 
    $template,
    $client,
    $client_id,
    $lang,
    $ids
);

And also how can I check if field of related record is set?

Us limit to 5 for example.

klox7 And also how can I check if field of related record is set?

You do not need to set any relations because you already have IDs of the records to get passed with $ids parameter.

So in $data = $api->records I have to set up every parameter?

Yes. view_what should be all and others that you do not know use null.

Where you add this code? In Joomla template or Cobalt template or module? Which one in particular. Anyway try to make sure this file is included before you call it.

require_once JPATH_ROOT . '/components/com_cobalt/api.php';

Yes I tried based on documentation. In full record template. Same thing happens as above.

Looks like you pass template name in to records() function with it cannot find on the disk. Just use '' as template for test.

OK, this is for render article list and not field value of related record.

Sergey $ids = $item->fields_by_id[12]->values; $items = $api=>records(........, $ids);

$item = $items['list'][0];

$item->field_by_id[10]->result.

Sergey $record_id = $item->fields_by_id[12]->values[0]; echo CobaltApi::renderField($record_id, 10, 'full')

Is this the only way for displaying related record field value. Or is it possible that I get label and result?

And how to remove this notice when using code bellow?

Notice: Trying to get property of non-object in components/com_cobalt/api.php on line 175

<?php
$related_record_id = $item->fields_by_id[232]->value[0];
$field=CobaltApi::renderField($related_record_id, 315, 'full');
if(!empty($field)):
    echo '<b>Full membership - Sale ID:</b>'. $field .'<br />';
endif;
?>

Into renderField you have to put record object.

<?php
$related_record_id = $item->fields_by_id[232]->value[0];
if($related_record_id) {
    $record = ItemsStore::getRecord($related_record_id);
    $field=CobaltApi::renderField($record, 315, 'full');
    if(!empty($field)) {
        echo '<b>Full membership - Sale ID:</b>'. $field .'<br />';
    }
}
?>

But I make changes in API and you will have to be able to do this

$field=CobaltApi::renderField($item->fields_by_id[232]->value[0], 315, 'full');
if(!empty($field)) {
    echo '<b>Full membership - Sale ID:</b>'. $field .'<br />';
}

You have an errod because $related_record_id is not an object.

This is not only way. You can also use fields array.

<?php
$related_record_id = $item->fields_by_id[232]->value[0];
if($related_record_id) {
    $record = ItemsStore::getRecord($related_record_id);
    var_dump($record->fields[315]);
}
?>

If ->fields is a string convert it to to array from JSON first.

$record->fields = json_decode($record->fields, TRUE);