925
Hi All,
I have requirment to update a field after filter..
say, we have a grid with records, we apply filter by selection .. Now what i want to do is,, i want to select this filtered records and update a field ..
how to select this filtered records??
Pls Advice
*This post is locked for comments
Hey Rusty,
As I said in my initial reply you can use getFirst(), getNext(), please look at sniped proposed by Hariharan S.
Second option is to use query from form and iterate it, please find example below:
Share
Report
All responses (
Answers (
QueryRun qr = new QueryRun(myTable_ds.queryRun().query());
while (qr.next())
{
myTable = qr.get(tableNum(myTable));
}
Now when you have a record you can select it for update and modify, delete or do whatever you need.
To get all values even filtered records, you can the same code, but no need to pass the value to the datasource.getFirst() method.
Try the below code to get all values
MyTable myTable;
myTable = MyTable_ds.getFirst();
while(myTable)
{
info(strFmt('%1', myTable.RecId));
myTable = MyTable_ds.getNext();
}
Hi ievgen,, Can you share more code .. ? I am confused ..
while select forUpdate MyField from myTable
where myTable.MyField == NoYes::Yes
{
myTable.MyField= NoYes::No;
myTable.update();
}
As you mentioned to use queryRun, where i have to make the changes..
Pls Advice
Hey Rusty,
There are 2 queries on the form : initial query and current query (filtered)
You can get filtered query using this code :
MyDataSource_ds.queryRun().query()
now you can iterate query using query run to get all filtered records.
And i dont want to select the multiple records.. If i want to select the multiple records and update it , i have the answer in my previous post https://community.dynamics.com/ax/f/33/t/208267 where i got the answer with your help..
Here what i am trying to do is to select the records that are already filtered by FilterbyField or FilterBySelection..
Hi Rusty,
You can use formDataSource.getFirst(), getNExt() to loop through records
Please check this blog post community.dynamics.com/.../loop-through-record-from-data-source-ax-2012 to find code snippet or this http://daxmusings.codecrib.com/2013/01/multi-select-on-form-datasource-grid.html
#1
André Arnaud de Cal...
293,272
Super User 2025 Season 1
#2
Martin Dráb
231,931
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
