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 / Microsoft Dynamics AX (Archived) / How do I change the so...
Microsoft Dynamics AX (Archived)

How do I change the sort sequence on the batch job history grid in AX to Auto Start Date/Time descending

(0) ShareShare
ReportReport
Posted on by Community Member

Hello:

How do I change the sort sequence on the batch job history grid in AX to Auto Start Date/Time descending?

System Administration -> Batch Jobs -> Batch Jobs Descending

It defaults to ascending, so I get the oldest first, which really does not help

Using AX 2012 R3

Thanks,

Paul

 

*This post is locked for comments

I have the same question (0)
  • Florian Hopfner Profile Picture
    Florian Hopfner 2,461 on at

    You can either click on the column header to sort the data in the grid by that column (first click is ascending, second click is descending) or you can use Ctrl+F3 to open the advanced filter and sorting dialog and specify your sorting there.

  • Community Member Profile Picture
    Community Member on at

    Hi

    Thanks for the suggestions, but I am aware of both these methods.  Looking for a way to default the grid upon initial display and not by clicking on the date 2 times or selecting an advanced filter.

    Thanks,

    Paul

  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    Hi PaulVT,

    You can add something like this on init() method of ds:

    this.query().dataSourceTable(tableNum(MyTable )).addSortField(fieldNum(MyTable ,MyField),SortOrder::Descending);

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Ievgen's solution is correct, but I'd choose a different syntax.

    Open AOT > Forms > BatchJobHistory > Data sources > BatchJobHistory > Methods > init

    Add this code after the super() line:

        this.queryBuildDataSource().addSortField(fieldNum(BatchJobHistory, StartDateTime), SortOrder::Descending);

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans