Error 500 Invalid column name. Check the report parameters.

[Emmker]

When I create a filter in a report, if the filter has options like: contains, starts with, equals etc, when I try to save the report, it gives en error 500

Error 500
Invalid column name. Check the report parameters.

For example:
if I put Field - From Address - Contains - info
I get when I save:
Error 500
Invalid column name. Check the report parameters.

I do not have any errors with boolean fields or fields that have options : any of, is empty, none of etc.

Am I doing something wrong here?


My goal is to create a report panel, that lists the emails in a case that have not been answered by a specific email address.
I could do it with a filter with 'Replies . Sent By', but I would have to add any new user to that list which is not efficient.

But when I try to add the filter 'Replies . From Address' - 'contains' - 'test@email.com' I get the error.

[victor]

Try using From Email Address.Name instead of From Email Address.

[Emmker]

it works with From Email Address.Name.
But it does not work with Replies . From Address

[victor]

Try "Replies . From String" instead of "Replies . From Address".

[Emmker]

The "Replies . From String" stops the error but does not work.

Let me know if I get it right.
Replies . From String - not contains - test@email.com,
Should give me:
a list of emails, that have replies, that those replies are not sent by test@email.com.

Am I right?

[victor]

Let me know if I get it right.
Replies . From String - not contains - test@email.com,
Should give me:
a list of emails, that have replies, that those replies are not sent by test@email.com.

Should show emails "A" that are replies to emails "B". And these emails "B" should not have test@email.com in the From field.