[Vtigercrm-developers] Two and more Related list to the same module

[Prasad]

Hi Trifon,

vtiger_crmentityrel is currently intended to capture relation betwen Record
A of Module A with Record B or Module B
without any meta (context) information. Each module need to capture the
other meta relation required by itself.

Should vTiger team accept such general change in the core?
> What are the requirements to be included in the next version of vTiger?


vtiger Team is always open to ideas or feedback. Please make sure your
solution is designed
and implemented in a generic way (instead of targeting to specific module or
usecase).

Regards,
Prasad
vtiger Team


On 5/20/10, Trifon Trifonov <trifon.trifonov at catura.de> wrote:
>
> Hi Prasad,
>
> thank you for your response!
>
> I know about this custom functions and i think that they are way.
> Question which popup is that i need to distinguish which records to
> show from the relationship between Project and Contacts.
> A filter by which to filter records.
>
> vTiger has table "vtiger_crmentityre" which show relationship between
> records.
>                         47      Project 17      Contacts
>                         47      Project 18      Contacts
>                         47      Project 27      Contacts
>                         47      Project 28      Contacts
> What i need is another column in "vtiger_crmentityre" to distinguish
> relation type/name.
> Currently i can see that record with ID 47 from Project module is
> related to Record with ID 18 and 17,18,27,18 from Contacts module but
> i can't find which is the relation type(contacts 17 and 18 belongs to
> "Major" relation type while contacts 27 and 28 to "Minor").
>
> Second approach i think is to add new table vtiger_projectcontactrel
> to hold information about relationship between Project and Contact.
> Here of course i can add column to hold type of the relation.
>
> What do you think is there another more easy approach in vTiger which
> i do not know?
> Should vTiger team accept such general change in the core?
> What are the requirements to be included in the next version of vTiger?
>
> As a background information in ADempiere we have similar GUI
> Structure: Window with multiple tabs. Window from ADempiere is like
> Module in vTiger. Tab from ADempiere is like CRMEntity from vTiger.
> When defining Tabs in ADempiere i can specify WHERE clause by which to
> filter relation records. This allows me to have many embedded tabs
> showing information from the same relationship table but filtered by
> specific criteria.
> I;m writing this as it might help in the search for solution.
>
> Kind regards,
> Trifon
> ---
> www.catura.de
>
>
> On Wed, May 19, 2010 at 9:16 PM, Prasad <prasad at vtiger.com> wrote:
> > Hi,
> >
> > setRelatedList API takes one more parameter function_name,
> > by default it is set to get_relatedlists (implemented in CRMEntity.php)
> >
> > You will need to implement custom version of it in your class and
> > provide the name when setting up related list.
> >
> > Regards,
> > Prasad
> >
> > On 5/19/10, Trifon Trifonov <trifon.trifonov at catura.de> wrote:
> >>
> >> Hello Developers,
> >>
> >> On vTiger 5.1.0 with vTlib i know how to define relation between
> modules:
> >>
> >> include_once('vtlib/Vtiger/Menu.php');
> >> include_once('vtlib/Vtiger/Module.php');
> >>
> >> // Relate Project module with Accounts
> >> $module = Vtiger_Module::getInstance('Project');
> >> $module->setRelatedList(Vtiger_Module::getInstance('Accounts'),
> >> 'Accounts', Array('ADD','SELECT'));
> >>
> >> Above code is working very well. It shows All Accounts related to
> >> specific Project.
> >>
> >> I'm trying to add second relation(let's name it Fathers) but
> >> unfortunately it shows again the same records as the first(Accounts).
> >> $module->setRelatedList(Vtiger_Module::getInstance('Contacts'),
> >> 'Fathers', Array('ADD','SELECT'));
> >>
> >> Can you please advice if this is possible?
> >> In case not i would like to add such capabilities to vTiger. Would
> >> appreciate comments in what direction to look in order to develop it.
> >>
> >> Regards,
> >> Trifon
> >> ----
> >> www.catura.de
> >> _______________________________________________
> >> Reach hundreds of potential candidates - http://jobs.vtiger.com
> >
> >
> > _______________________________________________
> > Reach hundreds of potential candidates - http://jobs.vtiger.com
> >
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20100520/e6c7993e/attachment-0002.html