<div dir="ltr">Yes! I agree!</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno lun 12 ott 2020 alle ore 16:45 Ing. Matus Sopko <<a href="mailto:sopko@its4you.sk">sopko@its4you.sk</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<tt>So the correct migration of N:M to 1:N relation can be
interesting for Vtiger Open Source project?<br>
We can do it and push our changes.<br>
</tt>
<pre cols="72">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: <a href="mailto:sopko@its4you.sk" target="_blank">sopko@its4you.sk</a>
<a href="http://www.its4you.sk" target="_blank">http://www.its4you.sk</a>
skype: matussopko</pre>
<div>Dňa 12. 10. 2020 o 16:27 Simone
Travaglini napísal(a):<br>
</div>
<blockquote type="cite">
<div dir="ltr">We did the same, change relation and calculation
(but we use workflow designer to manage new calculation)</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Il giorno lun 12 ott 2020 alle
ore 16:25 Martin Allen <<a href="mailto:martin.allen@clystnet.com" target="_blank">martin.allen@clystnet.com</a>> ha
scritto:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_default" style="font-family:verdana,sans-serif">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!</div>
<div class="gmail_default" style="font-family:verdana,sans-serif">In
/modules/HelpDesk/models/Module.php
getQueryByModuleField() had to remove the ServiceContracts
module from the array.<br>
In /modules/ServiceContracts/models/Module.php
getQueryByModuleField() - we simply removed this function.</div>
<div class="gmail_default" style="font-family:verdana,sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:verdana,sans-serif"><br>
</div>
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<p style="font-size:12.8px;color:rgb(80,0,80)"><span style="color:navy;font-family:Verdana,sans-serif;font-size:10pt">Martin
Allen</span></p>
<p style="font-size:12.8px;color:rgb(80,0,80)"><b style="font-size:12.8px"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(51,51,153)" lang="EN-US">01392 248692 - Main Office<br>
01392 690659 - Direct Line</span></b><br>
</p>
<p style="font-size:12.8px;color:rgb(80,0,80)"><b><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(51,51,153)"><img alt="signature2" width="288" height="65"></span></b><span style="color:rgb(31,73,125)"></span></p>
<p style="font-size:12.8px;color:rgb(80,0,80)"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:navy" lang="EN-US">Have you visited our website
recently? <a href="http://www.clystnet.com/" style="color:rgb(17,85,204)" target="_blank">http://www.clystnet.com</a></span><span style="color:rgb(31,73,125)"></span></p>
<p style="font-size:12.8px;color:rgb(80,0,80)"><span style="font-size:10pt;font-family:Verdana,sans-serif;color:navy" lang="EN-US"><br>
</span><span style="font-size:10pt;font-family:Verdana,sans-serif;color:rgb(153,153,153)" lang="EN-US">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</span></p>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, 12 Oct 2020 at
14:38, Ing. Matus Sopko <<a href="mailto:sopko@its4you.sk" target="_blank">sopko@its4you.sk</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div> <tt>The current relation between Tickets and
ServiceContracts is N:M.<br>
What is the goal of this relation? We don't have any
Tickets related to two ServiceContract for now.<br>
In our cases, this relation makes only problems.<br>
I want to change this relation to 1:N (popup
ServiceContrat in Ticket module)<br>
In this case, the support team can choose the correct
service contract in the create/edit view and of course
related Ticket for ServiceContract.<br>
I know that we have to change the calculation of Used
Units in ServiceContract module and rebuilt saved
relations.<br>
Do you see any other issues? </tt><tt><span><tt><br>
</tt></span></tt>
<pre cols="72">--
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: <a href="mailto:sopko@its4you.sk" target="_blank">sopko@its4you.sk</a>
<a href="http://www.its4you.sk" target="_blank">http://www.its4you.sk</a>
skype: matussopko</pre>
</div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote>
</div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">Simone Travaglini<br>
328 5499846<br>
Linkedin: Simone Travaglini <br>
<br>
<br>
<span style="color:rgb(51,204,0)">Rispetta l'ambiente: non
stampare questa mail se non ti è veramente necessario!</span><br>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature">Simone Travaglini<br>328 5499846<br>Linkedin: Simone Travaglini <br><br><br><span style="color:rgb(51,204,0)">Rispetta l'ambiente: non stampare questa mail se non ti è veramente necessario!</span><br></div>