AOT Query range on one column with OR condition of another column.

(0) Share

Report

Posted on by Vijay Yelmame VY

489

Hi All,
Is there any possibilities to add AOT query range with OR condition with 2 different fields on one field ?

Like Below:

( salesTable.DocumentStatus = None || (salesTable.DocumentStatus != None && salesTable.TestConfirmationStatus = ToBeConfirmed ))

Description: I am developing a workspace form and there i want to show the count of sales order with above conditions.

I have the same question (0)

All responses (4)

Answers (1)

Sort by

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Vijay Yelmame,

I don't think you can add range with multiple fields in one range.

It will be better if you can add above range in the workspace form through code.

Thanks,

Girish S.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,636 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
You should be able to use something like this:

((DocumentStatus = DocumentStatus::None) || (TestConfirmationStatus = YourEnum::ToBeConfirmed))

You can find quite a few examples in existing queries, such as PurchRFQAllReplySummary_PSN:

Was this reply helpful? Yes No
Vijay Yelmame VY 489 on at

Like (0)

Report
Copy link

Link copied!
Thank Martin for your help. I am now able to filter on the query. by adding range like below.

(DOCUMENTSTATUS == 0),(DOCUMENTSTATUS != 0 && TESTCONFIRMATIONSTATUS == 1)

I am trying to add similar range from X query on form DataSource but not sure why it is not working. Even in the info as well i am getting below query but my form DataSource is not filtering the record according to this query.

SELECT FIRSTFAST FORUPDATE * FROM NCABAllSOLinesView(TESTAllSOLinesView) WHERE (((TESTAllSOLinesView.DocumentStatus == "0") || ((TESTAllSOLinesView.NCABConfirmationStatus == "1") && (TESTAllSOLinesView.DocumentStatus != "0"))))

Below code is in the data source execute query.
this.query().dataSourceTable(tableNum(TESTAllSOLinesView)).addRange(fieldNum(TESTAllSOLinesView,DocumentStatus)).value( strFmt('(%1.%2 == "0") || ((%1.%3 == "1") && (%1.%2 != "0"))',tableStr(TESTAllSOLinesView),fieldStr(TESTAllSOLinesView, DocumentStatus),fieldStr(TESTAllSOLinesView, TESTConfirmationStatus))); Query q2 = new Query(this.query()); info(strfmt("%1",q2));

Was this reply helpful? Yes No
Martin Dráb 239,636 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You're missing out-most parentheses.

Another problem is that data source may have different names than tables. Use name() method of QueryBuildDataSource instead of tableStr().

Hard-coding enum elements numbers is a bad idea, and it may give you completely wrong result if any of the enums if extensible. Use enums instead, such as DocumentStatus::None instead of 0.

Correct me if I'm wrong, but I don't think you need the check for DocumentStatus != DocumentStatus::None.

Was this reply helpful? Yes No