[Vtigercrm-developers] reports and created dates

[Uma S]

Alan,

Will look into this migration changes and update you back.

On Thu, May 28, 2015 at 7:50 PM, Alan Bell <alan.bell at libertus.co.uk> wrote:

>  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>
> 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
>
>
> _______________________________________________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/20150529/82bf012c/attachment.html>