CoreBOSBB
[solve] Not list opportunity in related list - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: [solve] Not list opportunity in related list (/showthread.php?tid=874)



[solve] Not list opportunity in related list - rslemer - 01-30-2018

In my installation, a contact has more than one opportunity, but system not exhibit yours opportunities in related list.

How I can solve that?


RE: Not list opportunity in related list - joebordes - 01-30-2018

Well, you actually found an error that we get directly from vtiger, I thought we didn't have any of those left :-)

https://github.com/tsolucio/corebos/commit/e671613f34634b726c0f15acc30f08ad2ba046c9

With this change, the potentials related list on contacts will show all related potentials, directly, related to the contact's account and related to the related list of potentials.

I'd say that you have added the related list using the layout editor. If that is the case you will have to recover the one that was there before because this is a special relation inherited from sugar crm (!)


RE: Not list opportunity in related list - rslemer - 01-30-2018

Sorry I don't understand your explain.


RE: Not list opportunity in related list - joebordes - 01-31-2018

I fixed the potentials related list on contacts so it shows all the related potential records


RE: Not list opportunity in related list - rslemer - 01-31-2018

unfortunately not solve for me.

Sad

Maybe, if I install a fresh copy and move BD from older, could solve?


RE: Not list opportunity in related list - joebordes - 01-31-2018

edit the related list that you have created in the database and set the function to get_opportunities

a fresh install will not work as the problem is in the database


RE: Not list opportunity in related list - rslemer - 01-31-2018

but, how I know each line could be change?

The number is a position in related list?

I need change get_contacts to get_opportunities ( for value 1 ) ?

see my related list


RE: Not list opportunity in related list - joebordes - 01-31-2018

In the vtiger_relatedlist table you have a tabid and a relatedtabid column. You are looking for the row that related Contacts (tabid=4) with Potentials (tabid=2) so you are looking for the row that has:

tabid=4 and relatedtabid=2

in that row you must change the name column to get_opportunities


RE: [solve] Not list opportunity in related list - rslemer - 02-20-2018

Thanks, Joe.

After change directly line in table on DB, worked.

Smile


RE: [solve] Not list opportunity in related list - rslemer - 02-21-2018

and how I solve for opportunity listed a contacts?

What tabid I need checked?