how can i get the list of workers attach to RetailstoreTable ?
You can directly use the query mentioned by komi in the code. If you are using query - Don't use while select - You can pass the query with range to parmQuery method.
Refer to the below blog for using static AOT query in X++.
https://daxbeginners.wordpress.com/2014/08/19/how-to-use-aot-query-through-x/
Thanks,
Girish S.
i try it , i get all workers
public void lookup()
{
Query query;
DirAddressBookParty DirAddressBookParty;
RetailStoreAddressBook RetailStoreAddressBook;
DirPartyTable DirPartyTable;
QueryBuildDataSource Hcmworker;
QueryBuildDataSource DirPerson;
SysTableLookup sysTableLookup;
DirAddressBook DirAddressBook;
SICDeclarativeOfHumanServicesTable SICDeclarativeOfHumanServicesTableLoc = SICDeclarativeOfHumanServicesTable_ds.cursor();
RetailStoreTable RetailStoreTableL = RetailStoreTable::find(SICDeclarativeOfHumanServicesTableLoc.Establishement);
RetailchannelTable RetailchannelTable = RetailchannelTable::findByRecId(RetailStoreTableL.RecId);
sysTableLookup = SysTableLookup::newParameters(tableNum(HcmWorker), this);
query = new Query();
HcmWorker=query.addDataSource(tableNum(HcmWorker));
while select RetailStoreAddressBook
where RetailStoreAddressBook.AddressBookType==RetailAddressBookType::Employee
&& RetailStoreAddressBook.StoreRecId==RetailchannelTable.RecId
join DirAddressBookParty
where DirAddressBookParty.AddressBook==RetailStoreAddressBook.AddressBook
join DirPartyTable
where DirAddressBookParty.party == DirPartyTable.recId
{
HcmWorker.addRange(fieldNum(HcmWorker, person)).value(int642str(DirPartyTable.ReciD));
}
sysTableLookup.addLookupField(fieldnum(Hcmworker, PersonnelNumber));
sysTableLookup.addLookupField(fieldnum(Hcmworker, person));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
You need to join the above-mentioned tables to get the list of workers.
Thanks,
Girish S.
How can i use this query to get the list of workers
Hi OBarka,
In addition to the above comments, you need to join HcmWorker >> DirAddressBookParty >> RetailStoreAddressBook >> RetailChannelTable >> RetailStoreTable.
Thanks,
Girish S.
Hi Obarka, You can check Workers in Setup Tab in Stores form.
Hello OBarka,
Take a look at the following objects:
Menu item : HcmWorkerListPage_RetailStoreAddressBook
Query : HcmWorkerListPage_RetailStoreAddressBook
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156