[Vtigercrm-developers] reports and created dates

[Alan Bell]

Hi Uma,

it turns out this was a migration issue, the typeofdata was set to T~O 
and had not been changed to DT~O

Alan.

On 28/05/15 12:31, Uma S wrote:
> Thanks! Alan.
>
> On Thu, May 28, 2015 at 4:07 PM, Alan Bell <alan.bell at libertus.co.uk 
> <mailto:alan.bell at libertus.co.uk>> wrote:
>
>     OK, maybe this is because it is a migrated database, I will dig a
>     bit deeper, thanks Uma.
>
>     Alan.
>
>
>     On 28/05/15 09:16, Uma S wrote:
>>     Sorry! We are not able reproduce this advance filters of Reports
>>     also checked against demo.vtiger.com <http://demo.vtiger.com>.
>>
>>     Please do check if it's possible to reproduce this issue in demo,
>>     which will be useful to dig in dipper into the issue.
>>
>>     On Wed, May 27, 2015 at 6:01 PM, Alan Bell
>>     <alan.bell at libertus.co.uk <mailto:alan.bell at libertus.co.uk>> wrote:
>>
>>         if you create a report and filter on a regular date field you
>>         get options like "last 30 days" or "Current FY" which is
>>         quite cool, but these don't work on created and modified
>>         dates. This is because the fieldType for these is T and not
>>         DT, when it comes to the code in
>>         layouts/vlayout/modules/Vtiger/resources/AdvanceFilter.js
>>
>>         if you change the following lines:
>>         line 109
>>                 if(fieldType == 'D' || fieldType ==
>>         'DT'||fieldType=='T'){
>>
>>         line 116
>>               if(fieldType != 'D' && fieldType != 'DT' &&
>>         fieldType!='T') {
>>
>>         then they are considered date type fields and work just great
>>         (I have no idea if DT is a valid fieldtype, but when these go
>>         through that code they are T)
>>
>>
>>         Alan.
>>         _______________________________________________
>>         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
>
>
> _______________________________________________
> http://www.vtiger.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150528/7a3b1aa7/attachment-0001.html>