170
I'm trying to do a test, but I'm not getting the expected result... I need to get all vendors that had an update in VendTable, DirPartyTable, LogisticsPostalAddress or LogisticsElectronicAddress. I have created the query below, but is just getting the modifiedDateTime from VendTable. What I'm doing wrong?
*This post is locked for comments
Hi,
Why do you use ||? You should use &&.
Also, there are 2 ways of using them.
1) You have to write your single condition after selecting the table, for example after join table1 or something, in where clause.
2) You set all conditions after writing all joins.
Another
BR
I did using 5 independent queries and exporting the result (Company and Vendor) to a staging... after I will export the vendors using the vendor list of the staging table. Is not beautiful, but is working... Thanks everyone!
Do not worked. Is showing all vendors if I add the where modifiedDateTime in final of query...
if the above query results right in SQl. The below code should work:
Utcdatetiem dt = UtcDatetime::newDatetime(datetime);
while select vendtable
join dirPartyTable
where dirPartyTable.Recid == vendTable.Party
outer join LGT
where LGT.REcid == dirPartyTable.PrimaryContactEmail
outer join LogLOcation
where LogLocation.RecId == dirPartyTable.PrimaryAddressLocation
outer join LogPostalAdd
where LogPostalAdd.Location == LogLocation.RecId
and (vendor.ModifiedDateTime > dt ||
dirPartyTable.ModifiedDateTime > dt ||
LGT.ModifiedDateTime > dt ||
LogLOcation.ModifiedDateTime > dt ||
LogPostalAdd.ModifiedDateTime > dt )
Hi Pradeep,
Do you have any idea how can I solve it?
Hi Rafael,
In OR cases, when the first condition is true. System will not next for the other conditions. Since system is able to fetch record vendor.modifiedDateTime>dt . It will stop will not check for other conditions.
Regards,
Pradeep
Basically, I want the query below in X++.
Hi Brandon,
I changed the myDateTime as a utcDateTime variable, but the result is the same.
I test just with VendTable and DirPartyTable, but I just get the modifiedDateTime from the VendTable... the AX is ignoring the DirPartyTable... I don't know why...
I'm using outer join because some vendor couldn't have email, phone or address, but I need to show these vendors too.
Hi
Why don't you declare myDateTime as a utcDateTime variable? Why are you using a string and then converting it's format? I would change that for starters.
Rather take dt and assign a data value to it directly. Also, when you debug, have you checked that dt has the correct value - the value that you're expecting?
Maybe get rid of all the joins, and just run the job on the vendor table to make sure that your date comparisons are in the right format etc. Then add the joins 1 by 1.
Out of curiosity, why are you using outer joins?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (