Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Workspace Filter based...
Finance forum
Under review by Community Managers

Under review

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

Workspace Filter based on a query with an outer join

Posted on by
 
Hi, I'm building a workspace and using the SysIFilterEventHandler functionality which works fine when I use inner joins on the base query of the form part.  But the filter logic does not seem to work with fields that reside on tables in the outer join part of my query. 

If, on the other hand, I replace the outer join on the base query with an inner join, then the filter works correctly.  Here is the code in the form part of the workspace
 
public class TestFormPart extends FormRun implements SysIFilterConsumerForm, SysIFilterEventHandler
{


    public void registerDatasourceOnQueryingEvent()
    {
        PurchTableAllVersions_ds.OnQueryExecuting += eventhandler(this.parmFilterFormQueryEventHandler().applyFilter);
    }

    public void onFilterChanged()
    {
        PurchTableAllVersions_ds.executeQuery();
    }



}
any suggests?
 

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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,661 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans