[Vtigercrm-developers] Realtion between Tickets and ServiceContracts

[Ing. Matus Sopko]

So the correct migration of N:M to 1:N relation can be interesting for 
Vtiger Open Source project?
We can do it and push our changes.

S pozdravom / Best regards / Mit freundlichen Grüßen
Ing. Matus SOPKO

IT-Solutions4You s.r.o.
Kancelária: Slovenská 69
Sídlo: Frantiskanske nam.5
080 01 Prešov
SLOVAKIA
Tel./ Fax +421/ 51/ 7732370
email: sopko at its4you.sk
http://www.its4you.sk
skype: matussopko

Dňa 12. 10. 2020 o 16:27 Simone Travaglini napísal(a):
> We did the same, change relation and calculation (but we use workflow 
> designer to manage new calculation)
>
> Il giorno lun 12 ott 2020 alle ore 16:25 Martin Allen 
> <martin.allen at clystnet.com <mailto:martin.allen at clystnet.com>> ha scritto:
>
>     Yes, we did exactly this recently, and the M:M relationship is
>     hard-coded in to a few locations which means that just adding a
>     normal 1:M relation field and related list don't immediately work!
>     In /modules/HelpDesk/models/Module.php getQueryByModuleField() had
>     to remove the ServiceContracts module from the array.
>     In /modules/ServiceContracts/models/Module.php
>     getQueryByModuleField() - we simply removed this function.
>
>
>     Martin Allen
>
>     *01392 248692 - Main Office
>     01392 690659 - Direct Line*
>
>     *signature2*
>
>     Have you visited our website recently? http://www.clystnet.com
>     <http://www.clystnet.com/>
>
>
>     The information in this email is confidential If you are not the
>     intended recipient, you must not read or use that information.
>     This email and any attachments are believed to be virus free
>     however no responsibility is accepted by Clystnet for any loss or
>     damage arising in any way from receipt or use thereof. Clystnet
>     Ltd (company reg number 7164503) is based at Silverdown Park, Fair
>     Oak Close, Clyst Honiton, EX5 2UX
>
>
>
>     On Mon, 12 Oct 2020 at 14:38, Ing. Matus Sopko <sopko at its4you.sk
>     <mailto:sopko at its4you.sk>> wrote:
>
>         The current relation between Tickets and ServiceContracts is N:M.
>         What is the goal of this relation? We don't have any Tickets
>         related to two ServiceContract for now.
>         In our cases, this relation makes only problems.
>         I want to change this relation to 1:N (popup ServiceContrat in
>         Ticket module)
>         In this case, the support team can choose the correct service
>         contract in the create/edit view and of course related Ticket
>         for ServiceContract.
>         I know that we have to change the calculation of Used Units in
>         ServiceContract module and rebuilt saved relations.
>         Do you see any other issues?
>
>         -- 
>         S pozdravom / Best regards / Mit freundlichen Grüßen
>         Ing. Matus SOPKO
>
>         IT-Solutions4You s.r.o.
>         Kancelária: Slovenská 69
>         Sídlo: Frantiskanske nam.5
>         080 01 Prešov
>         SLOVAKIA
>         Tel./ Fax +421/ 51/ 7732370
>         email:sopko at its4you.sk  <mailto:sopko at its4you.sk>
>         http://www.its4you.sk
>         skype: matussopko
>
>         _______________________________________________
>         http://www.vtiger.com/
>
>     _______________________________________________
>     http://www.vtiger.com/
>
>
>
> -- 
> Simone Travaglini
> 328 5499846
> Linkedin: Simone Travaglini
>
>
> Rispetta l'ambiente: non stampare questa mail se non ti è veramente 
> necessario!
>
> _______________________________________________
> http://www.vtiger.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20201012/b2a9ad06/attachment.html>