Radicore Forum: Transaction Patterns » Link Pattern (Additional Data of the 'Parent Field')

Home » RADICORE development » Transaction Patterns » Link Pattern (Additional Data of the 'Parent Field')

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Link Pattern (Additional Data of the 'Parent Field') [message #7295 is a reply to message #7293]

Mon, 20 May 2019 06:56

htManager
Messages: 449
Registered: May 2014

Senior Member

I do need data of the $outer and $inner tables. Therefore I configured the 'Parent Field' in the $link table as these fields as you can see here:

// parent relationship details
$this->parent_relations[] = array('parent' => 'training_kanal',
'parent_field' => 'training_kanal_name',
'fields' => array('training_kanal_id' => 'training_kanal_id'));

$this->parent_relations[] = array('parent' => 'training_kanal_uebungskategorie',
'parent_field' => 'training_kanal_kategorie_desc',
'fields' => array('training_kanal_id' => 'training_kanal_id',
'training_kanal_kategorie_id' => 'training_kanal_kategorie_id'));

I want to show only the 'true' records with the id-descriptions (training_kanal_name and training_kanal_kategorie_desc), stored in the $outer and $inner tables.

And here is the code of the php file:

$outer_table = 'training_kanal_uebungen'; // name of outer table
$link_table = 'training_kanal_uebungen_kategorie'; // name of link table
$inner_table = 'training_kanal_uebungskategorie'; // name of inner table
$screen = 'training_kanal_uebungen_kategorie.link1(u).screen.inc'; // file identifying screen structure

// customise the SQL SELECT statement
$outer_sql_select = null;
$outer_sql_from = null;
$outer_sql_where = null;
$outer_sql_groupby = null;
$outer_sql_having = null;
$outer_sql_orderby = null;
$outer_sql_orderby_table = null;

$link_sql_select = null;
$link_sql_from = null;
$link_sql_where = 'training_kanal_uebungen_kategorie.training_kanal_uebung_no = ' .
'training_kanal_uebung_no '; // .
$link_sql_groupby = null;
$link_sql_having = null;
$link_sql_orderby = 'training_kanal_kategorie_desc';
$link_sql_orderby_table = null;
$link_search_table = 'training_kanal_uebungskategorie';

require 'std.link1.inc'; // activate page controller

Report message to a moderator

[Message index]

		Link Pattern (Additional Data of the 'Parent Field') By: htManager on Sun, 19 May 2019 07:18
		Re: Link Pattern (Additional Data of the 'Parent Field') By: AJM on Mon, 20 May 2019 04:18
		Re: Link Pattern (Additional Data of the 'Parent Field') By: htManager on Mon, 20 May 2019 06:56
		Re: Link Pattern (Additional Data of the 'Parent Field') By: AJM on Tue, 21 May 2019 04:53
		Re: Link Pattern (Additional Data of the 'Parent Field') By: htManager on Tue, 21 May 2019 15:37

Previous Topic:	IDE Validation Issues
Next Topic:	SQL error generating list2 pattern

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Feb 16 11:29:06 EST 2025

Total time taken to generate the page: 0.01177 seconds