[Vtigercrm-developers] reports and created dates

[Uma S]

Thanks! Alan.

On Thu, May 28, 2015 at 4:07 PM, Alan Bell <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.
>
>  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>
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150528/ecb4e840/attachment.html>