Reply To: Gezielte Benachrichtigung für Bereitschaftstechniker

04/06/2015 at 12:02 #2911

Participant

Das ist übrigens die Definition der virtuellen Spalte für den Benutzer-Haken “Currently on call”

select top 1 1 from User_Calendar c where c.user_pk=user_pk and getdate() between c.from_date and c.to_date and c.Virtual_IsOnCall = 1

Funktioniert wunderbar. Jetzt kommt noch ein berechneter Haken für die Falltabelle, der anzeigt, ob der aktuelle Fall bereitschaftsrelevant ist. Die Anlage der Benutzerkalender funktioniert schon prima.

POB Admin Training in a Virtual Setting (North America)19/10/2020 - 15:01
The Wendia North American team is excited to announce a new virtual POB Administrator training taking place in November. The training includes remote instruction sessions and daily assigned labs with a mentor available if needed. The first week of training will be the week of November 16th, and the second week will be the week […]
Learn how to Build and Utilize Explorers in POB (Webinar)05/10/2020 - 16:55
Join our October webinar by Wendia North America senior POB consultant Payton Regan if you would like to learn more about building and utilizing Explorers in POB. Participating in the one-hour webinar that will be held on Tuesday, October 20th, at 16:30 CET / 8:30 am MST, is as always free of charge. See more […]
September Webinar on Knowledge Management01/09/2020 - 13:28
Join Wendia’s next webinar to learn more about using, maintaining and setting up knowledge. On September 15th, Stephen Goertzen, Wendia North America Senior Consulting Engineer, will host a one-hour webinar on Knowledge Management, where he will approach Knowledge from three different perspectives: Knowledge management for end-users/customers Knowledge management for users Knowledge management in general – setup […]

Reply To: Gezielte Benachrichtigung für Bereitschaftstechniker

Login

Menu

Pages