Job to update sync log table

-
static client void updateNotSynced2(Args _args)

{

   SysVersionControlSynchronizeLog         syncLog;

   SysVersionControlSynchronizeBatchNum    lastNum;

   boolean                                 entered = false;

   //find last batch num

   select firstOnly BatchNum from syncLog

   order by syncLog.BatchNum desc;

   lastNum = syncLog.BatchNum;

   setPrefix('Numbers to process:');

   //classes

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Classes*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for classes is: %1', lastNum));

   }

   //forms

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Forms*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Forms is: %1', lastNum));

   }

   //tables

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Data dictionary*Tables*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Tables is: %1', lastNum));

   }

   //extended data types

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Data dictionary*Extended data types*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for EDTs is: %1', lastNum));

   }

   //base enums

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Data dictionary*Base enums*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Enums is: %1', lastNum));

   }

   //menu items

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Menu items*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Menu items is: %1', lastNum));

   }

   //shared projects

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Projects*Shared*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Shared projects is: %1', lastNum));

   }

   //jobs

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Jobs*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Jobs is: %1', lastNum));

   }

   //SSRS Reports

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*SSRS Reports*Reports*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for SSRS reports is: %1', lastNum));

   }

   //Security roles

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Security*Roles*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Roles is: %1', lastNum));

   }

   //Security duties

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Security*Duties*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Duties is: %1', lastNum));

   }

   //Security privileges

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Security*Privileges*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Privileges is: %1', lastNum));

   }

   //Menus

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Menus*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Menus is: %1', lastNum));

   }

   //Services

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Services*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Services is: %1', lastNum));

   }

   //Code permissions

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Security*Code permissions*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Code permissions is: %1', lastNum));

   }

   //Workflow

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Workflow*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Workflows is: %1', lastNum));

   }

   //Parts

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Parts*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Parts is: %1', lastNum));

   }

    //config keys

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Data dictionary*Configuration Keys*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for config keys is: %1', lastNum));

   }

    //maps

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Data dictionary*Maps*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for maps is: %1', lastNum));

   }

    //Views

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Data dictionary*Views*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Views is: %1', lastNum));

   }

    //Queries

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Queries*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Data Sets*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;
 
     if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Forms is: %1', lastNum));

   }

    ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*labels*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;
     if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Forms is: %1', lastNum));

   }

    ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Macros*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;
     if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Forms is: %1', lastNum));

   }

    ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Security*Process Cycles*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;
     if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Forms is: %1', lastNum));

   }

    ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Service Groups*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

     if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Forms is: %1', lastNum));

   }
 
    ttsBegin;

   while select forUpdate syncLog

       where syncLog.Processed == NoYes::No &&

             syncLog.ItemPath  like '*Visual Studio Projects*'

   {

       syncLog.BatchNum = lastNum + 1;

       syncLog.update();

       entered = true;

   }

   ttsCommit;

   if (entered)

   {

       lastNum++;

       entered = false;

       info(strFmt('Batch number for Queries is: %1', lastNum));

   }

}

Comments

Post a Comment

Popular posts from this blog

AX 2012 DEVOPS Build, Release setup and configuration

-
Image
After the initial setup in  AX 2012 Build process using AZURE DEVOPS Next step is to setup the build template and run the build process to get model and modelstore file which can be deployed to any environments. Goto your AZURE - DEVOPS dashboard by login to  https://visualstudio.microsoft.com/vso/ If you dont have a account, you can register for one free. Azure DEVOPS dashboard Select project for build process setup Select builds Click new pipeline Select Team foundation version control or the one you setup in intial step to move code to azure repo Select build reporsitory It should be the one you selected in initial setup steps Here select TFVC reporsitory Server path is the branch for which you want the build run Local path under - sourcesdirectory click continue for next step Select a build template - empty pipeline and add the build steps as per the AX build process order Now at the final step of build pipeline creation If you haven&
Read more

AX 2012 Build process using AZURE DEVOPS

-
Image
Deployment pipeline in AX is always been a challenge. But this has improved a lot over the years with AZURE DEVOPS. This post details how to setup your deployment pipeline using Azure DevOps (Previously VSTS). Using below process, we can build a modelstore for AX 2012 without a local Team foundation server and license cost. Firstly we need a server with windows installed and a working AX environment. Go to  https://visualstudio.microsoft.com/ Click on Azure Devops, enter the required details, select Team foundation version control and create a project. Goto Repos and create a new folder to store the code belongs to your custom model To add code to azure repo, go to AX and enable the version control parameters and check in the model to move all the custom code to Azure. Now under version control tab select Add model to version control, select the correct model and repository folder and click Ok  to move all the custom model objects to Azure r
Read more

What is Microsoft Power Platform?

-
Image
In today's world, data is growing immensley and its very important for any individual, organisation or a service to run successfully. With control of data, we can make better decisions and provide great value. Control of data, is crucial not only to an organization’s growth, but also to prevent losses. Microsoft powerplatform  empowers everyday users with the ability to create apps, visualisations and workflows to help them and their colleagues achieve more. You can leverage data by automating common business tasks, building reports, creating workflows and connect apps. Power Platform is comprised of four key products: Power Apps, Power Automate, Power BI and Power Virtual Agents. Power Platform has been designed to be simple to use, even for those with limited technical expertise, to lower the technical threshold and put the power into users hands. This all helps to promote digital transformation as a mind-set throughout an organisation. Gartner recognizes Microsoft as a Magic Qua
Read more