Monday, May 29, 2023

Your connection is not private

Hi,


Try opening in private mode, particularly in Chrome.

 

Regards

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,