[Vtigercrm-developers] Realtion between Tickets and ServiceContracts

[Martin Allen]

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 Office01392 690659 - Direct Line*

*[image: signature2]*

Have you visited our website recently? 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> 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.skhttp://www.its4you.sk
> skype: matussopko
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20201012/b0c730a6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10550 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20201012/b0c730a6/attachment.png>