Dynamics Community Forum Thread Details

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

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?

Quick Links

Leaderboard