Extract URI from transactionError

When I perform:

SELECT * from TransactionError since 1 minute ago

{
“results”: [
{
“events”: [
{
“aggregateFacet”: “…”,
“appId”: 74680871,
“appName”: “…”,

“requestUrl”: “/wallet/merchant/v2/quote”,

},

However, when I perform:

SELECT * from TransactionError WHERE requestUrl like ‘quote’ since 1 minute ago

I don’t get any results.

I assume it is some sort of a syntax issue, but I can’t figure out what it is.

Thanks!

Hi, @IT1169: LIKE requires a wildcard character (%). Try this:

SELECT * FROM TransactionError WHERE requestUrl LIKE '%/quote'
1 Like