Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Monday, May 29, 2023

Wednesday, May 10, 2023

Project resource with Role ID lookup in D365

 Hi,


               SysReferenceTableLookup     sysRefTableLookup;

        Query                       lookupQuery = new Query();

        QueryBuildDataSource        lookupQueryDataSource;

        QueryBuildDataSource        PSASchedRoleQueryDataSource;


        sysRefTableLookup = SysReferenceTableLookup::newParameters(tableNum(ResourceCategoryView), _formReferenceGroupControl);


        sysRefTableLookup.addLookupfield(fieldNum(ResourceCategoryView, CategoryId));

        sysRefTableLookup.addLookupfield(fieldNum(ResourceCategoryView, Name));


        lookupQueryDataSource = lookupQuery.addDataSource(tableNum(ResourceCategoryView));


        

        PSASchedRoleQueryDataSource = lookupQueryDataSource.addDataSource(tableNum(PSASchedRole));

        PSASchedRoleQueryDataSource.relations(false);

        PSASchedRoleQueryDataSource.joinMode(JoinMode::ExistsJoin);

        PSASchedRoleQueryDataSource.addLink(fieldNum(ResourceCategoryView, RecId), fieldNum(PSASchedRole, RecId));


Regards,

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,