Query range expressions in AX

(0) Share

Report

Posted on by D365 beginner

634

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);
}

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ergun sahin 8,826 Moderator on at

Like (1)

Report
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));

Was this reply helpful? Yes No
Rohit P Modani 15 on at

Like (0)

Report
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))));

Was this reply helpful? Yes No

Join the conversation

Community site session details

Query range expressions in AX

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

Query range expressions in AX

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