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,

Is there any update on this? Is this question resolved or you need some more assistance.

Please consider marking appropriate reply as ✅Correct & 👍Helpful.

Regards
Ankur

[Ct111]

In where clause you might be writing wrong...

example if I refer incident as   inci_al   and in that if I want to refer to description then I should declare as below

inci_al_description   and not  inci_al.description

Hope this gives you some clue , note if you have configured everything correctly then you will see the resultant table , by clicking on Try it

Mark my ANSWER as CORRECT and HELPFUL if it helps

[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