[solve] Not list opportunity in related list

[rslemer]

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

How I can solve that?

[joebordes]

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/comm...ad2ba046c9

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 (!)

[rslemer]

Sorry I don't understand your explain.

[joebordes]

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

[rslemer]

unfortunately not solve for me.

---

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

[joebordes]

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

[rslemer]

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

[joebordes]

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

[rslemer]

Thanks, Joe.

After change directly line in table on DB, worked.

[rslemer]

and how I solve for opportunity listed a contacts?

What tabid I need checked?