[Vtigercrm-developers] typeofdata for Date fields

[Prasad]

Hi Darjan

Typeofdata contains meta information and can be of following formats:

DATATYPE~OPTIONAL_OR_MANDATORY
DATATYPE~OPTIONAL_OR_MANDATORY~OTH~COND~OTHERFIELDNAME~OTHERFIELDLABEL

Example:
expiry_date  has typeofdata 'D~O~OTH~GE~start_date~Start Date'

It means, expiry_date is a date type optional field should be greater than
start_date.

Regards,
Prasad
vtiger Team

On Fri, Aug 13, 2010 at 4:23 PM, Darjan Prtic <dprtic at gmail.com> wrote:

> 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
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20100813/5c323c46/attachment-0002.html