Query Transactions table for incident through ROQL
Summary
I have a report created through analytics for incident Transactions and need the same result set but query through ROQLContent
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
1