Report Error on custom field

[Sloff]

Hi, I have the following custom field within contact:

"birthdayThisYear": {
"type": "date",
"readOnly": true,
"notStorable": true,
"select": "birthday + INTERVAL (YEAR(CURRENT_DATE) - YEAR(birthday)) YEAR",
"notNull": false,
"required": false,
"audited": false,
"tooltip": false
},

The problem is when creating a report, with "birthdayThisYear" as a runtime filter, I'm receiving the following error within my logs:

[2018-05-08 12:12:17] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contact.birthday_this_year' in 'where clause', Code: 42S22 URL: /api/v1/Report/action/runList?id=5af193dababc166b2&maxSize=20&offset=0&s ortBy=lastName&asc=true&where%5B0%5D%5Btype%5D=las tSevenDays&where%5B0%5D%5Battribute%5D=birthdayThi sYear [] []

[tanya]

Hi,

define "where" option

Example:

application/Espo/Modules/Crm/Resources/metadata/entityDefs/Opportunity.json
amountWeightedConverted

[Sloff]

Thank you, do I only need to specify "=", "<", ">", "<=", ">=" and "<>", or are there other date specific things I need to specify as well?

[tanya]

I think this set is full. But didn't test