Hi Frends,
As we know in TN from Transaction Analysis we do get al the details of transactions which have been taken place. I want to get the same results in the db as well. Could anyone specify what all tables I need to check to get all the transactions which takes place on a given day.
Why do you want to query backend tables when TA could provide all the data to you out of box.
Anyways here is the SQL (table info below) from the transaction analysis for Date Received (as Today selection)
SELECT
d.DocID,
d.DocTimestamp,
t.TypeName,
s.CorporationName AS SenderCorp,
s.OrgUnitName AS SenderUnit,
r.CorporationName AS ReceiverCorp,
r.OrgUnitName AS ReceiverUnit,
d.RoutingStatus,
d.UserStatus,
d.NativeID,
d.GroupID,
d.ConversationID
FROM
BizDocTypeDef t,
Partner s,
Partner r,
BizDoc d
WHERE
d.DocTypeID = t.TypeID AND
d.SenderID = s.PartnerID AND
d.ReceiverID = r.PartnerID
AND d.DocTimestamp > {ts ‘2013-08-29 00:00:00.0’} AND
d.DocTimestamp < {ts ‘2013-08-30 00:00:00.0’}
ORDER BY d.DocTimestamp DESC
HTH,
RMG
Hi RMG,
Thanks for swift response. Could you please tell me where did you get those details ?
TN & MWS is heavly depend on DB to get data and show you in customized way
You can see any results in MWS as you required. Once after creating your basic/Advanced search in MWS transaction tab, just cick on show sql button. you can see query that got created as per your requirements
From the TN Console–>Transactions–>View SQL tab
HTH,
RMG
Thanks RMG for your help !!!
your welcome: