Anyone in this group have any experience with select queries against the RequestCenter DB? I know that this is not generally supported, but we ocassionally have use cases where we need to retrieve transaction data in a finer grained format in real time.
We have numerous SQL routines in our library (simple selects all -- of course), but there is a specific case that I haven't been able to solve yet. If there are any tech resources out there with good knowledge of the schema I'd be very interested to exchange ideas.
select r.RequisitionId, s.Name as "Service Name", r.createdOn as "Created Date", case when r.Statusid = 0 then 'Preparation' when r.Statusid = 1 then 'Ongoing' when r.Statusid = 2 then 'Closed' when r.Statusid = 3 then 'Cancelled' when r.Statusid = 4 then 'Rejected' when r.Statusid = 5 then 'Delivery Cancelled' else 'Unknown' end As Status, rb.FirstName || ' ' || rb.Last
Thanks so much for your help on this! This is where I got to, but it looks like your queries will do the trick. Thanks again.
select TxRequisition.RequisitionID, DefService.Name, TxRequisition.StartedDate as SubmittedDate, TxRequisitionEntry.StartedDate as ApprovedDate, TxRequisitionEntry.DueDate, TxRequisition.ClosedDate, DATEDIFF( day, TxRequisitionEntry.StartedDate, TxRequisition.ClosedDate ) as DeliveryTimeDays, TxRequisition.ActualDuration/10 as TotalTime, /* b