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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Data Management Export Filter options

(0) ShareShare
ReportReport
Posted on by 12

Hi, 

I am looking for the list of filter options available for Data Management Export. Example vendor from to, >=,  or date from date to.

pastedimage1624296273006v1.png

I have the same question (0)
  • Verified answer
    Hossein.K Profile Picture
    6,648 on at
    RE: Data Management Export Filter options

    Hi Hossam,

    If you mean AOT query (and not SQL select statement), you can't define such range directly in the Query properties.

    But you can add the ranges in x++ when you use the query: docs.microsoft.com/.../using-expressions-in-query-ranges

  • Verified answer
    saurabh bharti Profile Picture
    15,037 Moderator on at
    RE: Data Management Export Filter options

    pastedimage1624331524363v1.png

  • Suggested answer
    Hossam Z. EL Hassan Profile Picture
    12 on at
    RE: Data Management Export Filter options

    Thanks a lot Ergün Åžahin

  • Verified answer
    ergun sahin Profile Picture
    8,816 Moderator on at
    RE: Data Management Export Filter options

    docs.microsoft.com/.../advanced-filtering-query-options

  • AnithaEswaran Profile Picture
    2,032 on at
    RE: Data Management Export Filter options

    Hi Hossam,

    The fields displayed in the look up are the field list in data entities.

    If you are using standard entity, you need to extend it and try adding a new range in datasources or entity or bring the filter field in the list.

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 841 User Group Leader

#2
André Arnaud de Calavon Profile Picture

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

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 566

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans