We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query Transactions table for incident through ROQL

Received Response
20
Views
3
Comments
edited Jun 22, 2021 4:28PM in Integrations and APIs 3 comments

Summary

I have a report created through analytics for incident Transactions and need the same result set but query through ROQL

Content

It looks that the transaction table in Analytics/Data Dictionary is differently than the Transaction table that I query through ROQL. 

The transaction table only has three fields, while the transaction table in Analytics/Data Dictionary in the Agent Desktop/B2C has many more fields.  

These are the fields I am using in Analytics:
incidents.i_id, transactions.createdn transactions.acct_id, transactions.acct_id.id, transactions.tbl, transactions.trans_type

I need to get the same data/fields though ROQL

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!