Wednesday, October 15, 2025

Open form through code y passing filtered query using X++

/// <summary>
/// Clicked
/// </summary>
public void clicked()
{
    next clicked();

    MedVisit          visit;
    MenuFunction      menuFunction;

    visit = this.formRun().dataSource(formDataSourceStr(MedVisit, MedVisit)).cursor();
    
    FormRun formRun;
    Args args = new Args();

    // Set the query to the form
    args.name(formStr(CASEvents));
    //  args.caller(this.formRun());

    // Open the form with the specified query
    formRun = classFactory.formRunClass(args);
    formRun.init();

    FormDataSource formDataSource = formRun.datasource();
    formDataSource.query().dataSourceNo(1).addRange(fieldNum(CASEventsTable, EventID)).value(visit.CIAEventID);

    formDataSource.executeQuery();
    formDataSource.getFirst();
    formDataSource=formDataSource.getFirst().dataSource();

    args.record(formDataSource.getFirst());

    formRun.run();
    formRun.wait();

}

No comments:

Post a Comment

Table browser URL in D365FO

Critical Thinking icon icon by Icons8