[Vtigercrm-developers] typeofdata for Date fields

[Darjan Prtic]

This is helpful! Thanks Prasad!
How can i set default value for date field to be NULL except someone changes it?

I just looked into the modules that have these special(new) date types
of data. They all have current date filled in by default, except
products module. But i also found that products field is handled by
EditViewUI.tpl separately of other fields. This means that
functionality for products is implemented in EditViewUI.tpl template
and not in typeofdata?

I found ticket regarding this issue, that has been closed as fixed.
http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4060#preview
Should i reopen this ticket?

thx!
Darjan Prtic



On Fri, Aug 13, 2010 at 13:06, Prasad <prasad at vtiger.com> wrote:
> 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/
>
> _______________________________________________
> http://www.vtiger.com/
>