queryrun() method in form extension is returning null value

(0) Share

Report

Posted on by dark_knight

942

Hello,

IN extension of the standard form HCMWorkLookup I'm trying to update query like that

if (this.args().parm() == "TORFCTABLE")// && this.args().caller() && this.args().caller().name() == classStr(TOR_FCTableReport_UNI))
{
    QueryRun qr;

    hcmWorkerLookup.parmIncludeOnlyCurrentLegalEntity(true);

    LegalEntityRange.visible(false);

    qr = this.HcmWorker_ds.queryRun();
    qr = HcmWorker_ds.queryRun();
    
    HcmWorker_ds.queryRun().query(hcmWorkerLookup.updateQuery());
}

While executing line12 I get an error

System.NullReferenceException: 'Object reference not set to an instance of an object.'

I checked qr above this line 12 and they return null.

hcmWorkerLookup.updateQuery() return query correctly.

This code actually exists on the original HCmWorkerLookup form

HcmWorker_ds.queryRun().query(hcmWorkerLookup.updateQuery());

and doesn't cause any issues. Maybe I'm missing something?

Thanks.

I have the same question (0)

All responses (8)

Answers (1)

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

From where are you calling your code?

Was this reply helpful? Yes No
dark_knight 942 on at

Like (0)

Report
From form extension

[ExtensionOf(formStr(HcmWorkerLookup))] final class HcmWorkerLookupFormUni_Extension { void init() { QueryBuildDataSource qbds, qbds2; QueryBuildRange qbr; next init(); if (this.args().parm() == "TORFCTABLE")// && this.args().caller() && this.args().caller().name() == classStr(TOR_FCTableReport_UNI)) { QueryRun qr; hcmWorkerLookup.parmIncludeOnlyCurrentLegalEntity(true); LegalEntityRange.visible(false); qr = this.HcmWorker_ds.queryRun(); qr = HcmWorker_ds.queryRun(); //this.HcmWorker_ds.queryRun().query(hcmWorkerLookup.updateQuery()); HcmWorker_ds.queryRun().query(hcmWorkerLookup.updateQuery()); //this.HcmWorker_ds.executeQuery(); } }

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

Trying to run the query during in init() is both unnessary and wrong. Forget both queryRun() and executeQuery() - just modify the query returned by HcmWorker_ds.query() and let the system run executeQuery() method automatically at the right time.

Was this reply helpful? Yes No
dark_knight 942 on at

Like (0)

Report
I copied this code from standard HCmWorkerLookup form. It's selectionchange() method

[Control("ComboBox")] class LegalEntityRange { public int selectionChange() { int ret; ret = super(); hcmWorkerLookup.parmIncludeOnlyCurrentLegalEntity(this.selection() == HcmLegalEntityRange::CurrentLegalEntity); HcmWorker_DS.queryRun().query(hcmWorkerLookup.updateQuery()); hcmWorker_ds.executeQuery(); return ret; } }

Here they change the query itself and it works.

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

Like (0)

Report

Yes, but that's a different thing. You're calling your code when the form is being initialized and no QueryRun object has been created yet.

The standard code runs when user changes a value of a control, which can only happen after the form was fully initialized (and it was actually executed).

Was this reply helpful? Yes No
dark_knight 942 on at

Like (0)

Report

But I call it after next init() which in turn calls init() methods of other datasources. Doesn't it mean that the form is already initialized?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

No, it doesn't mean that the form was already executed QueryRun was objects created. Your current problem is a proof.

And there is no point in explicitly calling executeQuery(), because it's called automatically when opening the form, as I mentioned. Put a breakpoint there and run the form to see it for yourself.

Was this reply helpful? Yes No
dark_knight 942 on at

Like (0)

Report

OK. Thank you. I'll deal with it further by myself:)

Was this reply helpful? Yes No

Join the conversation

Community site session details

queryrun() method in form extension is returning null value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

queryrun() method in form extension is returning null value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates