Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Data Management Export...
Finance forum
Answered

Data Management Export Filter options

Posted on by 242

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

  • Verified answer
    Hossein.K Profile Picture
    Hossein.K 6,642 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
    saurabh bharti 14,932 Super User on at
    RE: Data Management Export Filter options

    pastedimage1624331524363v1.png

  • Suggested answer
    RE: Data Management Export Filter options

    Thanks a lot Ergün Şahin

  • Verified answer
    ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    RE: Data Management Export Filter options

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

  • AnithaEswaran Profile Picture
    AnithaEswaran 2,030 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans