Hi Trifon,<br><br>vtiger_crmentityrel is currently intended to capture relation betwen Record A of Module A with Record B or Module B<br>without any meta (context) information. Each module need to capture the other meta relation required by itself.<br>
<br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">Should vTiger team accept such general change in the core?<br> What are the requirements to be included in the next version of vTiger?</blockquote>
<div><br>vtiger Team is always open to ideas or feedback. Please make sure your solution is designed<br>and implemented in a generic way (instead of targeting to specific module or usecase). <br><br>Regards,<br>Prasad<br>
vtiger Team<br></div><br><br><div><span class="gmail_quote">On 5/20/10, <b class="gmail_sendername">Trifon Trifonov</b> <<a href="mailto:trifon.trifonov@catura.de">trifon.trifonov@catura.de</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Prasad,<br> <br> thank you for your response!<br> <br> I know about this custom functions and i think that they are way.<br> Question which popup is that i need to distinguish which records to<br> show from the relationship between Project and Contacts.<br>
A filter by which to filter records.<br> <br> vTiger has table "vtiger_crmentityre" which show relationship between records.<br> 47 Project 17 Contacts<br> 47 Project 18 Contacts<br>
47 Project 27 Contacts<br> 47 Project 28 Contacts<br> What i need is another column in "vtiger_crmentityre" to distinguish<br> relation type/name.<br>
Currently i can see that record with ID 47 from Project module is<br> related to Record with ID 18 and 17,18,27,18 from Contacts module but<br> i can't find which is the relation type(contacts 17 and 18 belongs to<br>
"Major" relation type while contacts 27 and 28 to "Minor").<br> <br> Second approach i think is to add new table vtiger_projectcontactrel<br> to hold information about relationship between Project and Contact.<br>
Here of course i can add column to hold type of the relation.<br> <br> What do you think is there another more easy approach in vTiger which<br> i do not know?<br> Should vTiger team accept such general change in the core?<br>
What are the requirements to be included in the next version of vTiger?<br> <br> As a background information in ADempiere we have similar GUI<br> Structure: Window with multiple tabs. Window from ADempiere is like<br> Module in vTiger. Tab from ADempiere is like CRMEntity from vTiger.<br>
When defining Tabs in ADempiere i can specify WHERE clause by which to<br> filter relation records. This allows me to have many embedded tabs<br> showing information from the same relationship table but filtered by<br> specific criteria.<br>
I;m writing this as it might help in the search for solution.<br> <br> Kind regards,<br> Trifon<br> ---<br> <a href="http://www.catura.de">www.catura.de</a><br> <br><br> On Wed, May 19, 2010 at 9:16 PM, Prasad <<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>> wrote:<br>
> Hi,<br> ><br> > setRelatedList API takes one more parameter function_name,<br> > by default it is set to get_relatedlists (implemented in CRMEntity.php)<br> ><br> > You will need to implement custom version of it in your class and<br>
> provide the name when setting up related list.<br> ><br> > Regards,<br> > Prasad<br> ><br> > On 5/19/10, Trifon Trifonov <<a href="mailto:trifon.trifonov@catura.de">trifon.trifonov@catura.de</a>> wrote:<br>
>><br> >> Hello Developers,<br> >><br> >> On vTiger 5.1.0 with vTlib i know how to define relation between modules:<br> >><br> >> include_once('vtlib/Vtiger/Menu.php');<br> >> include_once('vtlib/Vtiger/Module.php');<br>
>><br> >> // Relate Project module with Accounts<br> >> $module = Vtiger_Module::getInstance('Project');<br> >> $module->setRelatedList(Vtiger_Module::getInstance('Accounts'),<br>
>> 'Accounts', Array('ADD','SELECT'));<br> >><br> >> Above code is working very well. It shows All Accounts related to<br> >> specific Project.<br> >><br> >> I'm trying to add second relation(let's name it Fathers) but<br>
>> unfortunately it shows again the same records as the first(Accounts).<br> >> $module->setRelatedList(Vtiger_Module::getInstance('Contacts'),<br> >> 'Fathers', Array('ADD','SELECT'));<br>
>><br> >> Can you please advice if this is possible?<br> >> In case not i would like to add such capabilities to vTiger. Would<br> >> appreciate comments in what direction to look in order to develop it.<br>
>><br> >> Regards,<br> >> Trifon<br> >> ----<br> >> <a href="http://www.catura.de">www.catura.de</a><br> >> _______________________________________________<br> >> Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com">http://jobs.vtiger.com</a><br>
><br> ><br> > _______________________________________________<br> > Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com">http://jobs.vtiger.com</a><br> ><br> _______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com">http://jobs.vtiger.com</a><br> </blockquote></div><br>