[Vtigercrm-developers] Table vtiger_def_org_field

[Uma S]

Thanks! Ruben.

On Fri, Jul 31, 2020 at 10:13 PM Rubén A. Estrada Orozco <rulotec1 at gmail.com>
wrote:

> 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/
>
> _______________________________________________
> http://www.vtiger.com/



-- 
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200802/d92c70f9/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/20200802/d92c70f9/attachment-0001.png>