Sorting issue - How to show the newly created Project on the top of the All projects list form

(0) Share

Report

Posted on by Community Member

I added a new field - creation date on Project Management and Accounting > Common >Projects > All Projects list. I like the list is displayed in descending order of creation date by default. Basically I like to see the newest project on the top of the list. Currently the default is ascending order so the newest project is on the bottom of the list.

I added following code in openProjectsListPage method which is in projProjectListPage class

QueryBuildDataSource qbds;
qbds.addSortField(fieldNum(ProjTable,Created),SortOrder::Descending);

It didn't work. Does anybody know how to do it.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

This is due to the Primary Index on the table..

may be you should consider updating ProjTable Index and add the new field (Created) in it for your requirment

Please verify and update us with your findings

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,069 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The list page is based on ProjTable_NoFilter query, which defines the following sorting under Order By node: ProjId (ascending), Name (ascending). You can remove these sort fields, add you own and/or change Direction property of a sort field to Descending.

Was this reply helpful? Yes No
Suggested answer

dolee 11,279 on at

Like (0)

Report
Copy link

Link copied!

The Project list page is based on the ProjTable_NoFilter query.

The query by default is sort by ProjTable.ProjId (asc) and ProjTable.Name (asc). Edit the "Order By" setup of this query should get you what you want.

In addition, even if changing index was a solution, I'd suggest think twice before doing so because modifying indexes could potentially affect other queries.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Dominic. It worked after I changed Order By on the ProjTable_NoFilter query.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks to Martin too!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for your responding. For the safe reason, I only changed order by on the ProjTable_NoFilter query. It works!

Was this reply helpful? Yes No