Creating a view I'm getting this error :Where clause in view u_server_to_service_and_alert_test has an invalid field or a field that is not visible (ale_configuration_item)

[luislembertsant]

[Dennis R]

Ignore my previous (deleted) post, the margin was cutting off the image.   Can you validate that the em_alert table has a field named configuration_item and the cmdb_rel_ci table has a field named child?   If they do, have you tried using dots?   (ale.configuration_item = rel.child)

[randrews · Accepted solution]

without seeing the where clauses we are guessing but are you sure that column is NAMED configuration_item and not cmdb_ci like it is used elsewhere in the database?

[luislembertsant]

You are rigth! the field name is cmdb_ci not configuration item(display name).

you save my live!

Thanks

[luislembertsant]

You are rigth Doug!. I was using the display name(configuration item) instead of the column name (cmdb_ci).

Thanks