Microsoft Dynamics AX (Archived)

How to select the records after filter by selection?

(0) Share

Report

Posted on by ThivaKar

931

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

I have the same question (0)

All responses (7)

Answers (1)

Mea_ 60,284 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ThivaKar 931 on at

Like (0)

Report

Hi ievgen,

MyTable myTable,myTable1;

;

myTable = MyTable_ds.getFirst(true);

while i debug it , no record is selected..

Pls advice

Was this reply helpful? Yes No
ThivaKar 931 on at

Like (0)

Report

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..

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ThivaKar 931 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Verified answer

Hariharans87 3 on at

Like (0)

Report
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(); }

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report
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:

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.

Was this reply helpful? Yes No

Community site session details

How to select the records after filter by selection?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

How to select the records after filter by selection?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates