relate field to show in listview and subpanel

[marktaylor5151]

I have two modules. Short Term and Interest Repayments. I created a 1-M relationship through modulebuilder and it automatically placed a relate style field in the Interest Repayments modules. the Short Term Relate style field that appears on the Interest Repayments EditView and DetailView. There is no field in the vardef files that has short_term_name or _id for the relate style field so i am wondering how i would go about adding this field to the ListView and Subpanel views.

http://www.fsppp.com.au/sugar/example.jpg shows my scenario.

If any one can point me in the direction of how i might accomplish listing the relate field in listview and subpanel would be greatly appreciated.

Thanks

Mark

[mvngti]

If you look at the vardefs your short term relate field actually consists of two fields
short_term_name and short_term_id (or something like that).

Simply try adding the short_term_name field to your listviewdefs.php (or listview in studio) and to the subpanel definition (modules/<module>/metadata/subpanels/default.php).

And make sure that you have 'fill_in_additional_fields' => true in the subpanel definition.

[marktaylor5151]

Marnus,

i checked the vardefs and there is nothing like that. I know when i have created previous relate fields manually through module builder the fields that you mention have come up. But in this instance i never created a relate field in module builder i just added a relationship through module builder and it created that short term relate style field. That field created by modulebuilder relationship function can be seen only in edit and viewdefs through module builder, there is not field available in listview.

Does anyone have any other suggestions?

[mvngti]

Where have you checked?
Bets place to make sure they exist is in cache/modules/<module>/<module>vardefs.php file replacing <module> with the module name.

If they are NOT there then the fields do not exist! If they are then you should see one of them (the name) in studio when you edit layouts.

M

[marktaylor5151]

I have most of it working thank you.


http://www.fsppp.com.au/sugar/nwc_In...ntsvardefs.txt is the vardefs from the cache folder cache\modules\nwc_InterestRepayments\nwc_InterestR epaymentsvardefs.php


There only sections i see relevant are


'nwc_shortterm_nwc_interestrepayments' =>
array (
'name' => 'nwc_shortterm_nwc_interestrepayments',
'type' => 'link',
'relationship' => 'nwc_shortterm_nwc_interestrepayments',
'source' => 'non-db',
),
'nwc_shortterm_nwc_interestrepayments_name' =>
array (
'name' => 'nwc_shortterm_nwc_interestrepayments_name',
'type' => 'relate',
'source' => 'non-db',
'vname' => 'LBL_NWC_SHORTTERM_NWC_INTERESTREPAYMENTS_FROM_NWC _SHORTTERM_TITLE',
'save' => true,
'id_name' => 'nwc_shortt3910ortterm_ida',
'link' => 'nwc_shortterm_nwc_interestrepayments',
'table' => 'nwc_shortterm',
'module' => 'nwc_ShortTerm',
'rname' => 'name',
),
'nwc_shortt3910ortterm_ida' =>
array (
'name' => 'nwc_shortt3910ortterm_ida',
'type' => 'link',
'relationship' => 'nwc_shortterm_nwc_interestrepayments',
'source' => 'non-db',
),
),



Interest Repayments Module

C:\wamp\www\test04c\custom\modulebuilder\packages\ nwc\modules\InterestRepayments\metadata\listviewde fs.php


now has

'NWC_SHORTTERM_NWC_INTERESTREPAYMENTS_NAME' =>
array (
'width' => '15%',
'label' => 'LBL_NWC_SHORTTERM_NWC_INTERESTREPAYMENTS_FROM_NWC _SHORTTERM_TITLE',
'module' => 'nwc_ShortTerm',
'id' => 'nwc_shortt3910ortterm_ida',
'widget_class' => 'SubPanelDetailViewLink',
'link' => true,
'default' => true,
'ACLTag' => 'nwc_ShortTerm',
'related_fields' => array('nwc_shortt3910ortterm_ida'),
),

and now it lists the column that i wanted. http://www.fsppp.com.au/sugar/ScreenShot011.jpg

Now when i click on this column i want it to take me to the short term module which it does but it rather than displaying the record it displays the error message 'Error retrieving record. This record may be deleted or you may not be authorized to view it.' http://www.fsppp.com.au/sugar/ScreenShot012.jpg


is there something i am doing incorrectly that may rectified the error showing and actually display the short term record it relates to.


the Interest Repayments Subpanel now has
C:\wamp\www\test04c\custom\modulebuilder\packages\ nwc\modules\InterestRepayments\metadata\subpanels\ default.php

'nwc_shortterm_nwc_interestrepayments_name' =>
array(
'name' => 'nwc_shortterm_nwc_interestrepayments_name',
'module' => 'nwc_ShortTerm',
'widget_class' => 'SubPanelDetailViewLink',
'target_record_key' => 'nwc_shortt3910ortterm_ida',
'target_module' => 'nwc_ShortTerm',
'vname' => 'LBL_NWC_SHORTTERM_NWC_INTERESTREPAYMENTS_FROM_NWC _SHORTTERM_TITLE',
width' => '10%',
),

which displays the column in the subpanel on the short term module and when i click on the new column it takes me to the short term record. so that is working fine. http://www.fsppp.com.au/sugar/ScreenShot010.jpg

[mvngti]

     // This is the NAME field
    'nwc_shortterm_nwc_interestrepayments_name' => 
    array (
      'name' => 'nwc_shortterm_nwc_interestrepayments_name',
      'type' => 'relate',
      'source' => 'non-db',
      'vname' => 'LBL_NWC_SHORTTERM_NWC_INTERESTREPAYMENTS_FROM_NWC_SHORTTERM_TITLE',
      'save' => true,
      'id_name' => 'nwc_shortt3910ortterm_ida',
      'link' => 'nwc_shortterm_nwc_interestrepayments',
      'table' => 'nwc_shortterm',
      'module' => 'nwc_ShortTerm',
      'rname' => 'name',
    ),
    // This is the ID
    'nwc_shortt3910ortterm_ida' => 
    array (
      'name' => 'nwc_shortt3910ortterm_ida',
      'type' => 'link',
      'relationship' => 'nwc_shortterm_nwc_interestrepayments',
      'source' => 'non-db',
    ),
  ), 
  

   'NWC_SHORTTERM_NWC_INTERESTREPAYMENTS_NAME' => 
  array (
    'width' => '15%',
    'label' => 'LBL_NWC_SHORTTERM_NWC_INTERESTREPAYMENTS_FROM_NWC_SHORTTERM_TITLE',
    'module' => 'nwc_ShortTerm',
    'id' => 'nwc_shortt3910ortterm_ida',
    'widget_class' => 'SubPanelDetailViewLink',
    'target_record_key' => 'nwc_shortt3910ortterm_ida',
    'target_module' => 'nwc_shortterm','
    'link' => true,
    'default' => true,
    'ACLTag' => 'nwc_ShortTerm',    
    'related_fields' => array('nwc_shortt3910ortterm_ida),      
  ), 
  

Have a look at the target.... entries above - should work.

[marktaylor5151]

i inserted the following code in the listview and redepoloyed the module a few times

   'NWC_SHORTTERM_NWC_INTERESTREPAYMENTS_NAME' => 
  array (
    'width' => '15%',
    'label' => 'LBL_NWC_SHORTTERM_NWC_INTERESTREPAYMENTS_FROM_NWC_SHORTTERM_TITLE',
    'module' => 'nwc_ShortTerm',
    'id' => 'nwc_shortt3910ortterm_ida',
    'widget_class' => 'SubPanelDetailViewLink',
    'target_record_key' => 'nwc_shortt3910ortterm_ida',
    'target_module' => 'nwc_ShortTerm',
    'link' => true,
    'default' => true,     
  ), 
  

I am still getting the error of the record being deleted or not having access to it. I am unsure if it is given the correct ID from the interest repayment module over to the short term module when i click on the column as it seems to have the same interest repayment id rather than the id that would match the short term, either that or there is some permission problem as it say, but i am able to view the short term module so there should not be a permission issue unless there is a spelling mistake in my code.