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
Thanks Suresh,
it is working.
Thanks,
Stalin
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,
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
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,104 Most Valuable Professional
nmaenpaa 101,156