Hi Darjan<br><br>Typeofdata contains meta information and can be of following formats:<br><br>DATATYPE~OPTIONAL_OR_MANDATORY<br>DATATYPE~OPTIONAL_OR_MANDATORY~OTH~COND~OTHERFIELDNAME~OTHERFIELDLABEL<br><br>Example:<br>expiry_date has typeofdata 'D~O~OTH~GE~start_date~Start Date'<br>
<br>It means, expiry_date is a date type optional field should be greater than start_date. <br><br>Regards,<br>Prasad<br>vtiger Team<br><br><div class="gmail_quote">On Fri, Aug 13, 2010 at 4:23 PM, Darjan Prtic <span dir="ltr"><<a href="mailto:dprtic@gmail.com">dprtic@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello all!<br>
<br>
I have just found out that there is no typeofdata for data fields that<br>
should be empty! There is no such typeofdata or uitype that would<br>
achieve this.<br>
Example of this error you can find in vts-projects module Project<br>
Actual End Date.<br>
When creating new Project this field is automatically filled with<br>
current date! This shouldn't happen! When i delete value from that<br>
field displayview of that record for field Actual End Date has value<br>
"--" what is equivalent in DB for NULL value. If you edit that project<br>
field Actual End Date is again set to current date!<br>
There should be special typeofdata for datefields that doesnt need to<br>
be filled by current date.<br>
I checked DB and found out that this problem is solved individualy for<br>
every module/field. So we have some nonsenses like this<br>
<br>
SELECT * FROM `vtiger_field` WHERE typeofdata LIKE "D~O~%"<br>
typeofdata<br>
D~O~OTH~GE~support_start_date~Support Start Date<br>
D~O~OTH~GE~sales_start_date~Sales Start Date<br>
D~O~OTH~GE~start_date~Start Date<br>
D~O~OTH~G~start_period~Start Period<br>
D~O~OTH~GE~sales_start_date~Sales Start Date<br>
D~O~OTH~GE~start_date~Start Date<br>
D~O~OTH~GE~start_date~Start Date<br>
<br>
Can someone explain what are these types of data? Why this isn't standardized?<br>
Should i make trac ticket for enhancement?<br>
<br>
Darjan Prtic<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></blockquote></div><br>