Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
RunAnalyticsReport and PHP scripts — Cloud Customer Connect
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

RunAnalyticsReport and PHP scripts

Received Response
35
Views
2
Comments
edited Jun 8, 2022 12:01PM in General Technical Discussions 2 comments

Content

We've a need to query the Transactions table. This table is not visible via the API, as a result we're having to call it using a report. So we're using RunAnalyticsReport. BUT, this table does not have a unique key and Oracle wont add one. So I used a PHP script to create an MD5 hash of the entire row:

$field = $rows[0][1]->val.$rows[0][2]->val.$rows[0][3]->val.$rows[0][4]->val; $rows[0][0]->val = md5($field);

etc... this concat's the entire row and then turns it into a hash. It's not perfect but it'll serve our needs. However, when calling the report using RunAnalyticsReport, the PHP doesn't fire. Does anyone know if it's possible to get a php script to fire on a report being called with RunAnalyticsReport? Or am I going to have to pull the entire row down remotely and create the key there?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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