In Generic inquiries the @me option works on parameters as a default on CreatedBy, LastModifiedBy or OwnerID fields. I need a list of outstanding Appointments where @me is an Employee on the Staff Tab of an Appointment. How to find your own Appointments? The Appointment Summary does this but does not filter out applointments where staff have completed their service logs and there are multiple staff on an appointment. I plan to use a GI as the Appointment List in the Mobile App which does this. My problem is that @me does not work on EmployeeID or Employee.UserID directly. An Employee has a Contact record and Contacts have OwnerIDs but there is no way to access this to update the OwnerID such that it can be used on the query. I am looking at creating a new Contact per EMployee and using this in the query where the owner of the contact is the employee. Is this necessary?
Solved
Employee filtering with @me
Best answer by Anacarina Calvo
Hi
You can review the DB Appointment Techs (GI000074) GI that comes with Sales Demo data (I am attaching the GI to the answer). On the GI, they are able to apply the @me filter equal to “Employee Login”
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.