I can't do dot walking in a report through the database view

[Ariomar de Deus]

I created a database view to prepare a report, however I have a situation but I don't know if it is possible to do it, I need to do the dot walking between the item variables to be displayed in the report, but every time I do the dot walking the variables are not inserted. I don't know if there is a missing condition in the where clause or if refeeding is not possible to do such a feat.

[Juhi Poddar · Accepted solution]

Hello @Ariomar de Deus 

If you're trying to dot-walking a reference field in Where clause of the joining tables, it will be no you can't.

Refer the post: Can we use dot walking in the database view?

You can join multiple tables to meet your requirement.

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You
Juhi Poddar