Re: [OPEN-ILS-DEV] Action Trigger - json filter - Joins

2016-10-17 Thread Josh Stompro
-Original Message- From: Open-ils-dev [mailto:open-ils-dev-boun...@list.georgialibraries.org] On Behalf Of Mike Rylander Sent: Saturday, October 15, 2016 1:57 PM To: Evergreen Development Discussion List Subject: Re: [OPEN-ILS-DEV] Action Trigger - json filter - Joins Josh, JOINs in th

Re: [OPEN-ILS-DEV] Action Trigger - json filter - Joins

2016-10-15 Thread Mike Rylander
Josh, JOINs in the FROM clause are explicitly restricted, because they can lead to multiple copies of a target object being retrieved. Instead of adding contortions to the code to avoid that, there are other ways to test "out" from the target. You probably want to use a correlated EXISTS