Atul,
Here is a SQL solution. I am using SQL Server 2000 - just adapt it to
your DBMS.
Create the SQL Function and View listed below. The View is necessary
because Functions can not directly acces non-deterministic values, such
as GETDATE().
Create an active link that calls an active link guide every ## minutes.
Create two active links that will be a part of the active link guide.
The first active link will run a Set Fields SQL with SELECT
dbo.udf_RecentTickets(3600, 'Hardware', 'Laptop', 'Dell Latitude D600')
The return value will be the number of tickets that were created in the
last ## seconds with this CTI.
The second active link will have a Run If qualification of 'zTmp Number
of Tickets' > 10
If true, then display a message.
Comments:
The prompt will occur every time your active link guide is run. This
may become annoying. You might want to add workflow so that prompts
only occur every ## hours. Or, populate a 0 length read-only
display-only character field on the form with your message(s). The user
could then view the messages without having to stop and click OK at the
prompt.
Substitute the SHR_ConsolidatedList form in the function with the
form(s) you use to store the tickets.
CREATE VIEW dbo.udf_GetDate
AS
SELECT GETDATE() GetDate
CREATE FUNCTION dbo.udf_RecentTickets
(
@Seconds INT,
@Category VARCHAR(50),
@Type VARCHAR(50),
@Item VARCHAR(50)
)
RETURNS INT
/*
Returns the number of tickets created within the last ## seconds for a
particular CTI.
*/
AS
BEGIN
RETURN (SELECT COUNT(*)
FROM SHR_ConsolidatedList
WHERE Category = @Category
AND Type = @Type
AND Item = @Item
AND Create_Date > DATEDIFF(s, '01/01/1970', (SELECT
* FROM dbo.udf_GetDate)) - @Seconds)
END
Stephen
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Atul Vohra
Sent: Wednesday, August 16, 2006 8:11 PM
To: [email protected]
Subject: Same Ticket type in past Y minutes
Hi,
What would be a good way of implementing the following in Remedy
(ARS6.3):
Prompt the user if X tickets with the same Category/Type/Item are
created in Y time.
Thanks
Atul Vohra
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
