Finance | Project Operations, Human Resources, ...

How to query amount "greater than" in contract class

(0) Share

Report

Posted on by Voltes

596

Hello all,

I have some difficulties during queryBuilder in my contract class. Here are my steps :

1. Create the query using QueryBuilder

qbds = query.addDataSource(tableNum(CaseDetailBase));

qbds1 = qbds.addDataSource(tableNum(CaseCategoryHierarchyDetail));

qbds1.addLink(fieldNum(CaseDetailBase,CategoryRecId ), fieldNum(CaseCategoryHierarchyDetail, RecId));

qbds1.joinMode(JoinMode::InnerJoin);

2. Adding some range

qbr = qbds1.addRange(fieldNum(CaseCategoryHierarchyDetail, CaseCategory));

qbr.value(parmCaseCategory); // parmCaseCategory getting from dialog

qbr2 = qbds.addRange(fieldNum(CaseDetailBase, MYTransactionAmt)); // custom field

qbr2.value(strFmt(">= %1", queryValue(parmPaymentAmount))); // parmPaymentAmount getting from Dialog

The first range was ok, but the 2nd range cannot be added to the range. Something wrong with the code ?

Please help

Thanks,

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi Voltes,

Yes, your code has wrong, In this code, you should use single quotes '' not "".

qbr2.value(strFmt(">= %1", queryValue(parmPaymentAmount)));

Please read this:http://www.axaptapedia.com/Expressions_in_query_ranges

The entire expression must be enclosed within single-quotes, not double-quotes.

Was this reply helpful? Yes No
Voltes 596 on at

Like (0)

Report
Copy link

Link copied!

Hi Blue,

But my query does not involved dates. it's amount :)

However I found in your link there is something wrong in my code, inside the Strfmt it should stated again the field name, and I changed to single quote like u suggested.

In debug, the QBR2 populated now, but somehow it does not recognize the " >= ", it is stated to be "MyTransactionAmt = 0" while even the parmPaymentAmount is grab correctly in this class meaning I have value, but in the query range it shows 0, with the wrong "equal" sign.

Anything's wrong ?

Thanks

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,097 on at

Like (0)

Report
Copy link

Link copied!

Hi Voltes,

Instead of using strfmt, I suggest using standard method SysQuery::Range

qbr2.value(SysQuery::Range(0, parmPaymentAmount));

of you can continue using strfmt, but you need to use 2 dots:

qbr2.value(strFmt("..%1", queryValue(parmPaymentAmount)));

Was this reply helpful? Yes No
Voltes 596 on at

Like (0)

Report
Copy link

Link copied!

Hi,

any reason why I cannot use StrFmt ?

because many blogs using that, just curios.

Thanks,

Was this reply helpful? Yes No
Sergei Minozhenko 23,097 on at

Like (1)

Report
Copy link

Link copied!

Hi Voltes,

No reasons, you can use it, but you need to use correct syntax for greater or equal (FromValue..Tovalue)

Range function already makes all needed transformations to get a correct string value for ranges and in case if something will be changed in filtering syntax you don't need to care about your customizations.

Was this reply helpful? Yes No
Voltes 596 on at

Like (0)

Report
Copy link

Link copied!

Btw, I found the problem. It turns out with Strfmt, we need to put bracket.

So it;s like : qbr2.value(strFmt("(TransactionAmt >= %1)", queryValue(parmPaymentAmount)));

But noted what u suggested, Sergei.

Thanks

Was this reply helpful? Yes No