To open filtered form on button clicked

(1) Share

Report

Posted on by Dineshkarlekar

1,836

Hi everyone I have created multiselect lookup on formstringcontrol .lookup is working fine.

I have written the code on the click method which takes the value from lookup method and pass it to another form to open it with filtered values

I created the extension of init method but when i click on the button the value passes to the form but is is not opening getting this error

in init method. my code for lookup and click and init method is below please guide me on this.

 public void lookup()
        {
            super();
            
            OMUserRoleOrganization omOrg;
            boolean hasOrgAccess = false;

            // Check if the current user has any organization access records
            select firstonly RecId from omOrg
        where omOrg.User == curUserId();

            hasOrgAccess = (omOrg.RecId != 0);

            Query query = new Query();
            QueryBuildDataSource qbdsCompany = query.addDataSource(tablenum(CompanyInfo));
    
            qbdsCompany.addSelectionField(fieldNum(CompanyInfo, DataArea));
            qbdsCompany.addSelectionField(fieldNum(CompanyInfo, Name));

            if (hasOrgAccess)
            {
                QueryBuildDataSource qbdsOrg = qbdsCompany.addDataSource(tablenum(OMUserRoleOrganization));
                qbdsOrg.relations(false);
                qbdsOrg.joinMode(JoinMode::InnerJoin);
                qbdsOrg.addLink(
            fieldnum(OMUserRoleOrganization, omInternalOrganization),
            fieldnum(CompanyInfo, RecId));
        
                qbdsOrg.addRange(fieldnum(OMUserRoleOrganization, User)).value(queryValue(curUserId()));
            }

            msLookupCtrl = SysLookupMultiSelectCtrl::constructWithQuery(this.formRun(), this, query);
            msLookupCtrl.set(msLookupCtrl.getSelectedFieldValues());

        }

    }

    [Control("Button")]
    class OKButton
    {
        /// <summary>
        ///
        /// </summary>
        public void clicked()
        {

            container selectedContainer = msLookupCtrl.getSelectedFieldValues(); // container of strings

            // Step 2: Convert container to List<string>
            selectedCompanies = new List(Types::String);

            for (int i = 1; i <= conLen(selectedContainer); i++)
            {
                selectedCompanies.addEnd(conPeek(selectedContainer, i));
            }

            if (!selectedCompanies || selectedCompanies.empty())
            {
                info("Please select at least one company using the lookup.");
                return;
            }

            ListEnumerator enumerator = selectedCompanies.getEnumerator();
            str selectedDataAreas = "";
            boolean isFirst       = true;

            while (enumerator.moveNext())
            {
                str currentDataArea = strLTrim(strRTrim(enumerator.current()));
                if (!isFirst)
                {
                    selectedDataAreas += ", ";
                }
                selectedDataAreas += currentDataArea;
                isFirst = false;
            }

            Args args = new Args();
            args.name(formStr(EmployeeInfoActiveWithDetailsConsolidated));
            args.parm(selectedDataAreas); // e.g., "USMF, USRT"

            new MenuFunction(menuitemDisplayStr(EmployeeInfoActiveWithDetailsConsolidated), MenuItemType::Display).run(args);

            super();
        }

    }

/// <summary>
/// Extension for ISPEmployeeInfoActiveWithDetailsConsolidated form
/// Applies DataAreaId filtering based on passed Args.parm() string
/// </summary>
[ExtensionOf(formStr(ISPEmployeeInfoActiveWithDetailsConsolidated))]
final class ARISPEmployeeInfoActiveWithDetailsConsolidated_Extension
{
    public void init()
    {
        // Call the original form's init logic
       

        if (this.args() && this.args().parm())
        {
            str selectedDataAreas = this.args().parm(); // e.g. "USMF, USRT"
            container dataAreaContainer = str2con(selectedDataAreas, ",");

            FormDataSource employeeDS = this.dataSource(formDataSourceStr(ISPEmployeeInfoActiveWithDetailsConsolidated, ISPEmployeeInformations));
            QueryBuildDataSource qbds = employeeDS.query().dataSourceTable(tablenum(ISPEmployeeInformations));

            if (qbds)
            {
                qbds.clearRanges(); // Optional: clear if you want to fully control

                str orExpression;
                for (int i = 1; i <= conLen(dataAreaContainer); i++)
                {
                    str dataArea = strLTrim(strRTrim(conPeek(dataAreaContainer, i)));
                    if (dataArea)
                    {
                        if (orExpression)
                        {
                            orExpression += " || ";
                        }
                        orExpression += strFmt('(%1)', queryValue(dataArea));
                    }
                }

                if (orExpression)
                {
                    qbds.addRange(fieldNum(ISPEmployeeInformations, DataAreaId)).value(orExpression);
                }
            }
        }

        next init();
    }

}

Categories:

Dynamics 365 Project Operations

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Martin Dráb 239,040 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
This happens when you're trying to call a method an a null reference, therefore your next step have been using the debugger to find where the null reference comes from. I believe you'll find that your employeeDS contains null, therefore all code using it will fail.

The main problem is that you run your code in init() above next init(), i.e. before the form (including its data sources) is initialized.

By the way, your code for find the data source and adding ranges with OR operator is way too complicated. The simplest way would be doing simply this:

public void init() { next init(); str selectedDataAreas = this.args().parm(); // e.g. "USMF, USRT" QueryBuildDataSource emplInfoQbds = ISPEmployeeInformations_ds.queryBuildDataSource(); emplInfoQbds.addRange(fieldNum(ISPEmployeeInformations, DataAreaId)).value(selectedDataAreas); }

A slightly more complex way could look like this:

public void init() { next init(); str selectedDataAreas = this.args().parm(); // e.g. "USMF, USRT" container dataAreaContainer = str2con(selectedDataAreas, ','); QueryBuildDataSource emplInfoQbds = ISPEmployeeInformations_ds.queryBuildDataSource(); for (int i = 1; i <= conLen(dataAreaContainer); i++) { str dataArea = strLTrim(strRTrim(conPeek(dataAreaContainer, i))); emplInfoQbds.addRange(fieldNum(ISPEmployeeInformations, DataAreaId)).value(queryValue(dataArea)); } }

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report
Copy link

Link copied!
hi Martin ,

Thanks for reply,

form is opening but getting this error.

Filtering at the data source level is not allowed for a cross-company query.

Can you suggest any other way to resolve this.

i have debugges the code and i am getting company in or if i do multiselect .

{SELECT FIRSTFAST FORUPDATE * FROM ISPEmployeeInformations(ISPEmployeeInformations)

WHERE ((dataAreaId = N'HAL' OR dataAreaId = N'QTR')) it should be && in between .

is my click code wrong or i have to change something in init method.

Thanks,

Regards,

Dinesh

[ExtensionOf(formStr(ISPEmployeeInfoActiveWithDetailsConsolidated))] final class ARISPEmployeeInfoActiveWithDetailsConsolidated_Extension { public void init() { // Call the original form's init logic next init(); str selectedDataAreas = this.args().parm(); // e.g. "USMF, USRT" FormDataSource emplInfoDS = this.dataSource(formDataSourceStr(ISPEmployeeInfoActiveWithDetailsConsolidated, ISPEmployeeInformations)); QueryBuildDataSource emplInfoQbds = ISPEmployeeInformations_ds.queryBuildDataSource(); emplInfoQbds.addRange(fieldNum(ISPEmployeeInformations, DataAreaId)).value(selectedDataAreas); emplInfoDS.query().allowCrossCompany(true); } }

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

It seems that the question of this thread has been answered. Now you a have completely different problem about a cross-company query.

Please create a new thread for your new question and explain your problem in detail there.

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report
Copy link

Link copied!

hi @Martin Dráb

can you please help me on this , i am very stuck with passing range .

https://community.dynamics.com/forums/thread/details/?threadid=fa47aeb0-4053-f011-877b-00224833c1bb

Was this reply helpful? Yes No