Discussions
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Finding Custom Transactions With ODBC
Trying to use the CData ODBC connector to view a custom transaction we have created. I can see our custom fields and custom records, but don't know where to query the custom transactions. Is it something I have to build from the Transactions table? Where is the link?
All I see where I query that transaction is this:
Enter your SQL query: select * from Transactions where InternalId = 1193561
(u'1193561', u'setupCustom:CustomTransaction', None, None, None, None, None, None, None, datetime.datetime(2017, 5, 19, 14, 12, 16), None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, datetime.datetime(2017, 5, 19, 14, 12, 16), None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, None, 1.0, datetime.datetime(2017, 5, 19, 0, 0), u'AWP-7', None, None)