How to use "notexistjoin" in x++ query

(1) Share

Report

Posted on by Axel Cage

309

Hello people,

I'm trying to join 2 table which the idea is to get a set of records in tableA that does not exist in table B.

So I type a query like this :

while select TableA
notexists join TableB 
                where TableA.ReceiptNum == TableB.receiptId
                   && TableA.IsClosed == NoYes::No
                   {
                   
                   }

I wonder whether this is correct because as you can see I have 1 more condition for Table A, but it seems in the while loop still retrieve records in TableA which "IsClosed=Yes"

Thanks,

I have the same question (0)

All responses (3)

Answers (0)

nunomaia 25 Moderator on at

Like (2)

Report
Copy link

Link copied!
Try to filter by on Table A

while select TableA where TableA.IsClosed == NoYes::No notexists join TableB where TableA.ReceiptNum == TableB.receiptId { }

Was this reply helpful? Yes No
Axel Cage 309 on at

Like (1)

Report
Copy link

Link copied!

Thank you, now it's correct. It seems in x++ the condition should be threaten one by one, is it ?

Btw, one more thing and a bit OOT, when in the middle of debugging and I found something not correct, and then I press Stop, it seems it will continue the process first at backend, is it ? because when I see the record already wrong in the loop then stop, because it is actually a process to insert something, the insertion is still happen, although I already stop debug and bring me back to Edit mode in Visual Studio

Thanks again.

Was this reply helpful? Yes No
nunomaia 25 Moderator on at

Like (0)

Report
Copy link

Link copied!

You should add all conditions that you want to filter in join

Was this reply helpful? Yes No