HCMWorkerListPage textbased/combo box filtering

Finance and Operations/AX Developer Forum
1

Hello All,

I have a question w.r.t to HCMWorkerListPage. I know that AX does provide out of box filtering for criteria’s such as Name, Personnel number and many more. but I want to filter different criteria’s not mentioned in that list.

So I created a combo box called Created a combo box filter FIMMInstructorBiosFilterEducation in FCMHCMworkerListPage and tried the following:(Reference: msdn.microsoft.com/…/hh745335.aspx))

HCMworker table > executeQuery
comboFilter.value(element.design().controlName(“FIMMInstructorBiosFilterEducation”).valueStr());

super();

HCMWorker > init
super();
comboFilter = HcmWorker_ds.query().addQueryFilter(Hcmworker_ds.queryBuildDataSource(),“Person”);

  • Tried the same with dirPerson table also

  • As the combo box thing was not working I Created a string field(FCMTextString) in FCMHCMworkerListPage and tried querying the text based in the HCMWorker table
    HCMworker table > executeQuery
    qbrName = SysQuery::findOrCreateRange(
    this.queryBuildDatasource(),
    fieldNum(DirPerson,Name));
    qbrName.value(
    FCMTextString.text() ?
    ‘’+queryValue(FCMTextString.text())+’’ :
    SysQuery::valueUnlimited());
    super();
    no need of init as we have declared everything in execute query.This example I used from a book called microsoft_dynamics_ax_2012_development_cookbook (page no 118 and 119)

Please let me know if you all have any questions/concerns.

Thanks in advance for all of your reply

Regards

Shankar Iyer