web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Query Range with multi...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Query Range with multiple fields or values x++

(3) ShareShare
ReportReport
Posted on by SachinMittal 152
I have created a query of ProjTable , and have dialog to selected multiple values of an approver(Employee) and i want to check if any of these projtable fields contains selected approvers , that records should be selected

Categories:
Dynamics 365 Finance
I have the same question (0)
  • Suggested answer
    Raj Borad Profile Picture
    Raj Borad 1,424 on at
    Hi,
     
    In X++, You can get the data using select statement or using x++ query and it's range.
     
    Using Query range, Below link might be useful for you.
     
    or simply use select statement using multiple where conditions.
     
    Thanks & Regards,
    Raj D Borad
  • Waed Ayyad Profile Picture
    Waed Ayyad 9,039 Super User 2025 Season 2 on at
    Hi,
     
    Can you give us more details? Do you want to filter the table based on many fields? Did you start to write the query?
     
    In general, you can add many ranges on the query.
     
    Thanks,
    Waed Ayyad
  • Layan Jwei Profile Picture
    Layan Jwei 8,097 Super User 2025 Season 2 on at
    Hi,

    I don't understand your question fully.
     
    When you said " you have dialog to select multiple values of an approver(Employee)" Are you referring to those 6 level fields? or did u create a control with multi select lookup -- i really don't get it

    and the screenshot you showed to us, what is it?
     
     
    can you take a screenshot of the dialog and explain what you are trying to do exactly please
  • Waed Ayyad Profile Picture
    Waed Ayyad 9,039 Super User 2025 Season 2 on at

    Hi, 

    Is your issue resolved? If yes, mark the answers that helped you as verified. 

    Thanks,

    Waed Ayyad

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans