[Vtigercrm-developers] Filter createdtime between error

[Rishab K]

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