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]

Hi,

on which table the views are defined? screenshot please

Regards
Ankur

[AS363]

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

[Ankur Bawiskar]

Hi,

So you have added Number view field on Project view table

Also added task field on view field

Can you try to set it to lowercase and try once

Also set order for cost_plan_breakdown as 200

PM_number = CPB_task

The fields used in query should be identical to the column name in table;

prefix can be anything

1) When fields are in capital

2) when fields are based on table

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[AS363]

HI Ankur,

I have tried the case restriction already, it is not working, ie, still getting empty rows

Just now i tried changing  order for cost_plan_breakdown as 200

still i m getting same result

[Ankur Bawiskar]

Hi,

are there any records satisfying that condition?

check on cost_plan_breakdown table by applying that filter

Regards
Ankur