[Vtigercrm-developers] typeofdata for Date fields

Darjan Prtic dprtic at gmail.com
Fri Aug 13 03:53:03 PDT 2010


Hello all!

I have just found out that there is no typeofdata for data fields that
should be empty! There is no such typeofdata or uitype that would
achieve this.
Example of this error you can find in vts-projects module Project
Actual End Date.
When creating new Project this field is automatically filled with
current date! This shouldn't happen! When i delete value from that
field displayview of that record for field Actual End Date has value
"--" what is equivalent in DB for NULL value. If you edit that project
field Actual End Date is again set to current date!
There should be special typeofdata for datefields that doesnt need to
be filled by current date.
I checked DB and found out that this problem is solved individualy for
every module/field. So we have some nonsenses like this

SELECT * FROM `vtiger_field` WHERE typeofdata LIKE "D~O~%"
typeofdata
D~O~OTH~GE~support_start_date~Support Start Date
D~O~OTH~GE~sales_start_date~Sales Start Date
D~O~OTH~GE~start_date~Start Date
D~O~OTH~G~start_period~Start Period
D~O~OTH~GE~sales_start_date~Sales Start Date
D~O~OTH~GE~start_date~Start Date
D~O~OTH~GE~start_date~Start Date

Can someone explain what are these types of data? Why this isn't standardized?
Should i make trac ticket for enhancement?

Darjan Prtic




More information about the vtigercrm-developers mailing list