Data descending order in form

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi all,

I have done some customization, in one form i have created a number sequence in one table. But i have one more serial number field in different table, i need to achieve the serial numbers to be descending order in my form. please help me on this.

thanks,

Stalin

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Data descending order in form

Thanks Suresh,

it is working.

Thanks,

Stalin
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Data descending order in form

Hi Stalin,

try with this code in serial number field table executeQuery

public void executeQuery()
{

Table1_1_ds.query().dataSourceNo(1).sortClear();
Table1_1_ds.query().dataSourceNo(1).addSortField(fieldNum(Table1, IndentNumberToUnit),
SortOrder::Descending);
super();
}

Thanks,
JoeBrewer 690 on at

Like (0)

Report

RE: Data descending order in form

Hi Stalin

To achieve this you will need to add an order by clause to the query in the form. Have a look at this thread: https://community.dynamics.com/ax/f/33/t/127335

Joe
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Data descending order in form

Hi Stalin ,

as per my understand you need to show the data by descending order right?

You can sort order your form table data-source.

which ever your want the data to be descend you can write the login execute query in form second table data source.

This is just a suggestion.

Thanks,