Abhishek,
The query on the incident form could be along the lines of
SELECT [column name 1], [column name 2], [column name 3] ....[column
name n] FROM HPD_Help_Desk {WHERE CLAUSE}
You would require knowledge of how the AR Tables are structured within
the database. All the column names would be the DB names and not the Label
Names of the field. Below is a sample query in SQL that I wrote. Once you
know the underlying table structure you should be able to construct a lot
of complex queries/reports not possible within the Application UI.
-- List of Open Tasks for Changes in "Scheduled" or "Implementaion In
Progress" status.
SELECT
T.Task_ID,
Task_Status =
CASE
WHEN T.Status = 1000 THEN 'Staged'
WHEN T.Status = 2000 THEN 'Assigned'
WHEN T.Status = 3000 THEN 'Pending'
WHEN T.Status = 4000 THEN 'Work In Progress'
WHEN T.Status = 5000 THEN 'Waiting'
WHEN T.Status = 6000 THEN 'Closed'
WHEN T.Status = 7000 THEN 'Bypassed'
END,
T.Location_Company AS Company,
T.Summary,
(DATEADD(s, T.Scheduled_Start_Date, '1969-12-31 19:00:00')) AS
Task_Scheduled_Start_Date,
(DATEADD(s, T.Scheduled_End_Date, '1969-12-31 19:00:00')) AS
Task_Scheduled_End_Date,
CURRENT_TIMESTAMP AS Todays_Date,
(DATEDIFF(DAY, (DATEADD(s, T.Scheduled_End_Date, '1969-12-31
19:00:00')), CURRENT_TIMESTAMP)) AS Days_Past_The_End_Date,
T.Assignee_Group,
T.Assignee,
C.Infrastructure_Change_ID,
Change_Request_Status =
CASE
WHEN C.Change_Request_Status = 0 THEN 'Draft'
WHEN C.Change_Request_Status = 1 THEN 'Request For
Authorization'
WHEN C.Change_Request_Status = 2 THEN 'Request For Change'
WHEN C.Change_Request_Status = 3 THEN 'Planning In
Progress'
WHEN C.Change_Request_Status = 4 THEN 'Scheduled For
Review'
WHEN C.Change_Request_Status = 5 THEN 'Scheduled For
Approval'
WHEN C.Change_Request_Status = 6 THEN 'Scheduled'
WHEN C.Change_Request_Status = 7 THEN 'Implementation In
Progress'
WHEN C.Change_Request_Status = 8 THEN 'Pending'
WHEN C.Change_Request_Status = 9 THEN 'Rejected'
WHEN C.Change_Request_Status = 10 THEN 'Completed'
WHEN C.Change_Request_Status = 11 THEN 'Closed'
WHEN C.Change_Request_Status = 12 THEN 'Cancelled'
ELSE NULL
END,
(DATEADD(s, C.Scheduled_Start_Date, '1969-12-31 19:00:00')) AS
Change_Scheduled_Start_Date,
(DATEADD(s, C.Scheduled_End_Date, '1969-12-31 19:00:00')) AS
Change_Scheduled_End_Date
FROM TMS_Task T
INNER JOIN CHG_Infrastructure_Change C ON T.RootRequestID =
C.Infrastructure_Change_ID
WHERE (C.Change_Request_Status = 6 OR C.Change_Request_Status = 7) AND
T.Status < 6000 AND T.Support_Company = xxxx
Your DBA should be able to help you with scheduling the report or run
you through the steps of scheduling one.
Thanks
Shiva Velicheti
On Tue, Jun 13, 2017 at 12:09 PM, Abhi$hek <[email protected]> wrote:
> **
> Thanks for your response.
>
> Please could you guide with the steps to design a sample SQL query and how
> to schedule it.
>
> Regards,
> Abhishek
>
> On 13-Jun-2017 9:11 PM, "Sivarama Velicheti" <[email protected]> wrote:
>
>> **
>> Abhishek,
>>
>> The easiest method that I usually follow to go around the entries
>> returned restriction, is that I build SQL queries which retrieve the data
>> directly from AR database. I usually run the queries ad-hoc and provide the
>> reports as needed. For the scheduled reports I usually have the script
>> configured in the SQL server to send out reports at specific times to the
>> intended audience.
>>
>> Thanks
>> Shiva Velicheti
>>
>> On Tue, Jun 13, 2017 at 9:35 AM, Abhi$hek <[email protected]> wrote:
>>
>>> **
>>> We can't update the server settings as it's applied for the server
>>> performance only.
>>>
>>> On 13-Jun-2017 7:51 PM, "Kevin Shaffer" <[email protected]>
>>> wrote:
>>>
>>>> **
>>>> I believe you can change the config.properties to allow more than
>>>> 2000.
>>>>
>>>> Get Outlook for Android <https://aka.ms/ghei36>
>>>>
>>>> ------------------------------
>>>> *From:* Action Request System discussion list(ARSList) <
>>>> [email protected]> on behalf of Abhishek Anand <
>>>> [email protected]>
>>>> *Sent:* Tuesday, June 13, 2017 4:27:17 AM
>>>> *To:* [email protected]
>>>> *Subject:* Can we schedule AR Reports & send it to third party via web
>>>> service?
>>>>
>>>> Hi Experts,
>>>>
>>>> Can we schedule AR Reports & send it to third party via web service?
>>>> As we are having the 2000 rows restrictions at server level so unable
>>>> to achieve it via AR System Report console.
>>>>
>>>> Early response will be highly appreciated.
>>>>
>>>> Regards,
>>>> AA
>>>>
>>>> ____________________________________________________________
>>>> ___________________
>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>>> "Where the Answers Are, and have been for 20 years"
>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>>>
>>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>>>
>>
>>
>>
>> --
>> Thanks
>> Shiva
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
--
Thanks
Shiva
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
