Hi Dax Techies,
I wrote below code in list page interaction class initilizeQuery() Method.
HcmWorkerRecId hcmWorkerRecId = Global::currentWorker();
if (hcmWorkerRecId && this.listPage().listPageArgs().menuItemName() == menuitemDisplayStr(LeaveApplicationDateOfReturnListPage))
{
qbds = _query.dataSourceTable(tableNum(HcmEmploymentLeave));
qbds.name("HcmEmploymentLeave");
qbds.addRange(fieldNum(HcmEmploymentLeave, Worker)).value(
strFmt('((%1.%2 == "%4") || (%1.%3 == "%4"))',
qbds.name(),
fieldStr(HcmEmploymentLeave, Worker),
fieldStr(HcmEmploymentLeave, Approver),
HcmWorkerRecId));
}
but my above expression is not at all working but when i build the same query using a job it is giving correct string like below
SELECT * FROM HcmEmploymentLeave(HcmEmploymentLeave) WHERE ((((HcmEmploymentLeave.Worker == "5637157327") || (HcmEmploymentLeave.Approver == "5637157327"))))
Below two ranges how can i frame using OR expression
HcmWorkerRecId hcmWorkerRecId = Global::currentWorker();
qbds.addRange(fieldNum(HcmEmploymentLeave,Worker)).value(int642str(hcmWorkerRecId ));
qbds.addRange(fieldNum(HcmEmploymentLeave,Approver)).value(int642str(hcmWorkerRecId));
can anybody help me.
Thanks,
Krishna
