[Vtigercrm-developers] lineitems in table vtiger_inventoryproductrel deleted and created in each edit

[Angelo Paglialonga]

Well in my opinion there should be a lineitem save event and tracking history like for accounts fields. What do you think?

_______________

Angelo Paglialonga
Consulente per soluzioni CRM ad alto ROI.

Telefono: 3386077866
Skype: angelo.paglialonga
Web: https://www.angelopaglialonga.com


> Il giorno 11 mar 2022, alle ore 08:31, Matus Sopko <sopko at its4you.sk> ha scritto:
> 
>  Yes, you are right. The "Update" process is done with Delete and Insert lineitems  again.
> I'm thinking about how to check if Productblock(lineitems) was changed.
> Maybe this control is more difficult like delete and insert again.
> 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 11. 3. 2022 o 3:28 Rubén A. Estrada Orozco napísal(a):
>> Today I noticed that every time you edit an inventory module record, its corresponding line items in the vtiger_inventoryproductrel are deleted and created again even if you don't change anything about line items. You can see that, because the "lineitem_id" in the vtiger_inventoryproductrel table changes and the previous ones get deleted.
>> 
>> For example, if you edit the subject of a quote, the line items are deleted and created again. Isn't that sort of inefficient? Or can it be considered a negligible waste of resources?
>> 
>> Saludos
>> 
>> Rubén
>> 
>> 
>> _______________________________________________
>> http://www.vtiger.com/
> 
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20220311/3cac2f4f/attachment.html>