Skip to main content

Notifications

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

how to filter records by morw than controls

Posted on by Microsoft Employee

Hi,

film.PNG

In this form how to filter by more than controlls, first filter by given from and to date than filter by site and than filter by warehouse.

filter by fromdate and to date , i did achive that, now i need filter by site and warehouse.

from-to date (inventjournaltran)table,site and warehouse (inventdim) table ,common field is inventdimid.

How to do this.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,149 Most Valuable Professional on at
    RE: how to filter records by morw than controls

    Add InventDim datasource joined to InventJournalTrans. If you need it only for filtering and you don't need to fetch data from it, use ExistJoin.

    Then add query filters for those fields. If you know how to do it for other fields, it shouldn't be a problem.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans