I'll use a metaphor:
During the creation of a supervisor object, the user can select one or more existing employees (peers) to assign to the supervisor. As a rule on the Supervisor, I want to determine whether any employees have been assigned and if so, send an email notification to each. I can't figure it out any syntax that works.
Not workable but expresses the idea:
IF EXISTS Employee IN Supervisor.Employees THEN
Since the object may not be committed to the database at this point, I am unsure if this is feasible. It's probably really easy like all things in AIM and I'm just over thinking it.
Determining if child records are created
Determining if child records are created
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
MySQL, AWS EC2, S3
PDFtk Toolkit
Re: Determining if child records are created
Sounds like you want to check if the Supervisor instance IS NEW + if Supervisor.Employees IS DEFINED.
If both of these conditions exist, you want to find the Employees in Supervisor.Employees and send email the email.
If both of these conditions exist, you want to find the Employees in Supervisor.Employees and send email the email.
Tom - V8.8 build 3137 - MySql / PostGres
Re: Determining if child records are created
Perhaps try
IF EXISTS Employee WHERE Employee IN Supervisor.Employees THEN
IF EXISTS Employee WHERE Employee IN Supervisor.Employees THEN