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
26
Views
3
Comments
edited Jun 8, 2022 12:10PM in General Technical Discussions 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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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