I have a customized form linked with customized table CaeEmplTable. During the new employee creation, employee details gets inserted automatically in the CaeEmplTable.
I had to display a grid with CaeemplTable displaying list of Employee EID with Name. and required details.
I had to show the grid with only status ' Employed' on the grid on load. Currently it shows both Employee status and Terminated Employee.
Please advice where should I start with
What is your AX version? Always tag it.
VR.caeme said:status ' Employed'
Do you have the status field on CaeemplTable table? If so you can apply the range on that field set the value in executeQuery of the form data source.
. I do have status field on CaeEmplTable.
Apply the range on Status field in init method of the formdatasource and set the value to range in executeQuery method of the form data source.
For reference see, \Forms\InventQuarantineOrder (in this form search for criteriaComplete, to see the relevant code)
I have added the below query and it works.
public void executeQuery()