Query range expressions in AX

(0) Share

Report

Posted on by D365 beginner

572

Hi Experts,

Can anyone help me to spot the mistake in the below query range expression. I need to filter the records with transtype == payment & Last settlevoucher is empty.

public void init()
{
QueryBuildDataSource qbds;
QueryBuildRange qbr;

super();

qbds = this.query().dataSourceTable(tableNum(VendTrans));

qbr = qbds.addRange(fieldNum(VendTrans,LastSettleVoucher));
qbr = qbds.addRange(fieldNum(VendTrans,TransType));

qbr.value(strFmt('((LastSettleVoucher == "%1") && (TransType == %2))',
queryValue(""),
queryValue(any2int(LedgerTransType::Payment))));

qbr.status(RangeStatus::Hidden);
}

All responses (2)

Answers (1)

Rohit P Modani 15 on at

Like (0)

Report
RE: Query range expressions in AX

Hi,

You can try the solution mentioned by Ergun or try the below snippet.

Just remove the "" from %1.

qbr = qbds.addRange(fieldNum(VendTrans,LastSettleVoucher)); qbr = qbds.addRange(fieldNum(VendTrans,TransType)); qbr.value(strFmt('((LastSettleVoucher == %1) && (TransType == %2))', queryValue(""), queryValue(any2int(LedgerTransType::Payment))));
Verified answer

ergun sahin 8,812 Super User 2024 Season 1 on at

Like (1)

Report
RE: Query range expressions in AX

You don't need to get value with %1 for empty string. As a matter of fact, there is no need for you to use Expressions. If you give range values to the fields like below, such errors will not occur.

Expressions are mostly used to write "or" clauses between multiple fields and create more complex structures.

QueryBuildDataSource qbds; QueryBuildRange qbrSettle,qbrTransType; super(); qbds = this.query().dataSourceTable(tableNum(VendTrans)); qbrSettle = qbds.addRange(fieldNum(VendTrans,LastSettleVoucher)); qbrSettle.value(SysQuery::valueEmptyString()); qbrTransType = qbds.addRange(fieldNum(VendTrans,TransType)); qbrTransType.value(sysquery::value(LedgerTransType::Payment));