Update Sub-form (Sub-Page) from Main Page to apply Filters.

Problem Statement:
I have a requirement where I want to update the Subform(Part page) from the Main page, this Subpage(Subform) is linked to the Main page by SubpageLink Property. The Subpage is a List page and I want to filter this list by a field from Main Page.

Pre-requisites:
  • VS Code
  • AL Language Extension
  • Microsoft Dynamics NAV /  Business Central
Solution: To solve the above Problem statement we have to make use of the Currpage.Update() function which shall update the Subpage.

 As you can see in the below window a function is created Vendorfilter() on Subpage with the "vendor" parameter, in this function filter is added for the vendor on the part page and then CurrPage.Update() is used. This function will update the Subpage with the vendor.

 

 Now, call this function on "OnValidate" trigger of the Main page field, here we have "Vendor" field on Main Page.

   

The calling of Function is as follows: CurrPage.<SubpageName>.Page.<FunctionName>(Rec.<FieldName>);

 In this example we have CurrPage.POLines.page.Vendorfilter(Rec.Vendor);

 Conclusion: Thus we can achieve updating a Subform from the Main Page.

 Hope this helps!

Comments

Post a Comment

Popular posts from this blog

Import a .CSV file for Bank Reconciliation in Business Central

Image
Introduction: This blog will guide you in importing a .CSV file for Bank Reconciliation. Pre-requisites: Dynamics 365 Business Central Steps: Step 1:  Search for Data Exchange Definition in  Tell me/Search Icon and open it, Create a new Data Exchange Definition and enter the code and name. Step 2: In the new Data Exchange Definition add the following fields. File Type - Variable Text Type - Bank Statement Import Reading/Writing Xml Port - 1220 Ext Data Handling Codeunit - 1240 You can also add the number of Header lines that are present in .CSV file in the Header Lines field. I have one Header Line so I have put 1. Step 3: In the Line Definitions Tab, enter the Code and Number of Columns that are present in the .CSV file. I have 7 columns so I've put them accordingly. Step 4: In Column Definitions put Name of Columns according to your .CSV file and their Data type as well. Step 5: Now click the Field Mapping Action on Line D...
Read more

How to retrieve a Sub-string from a String

Image
Problem Statement : We have a requirement where the client wants a part of String from Sales Order No. which is Code(Data type) and it is auto-generated from Number Series. The Sales Order No. value is "SO/123/789/456". The required Sub-string was: 123<Space>789. Pre-requisites: VS Code AL Language Extension Microsoft Dynamics NAV /  Business Central Solution: As per the requirement, we need to first retrieve Sub-strings "123" and "789" and this can be achieved using SELECTSTR( ) function. But SELECTSTR() only retrieves a Sub-string from a comma-separated String. And the Sales Order No. string is a slash-separated string. So firstly we need to convert this string to comma-separated string, which is achieved in the below-presented screen. CONVERTSTR(String, From Characters, To Characters)   In the above Screen, "SalesOrder No." is initialized in a text variable "SoNumber" and then is converted to a comma-sep...
Read more