Announcement

Collapse
No announcement yet.

Account "notContains" filter not working [ERROR 500]

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Account "notContains" filter not working [ERROR 500]

    Hi,
    Others filters are just working great except "notContains" which just return ERROR 500
    When I look into the log file it says
    Unknown column 'account.email_address' in 'where clause'
    Please see the whole content of the log below.
    2020-09-03 07:32:51] Espo.ERROR: (42S22) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account.email_address' in 'where clause'; GET /api/v1/Account?select=name%2CemailAddressIsOptedOut%2Cema ilAddress%2CemailAddressData%2CaccountStatus%2CrGS %2CdoopinetUserID%2CjoinDate%2CbillingAddressStree t%2CbillingAddressCity%2CbillingAddressState%2Cbil lingAddressCountry%2CbillingAddressPostalCode&maxS ize=20&offset=0&orderBy=createdAt&order=desc&where %5B0%5D%5Btype%5D=in&where%5B0%5D%5Battribute%5D=e mailAddressIsFake&where%5B0%5D%5Bvalue%5D%5B%5D=YE S&where%5B1%5D%5Btype%5D=notContains&where%5B1%5D% 5Battribute%5D=emailAddress&where%5B1%5D%5Bvalue%5 D=fa_; line: 132, file: /var/www/d_app_crm/application/Espo/ORM/DB/Mapper.php [] []
Working...
X