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

Link Pattern (Additional Data of the 'Parent Field') [message #7293]

Sun, 19 May 2019 07:18

htManager
Messages: 433
Registered: May 2014

Senior Member

I have a link table and I want to show the data of the 'Parent Field' of the ONE TABLE - configured in the Parent Relationship - in the screen. What is wrong with my relationship? Or is there a better way?

Report message to a moderator

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

Mon, 20 May 2019 04:18

AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK

Senior Member

If you are using the LINK1 pattern this references three tables - $outer, $link and $inner. Which one of these three do you mean?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

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: 433
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

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

Tue, 21 May 2019 04:53

AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK

Senior Member

In order to see examples of how you can modify the SQL query please take a look at menu/mnu_menu(link1).php and menu/mnu_nav_button(link1).php

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

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

Tue, 21 May 2019 15:37

htManager
Messages: 433
Registered: May 2014

Senior Member

Thank you for your hint. I now get the data from the inner table but I am still struggling with a left join on an additional table. But I now have the result I wanted. And I understand again a little bit more. Thank you.

[Updated on: Tue, 21 May 2019 16:23]

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 00:27:19 EST 2024

Total time taken to generate the page: 0.01029 seconds