Problem with save/restore query in a container type table field

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi All,

I’m trying to save/restore query in a container type table field (I learned this way from Mirko Bonello’s blog). I just want to show select button at my form’s grid, select ranges for every record of table. But it shows same ranges at all of the table. This’s my table method code, I call it from my form:

void createAndSaveQueryInTable()
{
QueryRun qRun;
Query q;
QueryBuildDataSource qbds;
QueryBuildRange qRange;
;

if (this.InventTableQuery)
{
qRun = new QueryRun(this.InventTableQuery);
}
else
{
q = new query();
qbds = q.addDataSource(tablenum(InventTable));
qbds = qbds.addDataSource(tablenum(RBOInventTable));
qbds.relations(true);
qbds = qbds.addDataSource(tablenum(PriceDiscTable));
qbds.addLink(fieldnum(RBOInventTable,ItemId),fieldNum(PRiceDiscTable,ItemRelation));
qRange = qbds.addRange(fieldNum(PriceDiscTable,ItemCode));
qRange.value(QueryValue(TableGroupAll::Table));
qRange.status(RangeStatus::Hidden);
qRun = new QueryRun(q);
}
if (qRun.prompt())
this.InventTableQuery = qRun.pack();
}
//referans:dynamicsax-dev.blogspot.com.tr/…/displaying-and-saving-query.html

2

I found the reason:

When query dialog shown, Select query combobox selected as default “query used before”. How can I prevent this? I have to show “used query” (Dialogs would be different in english, because I translated from turkish AX).

3

I found the second answer too:

use sysqueryrun instead of queryrun

and

qrun.promptLoadLastUsedQuery(false);

thank you all,