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

AS363 · ‎05-13-2020

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 · ‎05-15-2020

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

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Jaspal Singh · ‎05-13-2020

Hi,

Can you kindly confirm the tables that you have created a view for? Also, a screenshot of the same would be of help for a fix.

AS363 · ‎05-13-2020

HI I am joining two custom tables.

As you can see in the screenshot, I have written the join following the syntax.

Also I have added the fields in the VIEW Field list

Jaspal Singh · ‎05-13-2020

Can you change your Where clause as below.

PM.sys_id=CPB.task

Also, try it in lower case as below (make sure you change variable prefix from PM to pm & from CPB to cpb)

pm.sys_id=cpb.task

Jaspal Singh · ‎05-15-2020

Did above work? Or it was something else. If so, would you mind sharing the solution.