By using this website, you agree to our Terms of Use (click here)
I'm trying to replicate the below left join in a GI by adding the additional filter at the end of the join. Is there any way to achieve this in a GI? I was trying to add a field outright in the relation and was hoping I could just add a value in the child field section but it complains with any variation I try. I tried another way doing it in the conditions but that didn't work out. Thanks in advance for any help on this.
LEFT JOIN FSGeoZone ON FSGeoZonePostalCode.GeoZoneID=FSGeoZone.GeoZoneID AND FSGeoZone.AreaType = 200
I'm assuming you tried "=200" for the Child Field?
I actually ended up just doing an OData connection to dump the data into SQL to get what I needed.
What about a Parameter that is hardcoded to true, then put all your logic on the left-hand side and have it evaluate to true/false, then select the Parameter on the right-hand side?
Thanks Tim but I've moved on from this and found another solution. If I ever come across this situation again I'll keep this post in mind and give it a shot. Maybe one day Acumatica will adjust this section to allow us to do this in the future. I can't imagine I'm the only person to ever come across this.