Sunday, March 11, 2018

How to auto populate a people picker field based on another people picker field?

Refer the below link for details:
https://community.nintex.com/thread/17850-how-to-auto-populate-a-people-picker-field-based-on-another-people-picker-field
NWF.FormFiller.Events.RegisterAfterReady(function () { 
     NWF$(document).ready(function() {
          NWF$("#"+var_People1).change(function() {
               // first wipe out existing state of the field
               NWF$("#"+var_People2).val("");
               NWF$("#"+var_People2).closest("div.ip-container").find("div.ip-item").each(function() { NWF$(this).remove(); });
               // then fill it with the scope set in field 1
               NWF$("#"+var_People2).val(NWF$(this).val());
               NWF$(this).closest("div.ip-container").find("div.ip-item").each(function() { NWF$("#"+var_People2).closest("div").find("textarea").before(NWF$(this).clone(true,true)); });
          });
    });
});

Thursday, September 14, 2017

Container and unbounded string fields are not allowed in a WHERE expression.

I had a requirement to store huge data of xml into AX table i.e. I used string size as [MEMO].
Response1, Response2 & Response3 are Memo Fields.

Now my requirement is to perform to select some data based on where conditions checking Response 1, Response 2 &; Response 3 parameters but it gives me Error

  while select * from appLog
            where appLog.ReceiptNo == ""  && appLog.Response1 != "" && appLog.Response2 != "" && appLog.Response3 == ""
        {
                resultSet.addEnd(appLog.Response2);
       
        }


Container and unbounded string fields are not allowed in a WHERE expression.

Note: After finding error details I came to know you can not use MEMO fields in where clause and have to use IF condition .

Therefore the query was changed as below.

  while select * from appLog
            where appLog.ReceiptNo == ""
        {
            response1 = appLog.Response1;
            response2 = appLog.Response2;
            response3 = appLog.Response3;
         
            if(response1 != "" && response2 != "" && response3 == "")
            {
                resultSet.addEnd(appLog.Response2);
            }
        }


Tuesday, August 22, 2017

X++ code to Count Records in Query


Refer below link

http://learnax.blogspot.qa/2010/09/x-code-to-count-records-in-query.html

Dialog box in AX

Refer below link

https://axchaitu.wordpress.com/2013/07/26/get-dialog-box-of-yes-or-no-for-any-operation-by-user-in-ax/

unable to save method … Dynamics Ax 2012 R3

Refer Below Links

https://community.dynamics.com/ax/b/alirazatechblog/archive/2015/01/19/unable-to-save-method-dynamics-ax-2012-r3

https://www.tech.alirazazaidi.com/unable-to-save-method-dynamics-ax-2012-r3/

Tuesday, August 1, 2017

How to use .NET DLL in AX

Please refer the below blog com

You can create .net class library project.
Register the .dll into dynamic AX

Code:

static void PushNotification(Args _args)
{
   
   CodeAccessPermission permission;
   PushNotificationAPI.PushNotification push;
 ;
   

 permission = new InteropPermission(InteropKind::CLRInterop);
 permission.assert();
 push = new PushNotificationAPI.PushNotification();
 push.SendAndroidPushNotification("Great Ashraf", "dZzhpCacCMQ:APA91bEMAMorxr9hCGoSx5WCrR1eocjxPY30IDn9V0aWblp1lr6Bb2XQkS0glflLZt5x0LMXKKTbqydLoXxKgpBSYGy9SigEZBqyASxuRGSUBARTvFfx-WUmliBPV1cMAkDxSyJ4kTBM");
   
}
https://nasheet.wordpress.com/2012/05/21/how-can-we-use-dll-in-ax/