[Vtigercrm-developers] Filter createdtime between error

[lajeesh k]

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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140708/f085e5b9/attachment.html>