Looking for way via plugin (query expression etc) to query a child record and retrieve all other child records of the same type if any that have the same parent record. From there I need to find the most recent child record to have been modified and
in a certain status.
Basically we have a requirement that if a child record is in a certain state to send a reminder to a user that a new child record should be created if x number of days has passed. Thus i need to make sure I can get the latest one in a specific status.
Robert