tag:blogger.com,1999:blog-37898244.post7886263845736903330..comments2024-03-09T12:43:41.082+08:00Comments on Moving on to D365 Finance and Operations: AX2012 R2 Get a list of Duties and Privileges based on Security Rolefattunghttp://www.blogger.com/profile/02556227973766369145noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-37898244.post-7830384650325681172017-09-04T20:58:52.651+08:002017-09-04T20:58:52.651+08:00Many thanks, very helpful!Many thanks, very helpful!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-37898244.post-70594544025388666802016-08-17T18:09:21.432+08:002016-08-17T18:09:21.432+08:00Thank you for sharing! I’m now working on adverti...Thank you for sharing! I’m now working on <a href="http://axadsystem.com/advertising-management-software" rel="nofollow"> advertising management software</a> project, this solution builds on the Microsoft dynamics architecture, so maybe I will need to get a list of duties and privileges based on a security role. In this case, the script will be extremely useful :)Anonymoushttps://www.blogger.com/profile/00996110121647112055noreply@blogger.comtag:blogger.com,1999:blog-37898244.post-39222520487203005372016-04-15T13:51:50.396+08:002016-04-15T13:51:50.396+08:00Try this and see if it is what you want. Add the c...Try this and see if it is what you want. Add the code below after line 37:<br />JOIN ModelElementLabel label1<br />ON secTAsk.name = '@' + label1.Module + CONVERT(NVARCHAR(20),label1.labelID)<br />AND label1.Language = 'en_us'<br /><br />And add label1.text to your selection.<br /><br />Repeat this exercise for subtask (SecTask2).fattunghttps://www.blogger.com/profile/02556227973766369145noreply@blogger.comtag:blogger.com,1999:blog-37898244.post-35862395537723970502016-04-14T16:15:59.876+08:002016-04-14T16:15:59.876+08:00This is a great one. Thank you very much.
Is ther...This is a great one. Thank you very much. <br />Is there a way to show the Privilege/Duty descriptive name instead of the AOTname for tasks and sub-tasks ?Anonymoushttps://www.blogger.com/profile/15401243557116936300noreply@blogger.com