Is there a way to query a report to get all the animals with past due vaccines? We do use the data management service and animal journals.
We would suggest that you customize the standard Animal Journal report and add a filter for the Animal Journal Due Date field. RescueGroups.org has a calculated date filter which looks like this: rg:today. You can use this to filter for Animals Journal Entries with a Due Date less than today's date. Below is a screenshot to demonstrate what this filter would look like as well as a link to our guide about customizing standard reports.
Customizing standard reports
Powered by a free Atlassian Confluence Community License granted to RescueGroups.org. Evaluate Confluence today.