Meals Plus News You Can Use

Tips and Tricks and Updates to the Meals Plus Suite of products

18 November 2016

Students Without a Picture

As you import your new pictures into Meals Plus, you may be curious as to those students that are missing a picture in the system.

Use the Custom Query in the Utilities menu to create a query that shows you those patrons that do not have an assigned picture;

SELECT        Student.Id, Student.FirstName, Student.LastName, Student.SiteId, Student.StatusCurrent
FROM            Student 
WHERE        StatusCurrent in ('2','3','4') AND Id not in (Select StudentId from StudentPicture)

 

Related

0 ( 0 reviews)

Post a Comment