Database view giving error: Syntax Error or Access Rule Violation detected by database ((conn=395195) Unknown column 'cod.a_str_22' in 'on clause')

[TT3]

I am trying to create a database view. After specifying all the details, when I click on Try It link, I am getting below error.

Syntax Error or Access Rule Violation detected by database ((conn=395195) Unknown column 'cod.a_str_22' in 'on clause')

I have checked:

• There is no column named a_str_22 in the table which aliases cod.
• None of the where clause refers to a_str_22 column for table which aliases cod.
• The table which aliases cod, does not have any access restriction. I was able to create another view in the same scope.

Am I missing anything?

Note: Relevant answers/comment will be marked appropriately.

[Miguel Donayre]

Hi,

Can you show the Database view and all the details you set up?

[TT3]

Here is the setup. Thank you.

[Miguel Donayre]

In the 3rd entry, the "cod_u_csad_sku ='MSB-MRC' is that a reference field on the table? 

[TT3]

nope, it is just a text/string field.