Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Creating view
Finance | Project Operations, Human Resources, ...
Suggested answer

Creating view

(1) ShareShare
ReportReport
Posted on by Community member 12
When creating view, where do you set “order by asc” property? I cannot see any sort column in properties window.
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,587 Super User 2024 Season 1 on at
    Creating view
    There is no such property mentioned. Instead you can create a query and use it in the view where you can set the ordering in the query level.
  • Suggested answer
    Layan Jwei Profile Picture
    Layan Jwei 7,264 Super User 2024 Season 2 on at
    Creating view
    Hi Community member,
     
    There is no such property as far as i'm aware of, the view is already sorted asc by default based on the primary key. Are you using the view on a form?
     
    If yes, then once the form opens, you can filter by any field asc or desc.
     
    If you don't like to keep filtering each time you open the form, then you can save a new view and pin it as default.
     
    Open the form - click on "yourField" and sort newest to oldest or oldest to neweset - save the view as - tick "pin as default view"
     
    Thanks,
    Layan Jweihan 
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Creating view
    Thanks for your clarification. Will help to move to Finance and operation community.
  • Community member Profile Picture
    Community member 12 on at
    Creating view
    Sorry for the missing info.
    i customize D365FO, and I would like to know how to setting in properties.
     
  • Martin Dráb Profile Picture
    Martin Dráb 230,371 Most Valuable Professional on at
    Creating view
    D365 consists of many applications, such as Finance and Operations, Sales or Business Central. You're asking in D365 general forum, therefore it's not clear which product you have in mind. Please add this information.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans