[Vtigercrm-developers] Table vtiger_def_org_field

[Uma S]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200731/b9f5c6cd/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/b9f5c6cd/attachment-0001.png>