438
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.
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.
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.
Share
Report
All responses (
Answers (
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));
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:
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.
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
