D365F&O - X++ - Filter the form records based on the caller form in excuteQuery method

 1- Open the form designer.

2- Go to datasource, expand and right click on methods.

3-  select override executeQuery method.

public void executeQuery()
{
    // Get the calling  form record
    OrderRefundTable orderRefund = element.args().record();
    QueryBuildDataSource  queryBuildDataSource;            
    queryBuildDataSource = this.query().dataSourceTable(tablenum(OrderRefundTable));
    queryBuildDataSource.clearRanges();

    // Add range to your current form datasource
    queryBuildDataSource.addRange(fieldnum(OrderRefundTable, SalesId)).value
        (queryValue(orderRefund.SalesId));
    super();
   
}


Comments

Post a Comment

Popular posts from this blog

D365F&O - X++ - Best Practice Warning BP Rule: [BPErrorUnknownLabel]: Path:

To resolve the following error:  Path: [dynamics://Table/SalesTable/Field2]:Unknown label ‘@ZILabel:NewLabel’. Legacy labels (such as the label id @SYS12345) are case insensitive and modern labels (such as ‘MyLabelId’ in @MyLabelFile:MyLabelId) are case sensitive. Use upper casing when referring to legacy labels and exact casing for modern labels.  use  literalStr()  before the custom label. info(literalStr(" @ZILabel:NewLabel " ) ) ;
Read more

D365F&O - X++ - How to Enable/Disable button on form based on a condition in D365F&O using Event handlers.

Image
1- Create a new class SalesOrderFormEventHandlers . 2- Go to SalesTable form. 3- Expand SalesTable datasource. 4- Expand Events , right click on OnActivated and click on Copy event handler method. 5- Paste the code in your  SalesOrderFormEventHandlers class. 6- Save and build your project. class SalesOrderFormEventHandlers {     /// <summary>     /// Enable or disable Refund button     /// </summary>     /// <param name="sender"></param>     /// <param name="e"></param>             [FormEventHandler(formStr(SalesTable), FormEventType :: Activated)]     public static void SalesTable_OnActivated(xFormRun sender, FormEventArgs e)     {           // Button control name in your form design         #define.BUTTONNAME( 'JWRefundButton' )         FormDataSource form_ds = sender.dat...
Read more

D365FO - X++ - Generate CAR (Customized Analysis Report) report of custom model

Image
1- Open command prompt by clicking on "Run as Administrator". 2- Select the drive where your model and package exist in command prompt. My custom model is in K: folder. W rite the following command.   3- Copy the following command and run. K:\AosService\PackagesLocalDirectory\bin\xppbp.exe -metadata=K:\AosService\PackagesLocalDirectory -all -model=yourModel -xmlLog=K:\BPCheckLogcd.xml -module=yourModel -car=K:\CARReport 4- After successful completion, the CAR report will be saved to the given path
Read more