Creating a view and getting the error -Where clause in view u_requested_items has an invalid field

[sagar5]

I am getting below error while creating the view. 
Where clause in view u_requested_items has an invalid field or a field that is not visible (asset_u_task_number).

[Mr_X]

Hi @sagar5 ,

Kindly check the field backend name "asset_u_task_number" in alm_asset as the field name is wrongly referenced.

Please mark this as helpful if it resolves your issue.

Thanks.

[sagar5]

I was looking at the wrong table. it should have been alm_hardware. The db_view is working fine.
Another query- can we dotwalk to referenced record data on db_view?