[Vtigercrm-developers] Filter createdtime between error

[Rishab K]

Cool :)


On Tue, Jul 8, 2014 at 11:52 PM, lajeesh k <lajeeshk at gmail.com> wrote:

> Hi Rishab,
>
> Thank you for your time
>
> Your tips really helped me to find out the issue.
>
> The issue was with typeofdata value for createdtime field in vtiger_field
> table. It should be "DT~O" instead of "D~O".
> Due to this error columname value vtiger_cvadvfilter table store incorrect
> value like
>
> vtiger_crmentity:createdtime:createdtime:SalesOrder_Created_Time:T
>
> itshould be like
>
> vtiger_crmentity:createdtime:createdtime:SalesOrder_Created_Time:DT
>
> So changing the typeofdata value fixed this issue
>
>
>
> Regards,
> Lajeesh
>
>
> On Tue, Jul 8, 2014 at 9:40 AM, Rishab K <rishab.k at vtiger.com> wrote:
>
>> Lajeesh,
>>
>> Search for the id of the custom view you created,this will be in
>> vtiger_customview table.
>> The fields associated with this id are stored in vtiger_cvcolumnlist
>> table.And the the attributes associated with this customview are stored in
>> vtiger_cvadvfilter table,look for the comparator field and value field
>> values in this table.All these three tables are related to eachother by
>> id/cvid column.
>>
>> Let us know if anything is missing.
>>
>>
>> On Mon, Jul 7, 2014 at 10:24 PM, lajeesh k <lajeeshk at gmail.com> wrote:
>>
>>> Hi
>>>
>>> I have created a filter with condition created time between two dates.
>>> It doesnot return any result. The same issue in report also when selecting
>>> between condition
>>>
>>> This is vtiger 6 migrated from version 5.4. I Doubt if the migration is
>>> incomplete because there is no entry about version 6 in vtiger_version
>>> table. Can anyone tell me  is there any reported bug or which file should I
>>> check for this issue.
>>>
>>>  I got this job to fix this error. And this migration is done by someone
>>> else. I have attached 2 images also. please have a look into that also
>>>
>>>
>>>
>>> Thanks
>>> Lajeesh
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140709/f8a3de9f/attachment.html>