How to filter the records thru a menu button in form

Finance and Operations/AX Developer Forum
1

Hi Everyone,

in form is it possible to filter the records when i clicked the menu item button.

for ex,

we ve 4 records . in tat a field is there called “status”

under tat we r having approved for one record and rejected for other three records…

nw if i clicked the filter menu item button means i need to get tat approved records alone… other 3 shud be deleted…

With Regards,

M.Madhan Kumar.

2

HI Madan,

When you click the menu item button the records which with approved status should be filter…rest all records you want delete it…

In the menu item button clicked write a select statement query where status equal to approved,then it wills how only the appoved records when you click it.

Naresh Kolli

3

Filtering the records does not mean deleting them…

4

ya ur right kranthi… so it shud display the filtered records alone… so wat i ve to do nw…

5

Hi Madhan,

Overiride the executequery() method in form datasource level…add the follwing line of code…

this.query().datasourcetable(tablenum(tablename).)addrange(fieldnum(tablename,status)).value(Status::Approved);

call the executequery() method in menuitembutton clicked() method…

Naresh Kolli