Where clause in view has an invalid field or a field that is not visible

[AS363]

I have joined two tables and added the required fields in View Tables - > View fields also. Yet I am getting the same error as the view is unable to identify the field I am trying to fetch.

Any idea on how to resolve it? TIA

[Ankur Bawiskar · Accepted solution]

Hi Jaspal,

I think it should be below as cost_plan_breakdown has task field; prefix can be anything

lowercase or uppercase; also fields with underscore _

PM_sys_id = CPB_task

Regards
Ankur

[AS363]

this worked. thank you

[Jaspal Singh]

Thanks Ankur for the insight.

So, 

PM.sys_id=CPB.task

OR

pm.sys_id=cpb.task

were correct above.

[Ankur Bawiskar]

Hey Jaspal,

Just now checked underscore and dot both are allowed.

Thanks for sharing the information.

Regards
Ankur

[Jaspal Singh]

Yes, that was the reason was eager to know what went wrong & thus had asked to share the correct answer here.