[Vtigercrm-developers] Table vtiger_def_org_field

[Rubén A. Estrada Orozco]

Ok, I've opened a new issue for that:
https://code.vtiger.com/vtiger/vtigercrm/issues/1446
Saludos

Rubén


On Fri, Jul 31, 2020 at 12:22 AM Uma S <uma.s at vtiger.com> wrote:

> Hi Ruben,
>
> You're right, Here fieldid is a primary key. While analyzing the code for
> inserting data into vtiger_def_org_field i observed that during profile
> creation respective tabid and related fields of tab is pushed into this
> table only if entry for particular fieldid won't exist.
>
> Yes! i do agree to remove this table. At the same time I also observed
> many dependencies on this table. Which is always used along with table
> 'vtiger_profile2field'. So we need to first review and decouple the
> dependencies before removal.
>
> On Thu, Jul 30, 2020 at 10:27 PM Rubén A. Estrada Orozco <
> rulotec1 at gmail.com> wrote:
>
>> Hi Uma,
>>
>> I'm not sure I understood your answer. You say: "profile level field
>> visibility is stored in this table". That table has fieldid as primary key.
>> That means there cannot be one entry per profile for a given field. Also
>> there is no profileid there. I suspect this table should be removed. But
>> I'm not really sure.
>>
>> Saludos
>>
>> Rubén
>>
>>
>> On Thu, Jul 30, 2020 at 2:52 AM Uma S <uma.s at vtiger.com> wrote:
>>
>>> Hi Ruben,
>>>
>>> I reviewed through this usage of vtiger_def_org_field table and noticed
>>> that profile level field visibility is stored in this table.  Also when the
>>> field visibility is changed through profile, visibility status is updated
>>> only in vtiger_profile2field.
>>>
>>> All the active fields of profile are entered into this table during
>>> profile creation. subsequent changes on field visibility is not tracked
>>> here.
>>>
>>> We need to review the dependency to decouple this.
>>>
>>> On Thu, Jul 30, 2020 at 9:02 AM Rubén A. Estrada Orozco <
>>> rulotec1 at gmail.com> wrote:
>>>
>>>> Hi everyone,
>>>>
>>>> Anybody has any idea what the table vtiger_def_org_field is used for?
>>>>
>>>> [image: image.png]
>>>>
>>>>
>>>> Saludos
>>>>
>>>> Rubén
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>
>>>
>>>
>>> --
>>> With
>>> Best Regards
>>> Uma.S
>>> Vtiger Team
>>> _______________________________________________
>>> http://www.vtiger.com/
>>
>> _______________________________________________
>> http://www.vtiger.com/
>
>
>
> --
> With
> Best Regards
> Uma.S
> Vtiger Team
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200731/85fe7ee3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 20024 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200731/85fe7ee3/attachment-0001.png>