Problems with relate field on listview

Hi everybody,
I got some problem on list view and not know how to fix it.

I have 2 module name: SCP_Lead and SCP_Company.
In SCP_Lead i have "Related Field" SCP_Company.
But when i click on SCP_Company field on ListView it can't link to current Lead record and show the error "Error retrieving record. This record may be deleted or you may not be authorized to view it."

and the URL seem be wrong to :

index.php?action=ajaxui#ajaxUILoc=index.php%3Fmodule%3DSCP_Company%26offset%3D3%26stamp%3D1398223190009391900%

It must be SCP_Lead instead of SCP_Company because i want i link to current Lead record.

0 Aftab Ahmad Aafi over 9 years ago

The relate field that you have defind in vardef must be refereing to SCP_Lead.Mean Lead's module name and bean name should be used.
I am going to show you and example.I have two modules rt_departments and rt_students with 1-M relationship.Relate field of department is placed in vardefs of rt_student. Please follow the link to check defination of relate field.
Upper code is for relationship and lower code is for relate field defination.
http://aftabahmad1.blogspot.com/2014/04/how-to-create-one-to-many-relationship.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tanphat911 tanphat911 over 9 years ago

Dear Aftab Ahmad Aafi .
Thank for your help but i sorry not mention above i using CE 6.5 and your tutorial is for Sugar CRM 7 .
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Aftab Ahmad Aafi over 9 years ago

yes my tutorial is about sugar 7 but field definition is similar if this is sugar 6 or sugar7 so you can get help from this link that i have mentioned. Good luck :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Aftab Ahmad Aafi over 9 years ago

http://aftabahmad1.blogspot.com/2013/11/create-one-to-many-relationship-between.html go through this link and find your answer.This is one to many relationship in sugar6.Please pick your required relate field link code. :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tanphat911 tanphat911 over 9 years ago

Thx Aftab Ahmad Aafi but my problems is not relationship . because i not create relationship between these module . i just a "Related Field" . I Think code must change on listviewdef?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Fahad Fahad over 9 years ago

Hi,
I hope the following code will help you,

'SCP_LEAD_NAME' => array (
'type' => 'relate',
'studio' => 'visible',
'label' => 'LBL_SCP_LEAD_NAME',
'id' => 'SCP_LEAD_ID',
'link' => true,
'width' => '20%',
'default' => true,
),

Let me know if there is any issue,
Thank you,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Alex Nassi over 9 years ago

Hi Tanphat911,

This seems to be related to a known defect in the current release of Sugar, #66596. Your description is not identical to the description of the defect, but other users have had similar use cases that related back to the same issue. Please confirm what version of 6.5 you are running (6.5.16? 6.5.15? etc.) and I can look into getting you a hotfix package which should fix this issue for you.

Thanks!
Alex
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tanphat911 tanphat911 over 9 years ago in reply to Alex Nassi

Dear Alex Nassi
I using Sugar 6.5.16

Best Regard
tanphat911
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Alex Nassi over 9 years ago in reply to Alex Nassi

Hi Tanphat911,

I just sent you an email with the hotfix. Please let me know if this helps!

-Alex
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tanphat911 tanphat911 over 9 years ago in reply to Alex Nassi

Thank Alex it work perfectly .

Another solution is add some line in listviewdef :

'module' => 'your module name',
'ACLTag' => 'YOURMODULENAME',

and remove

'type' -> 'related'
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel