Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Does anyone know how to filter on a field from an outer joined data source

Posted on by 2
Hi, so I have a problem.
 
I am working on a grid that represents buildings and its data sources are the building table and an outer joined legal entity table. This is so that the user can see who owns the building. The problem is that when I try to filter the column with the owning company's name (this is the column that was joined) with for example /compname/ then all the non-compname values disappear from the fields, rather than the amount of visible lines decreasing like what happens if you filter other columns.
 
I know that I can get the filter to work the same way in that column as the other columns by setting the legal entity data source to inner join, but that would exclude the buildings that are not owned from being visible on the grid, which is something that we need to be visible.
 
 
To sum up the problem I need the column that has been outer joined to the building columns to display the records both the records with and without a connection to the legal entity table, while also being filterable (i.e. reduce visible lines) like normal table columns are.
 
Do any of you have a solution for this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans