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

[Josh Stompro]

Hello all, is it currently possible to do a join with the json filter file that the action_trigger_runner.pl uses?  I would like to join the actor.usr table in the checkout.due hook, so I can limit based on the first letter of the patron's last name.  I'm looking to gradually send out bills over the course of a week or two based on users last names.

I think the answer is no, it looks like the filter key is only for the where clause.

I tried adding in a join like this
{
"checkout.due" :
    { "context_org" : "circ_lib",
      "filter"      :
            { "checkin_time"  : null,
              "-or"           :
                    [ { "stop_fines"  : ["MAXFINES"] },
                      { "stop_fines"  : null }
                    ],
              "xact_start" : {"<":"2015-09-01 00:00:00-05"},
              "join" : { "au" :{ "field":"id",
                                 "fkey":"usr",
                                 "filter":{"family_name":
                                  {"~*":"^a"}
                                          }
                               }
                       }
            }
    }
}

But that threw an error, looks like the join needs to be up a level from what I can access.

Would anyone else be interested in allowing joins in the json filter file?  Maybe   OpenILS/Application/Trigger.pm create_batch_events() could grab the join data from the filter hash and place it with the other join to allow this ability?
http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/Application/Trigger.pm;hb=HEAD#l385


Josh




Lake Agassiz Regional Library - Moorhead MN larl.org
Josh Stompro     | Office 218.233.3757 EXT-139
LARL IT Director | Cell 218.790.2110

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20160603/e2a50721/attachment.html>