Create a generic alert message on the user table

SMuir · ‎01-30-2017

Can someone help me with this query please.

We want to create a generic alert message that can be changed.

For example.

Create a tick box called Alert message

Create a text field to show when the alert message has been ticked on a certain user.

Enter the message for example. Blackberry pilot

When a Service Desk Analyst logs a call and selects the user. It will display a message Blackberry Pilot.

If the same tick box and a different message is applied on another user in the user table. Say the message is Laptop pilot it will show that message.

Does anyone know if this will work or done something similar? for example if someone is part of two pilots how can the message be applied?

Kind Regards

Sarah

Chuck Tomasi · ‎02-24-2017

Hi Sarah,

I'll assume you have a field on your table called u_active which is a true/false field. You can add that to your script include query (before the msg.query() statement) something like this:

msg.addQuery('u_active', true);

If my assumptions are incorrect, adapt the statement or let me know the field name, type, value, etc. and I can advise.

Thanks.

View solution in original post

SMuir · ‎03-07-2017

Thanks Chuck

It works fine for our London users but some of our other offices like the US and Canada are saying it is taking 8-10 seconds to pop up which is strange. Its' not doing it for me. Take a mere few seconds. So I as asked of the possibility if the script was causing performance. I don't think it is but wanted to cover all angles before replying.

I will log a call with support as you suggest.