SQL raw view does not expand variables
Hello,
If i have a property expansion in a soap or rest call, the raw tab will show the evaluated value. However this does not happen on the jdbc test steps.
SELECT top 100 clientdocumentid, [TransactionXML]
,[CreationDate]
,[TransactionStatusId]
,stl.[WebMethodId], wm.methodname,
CONVERT(float,
DATEDIFF
(
ms,
TransactionXml.value('(//TimeStamp)[1]', 'DATETIME'),
TransactionXml.value('(//EndTimestamp)[1]', 'DATETIME')
)) AS [ProcessingTime]
FROM [CpsWebP2Log].[dbo].[core_ServiceTransactionLog] stl(nolock)
inner join dbo.lu_WebMethod as wm (nolock) on stl.webmethodid = wm.webmethodid
where clientdocumentid like '%${DataSource-transactions#gwy_transactionid}%'
and transactionstatusid = 1 and stl.webmethodid is not null-- and [ProcessingTime] is not null
order by creationdate desc
If i have a property expansion in a soap or rest call, the raw tab will show the evaluated value. However this does not happen on the jdbc test steps.
SELECT top 100 clientdocumentid, [TransactionXML]
,[CreationDate]
,[TransactionStatusId]
,stl.[WebMethodId], wm.methodname,
CONVERT(float,
DATEDIFF
(
ms,
TransactionXml.value('(//TimeStamp)[1]', 'DATETIME'),
TransactionXml.value('(//EndTimestamp)[1]', 'DATETIME')
)) AS [ProcessingTime]
FROM [CpsWebP2Log].[dbo].[core_ServiceTransactionLog] stl(nolock)
inner join dbo.lu_WebMethod as wm (nolock) on stl.webmethodid = wm.webmethodid
where clientdocumentid like '%${DataSource-transactions#gwy_transactionid}%'
and transactionstatusid = 1 and stl.webmethodid is not null-- and [ProcessingTime] is not null
order by creationdate desc
