Skip to main content

Posts

Showing posts with the label range

Batch job History Log Cleanup code in Axapta till specified date

You can clear log for batch job history in Ax by following code. This code can work in most of ax version . If you want to clear  log till some date that you can also specify in query . You can just copy and paste below code run or execute. BatchJobHistory BatchJobHistory; date startDate; TimeOfDay startTime; utcDateTime rangeStart; startDate=mkDate(21,12,2014); startTime = str2time("6:00:00 am"); rangeStart = DateTimeUtil::newDateTime(startDate,startTime); delete_from BatchJobHistory where BatchJobHistory.createdDateTime<rangeStart; //select count(RecId) from BatchJobHistory where BatchJobHistory.createdDateTime<rangeStart ; // info(strFmt("%1 till cleanup done ",BatchJobHistory.RecId)); info(strFmt("%1 till cleanup done ",rangeStart));

Design user control,Add lookup, Selected Index change code in Ax 2012

Design user control To design user control you need to open visual studio then you can create new user control on form designer you can do below steps. add data source- add formid-add axsection=add grid or group Then Add lookup.   Add dataset add control for lookup and set dataset and fields in  Add range on init method or any other method to get range value filter Autopostback to true property on field to save data immediately. selectedindexchangeevent code this.AxDataSource1.GetDataSet().DataSetRun.AxaptaObjectAdapter.Call("datasourceRefresh",DropDownList1.SelectedItem.Text);