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]

[randrews]

no worries at all glad i could help!

[montanadawgz]

This worked 2 months ago, now it's broken with the same error listed above.

Having a similar problem except I am using the label name

Try it =

How can I make the rfc field visible?

[montanadawgz]

Found the solution.

In order for a field (element name to seen or recognized), you need to add it to the view.

The left outer join I created to link the Problem table to the Change request table is using the where clause

prob_rfc = chgreq_number

This means that I have to add the

Change Request field (rfc) to Problem table and

Number field (number) to the Change request table

Once I did this the error went away.