D365 F&O Filter records in a form by code using extensions in d365 F&O x++

  In this case filtering vendor invoice journals by creating an extension class in the form datasource -> init() method

trying to filter vendor invoices with SAR currency code

[ExtensionOf(formDataSourceStr(vendinvoicejournal, VendInvoiceJour))]

final class RKFormDS_VendInvoiceJournal_Extension

{

    public void init()

    {

        next init();

        

        str formName =  this.formRun().name();

        str callerName =  this.formRun().args().callerName();

        if(formName == 'VendInvoiceJournal' && callerName == 'RKVendInvoiceJournal')

        {

                          this.query().dataSourceName(this.name()).addRange(fieldnum(VendInvoiceJour,              Currency)).value(SysQuery::valueLike("SAR "));

            }

          

        }

    }