Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Set filter on form Datasource

(0) ShareShare
ReportReport
Posted on by 10

Hi, everyone

I have a form with two datasources (ProjTable and projDetail the relation between them is Projtable.ProjId == ProjDetail.Projid)

I have a grid based on ProjTable, and I need to show only the projects that exists in ProjDetail

how can I do that

thank for all

 

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Set filter on form Datasource

    Hi, As Anton mentioned,  it can be done by setting form datasource relations correctly. Check JoinSource property in ProjDetail datasource. You can refer to SalesTable form and refer to SalesLine datasource properties.

  • Anton Venter Profile Picture
    Anton Venter 19,493 Super User 2025 Season 1 on at
    RE: Set filter on form Datasource

    This should work without having to do anything if the correct relations have been added to the table in question. Is the relation on the table?  Check the "Join Source" property of the form datasource of the table in question on the form as well.

    Alternatively, if you want to set a filter on the datasource, that can be done in the excuteQuery method of the datasource (before the super call). Get the QueryBuildDataSource object from the query and set the filter.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans