Microsoft Dynamics AX (Archived)

Re-refresh grid based on new selected value ?

(0) Share

Report

Posted on by Ismail Mohamed

576

Hello Everyone

first pic

i 11748.1.png

Second pic

164062.2.png

public void executeQuery()
{
    str myStrResultGet ;
    QueryBuildRange qbr;

    myStrResultGet=CustGroupId.valueStr();
    qbr = this.query().dataSourceTable(tableNum(SalesTable)).addRange(fieldNum(SalesTable,CustGroup));
    qbr.value(myStrResultGet);

    super();
}

my problem in second pic when i change the customer group selection for the second time the grid save old records and show it with new selection

thank in advance.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (4)

Sort by

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This can be achieved by writing code in the modified method of customer group field like whenever value is selected just pass it as a query range to the formdatasource query and call formdatasource.executequery(at end) to filter the data based on criteria. Can you share your code with us, so that we can check the missing part.

Was this reply helpful? Yes No
Ismail Mohamed 576 on at

Like (0)

Report
Copy link

Link copied!

now you can find the code in the post

thank you

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please try by performing following changes:

Change queryrange either to qbr.value(queryvalue(myStrResultGet)); (or) qbr.value(queryvalue(CustGroupId.selected()));

Was this reply helpful? Yes No
Ismail Mohamed 576 on at

Like (0)

Report
Copy link

Link copied!

worked fine this.Query().datasourceNo(1).clearRanges();

Chaitanya Golla thank you

not worked qbr.value(queryvalue(myStrResultGet)); (or)

not worked qbr.value(queryvalue(CustGroupId.selected()));

Sukrut Parab thank you

this example with combocox and in combox there is method named selection changed

i didn't find it on stringedt

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi Ismail Mohamed,

You are adding new range each time query is executed, instead of doing this you need to create range once on init of the form and then set a value of the range in executeQuery.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

As Ievgen has pointed out, you need to shuffle your code around to do it properly. I would recommend using SysQuery::findOrCreateRange() call to avoid duplicate range creation.

msdn.microsoft.com/.../sysquery.findorcreaterange.aspx

Was this reply helpful? Yes No
Ismail Mohamed 576 on at

Like (0)

Report
Copy link

Link copied!

this.query().dataSourceTable(tableNum(SalesTable)).addRange(fieldNum(SalesTable,CustGroup))

can anyone tell me what is this.query() means ?

is there a default query in each form ?

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Each form has datasources behind, so query is build base on this datasources and their relations.

Was this reply helpful? Yes No
Ismail Mohamed 576 on at

Like (0)

Report
Copy link

Link copied!

Ok my question- is there a built-in query created with the form creation or the query will create when i execute this.query()

Was this reply helpful? Yes No