Sort form field with code

(0) Share

Report

Posted on by add

Hello experts,

I tried to sort a field in form grid by code but when I did it the sort stays there all the time. My goal is to give the user the option to clear the sort. Maybe I am doing something wrong. This is my code:

[FormDataSourceEventHandler(formDataSourceStr(ProdTable, ProdTable), FormDataSourceEventType::Initialized)]
public static void ProdTable_OnActivated(FormDataSource sender, FormDataSourceEventArgs e)
{
var ProdTable_Ds = sender as FormDataSource;
Query q = new Query();
QueryBuildDataSource ds = q.addDataSource(tableNum(ProdTable));
ds.addSortField(fieldNum(ProdTable, ItemId));
ProdTable_Ds.query(q);
}

Thanks

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

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

Like (0)

Report
Copy link

Link copied!
Sorting a datasource every time when a record is activated is a very strange approach. Don't you want to do it once when the form it being initialized? You can even do it without any code, by simply setting the Index property of the datasource. (You must create an index anyway for performance reasons.)

Also, when doing such things in code, you should modify the query used by the form, instead of replacing it with creating a new one (losing everything set up by the form). Like this:

ProdTable_ds.queryBuildDataSource().addSortField(fieldNum(ProdTable, ItemId));

Was this reply helpful? Yes No