Skip to main content

Form Auto refresh in D365 fo

Here I will explain one of the requirements I came across to refresh from automatically without User interaction. 


Note: Make sure we do have all the handlers to stop UIrefreshing after certain hours of execution, else it causes the system to slow down after a certain time of continuous usage of this UI

in the below example to overcome this case we use to check session login time and stopping form to refresh after certain hours of execution.

Recommended to use this on pages that hold less data or smaller data sets.



  • -NoofSeconds.value() is an integer control on UI that allows the user to choose a value.( best to fix a value like 5 seconds or a Minimum value to avoid unnecessary executions)

Create a new form method and create as of below.


void refreshFormWithTimeout(AsyncTaskResult _result)

    {

        System.Exception ex;

        try

        { 

            if(!element.closed() &&  NoofSeconds.value() > 0) // Make sure UI not to refresh if form close or input = 0

            {

                xSession xSession = new Session(); 

                real diff = DateTimeUtil::getDifference(DateTimeUtil::utcNow(), xSession.loginDateTime()) / 60 / 60; // Getting user session to make sure to stop auto refreshing after certain time based on configuration            

                if (prodParameters.DellSessionTimeout == 0 || diff <= prodParameters.DellSessionTimeout) // Config created to kill refreshing post exceeding certain time I.E 8 hours

                {

                    Formdatasource1_ds.executeQuery();

                    this.setTimeOutEX(formMethodStr(Formname,refreshFormWithTimeout),ConNull(), NoofSeconds.value() * 1000);

                }

            }  

        }

        catch (ex)

        {

          

        }

    }

........................... Create other form method and call refreshFormWithTimeout


void refreshForm()

    {

         this.setTimeOutEX(identifierstr(refreshFormWithTimeout),ConNull(), NoofSeconds.value());

    }

 Override form Run method and call refreshForm form

public void run()

{

     super();

    element.refreshForm();

}

...................................................
override modified method for the control created NoofSeconds initially and call refreshForm as below. This is to reflect the modified time if your change refresh count.

[Control("Integer")]

    class NoofSeconds 

    {

        /// <summary>

        ///

        /// </summary>

        /// <returns></returns>

        public boolean modified()

        {

            boolean ret;

    

            ret = super();

            element.refreshForm();

    

            return ret;

        }

    }


Due to system limitations, we cannot place screenshots, reach out to chandu.noudu@gmail.com for any clarification/Queries.

Comments

Post a Comment

Popular posts from this blog

Splitting Sring through X++ in DAX

  Splits a string into a list of substrings delimited by elements in the specified delimiter string. static void StringSplit(Args _args) {        List            list = new List(Types::String);     container PackedList;     ListIterator  iterator;     str can = "Lev_Sales00001_1";         list = Global::strSplit(can,"_");     iterator = new ListIterator(list);     while(iterator.more())     {       PackedList +=   iterator.value();         iterator.next();     }     info(conPeek(PackedList,1));         } output :  
Post a Comment
Read more

SQL script to Fetching Tables list holding more data

  There may be times when we need to restore a database from a non-production or production environment for troubleshooting purposes, and we may encounter a DB size issue or need to know a list of tables with large amounts of data in order to enable purging them. This query returns a list of tables that contain large amounts of data in sequential order.  Query to Execute in SQL SELECT s.Name AS SchemaName             ,t.Name AS TableName             ,p.rows AS RowCounts             ,CAST(ROUND((SUM(a.used_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS Used_MB             ,CAST(ROUND((SUM(a.total_pages) - SUM(a.used_pages)) / 128.00, 2) AS NUMERIC(36, 2)) AS Unused_MB             ,CAST(ROUND((SUM(a.total_pages) ...
Post a Comment
Read more