OAC Embedding – Capturing Filter Values (Trigger Data Action via Code Needed) — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC Embedding – Capturing Filter Values (Trigger Data Action via Code Needed)

Needs Votes
61
Views
6
Comments
Karthick_
Karthick_ Rank 3 - Community Apprentice
edited Sep 11, 2024 9:14AM in Oracle Analytics Cloud and Server Idea Lab

Data Action is the only way to capture the filter values.

Problem with the Data Action is, every time User has to interact with the UI (e.g.: Right click on the Data -> Choose Data Action)

Need is without user interaction; Data action has to be triggered.

I don’t need payload context (place where right click is made)

Need of payload contextv2 , Information about the current page filter values..

It would be better to trigger the Data Action via JavaScript code is helpful.

So that, I can able to store the current filter values and can be used for further analysis.

1 Onload.png
2 Trigger Data Action.png
capturefilter.html
Tagged:
2
Up
2 votes

Needs Votes · Last Updated

Comments

  • Mike Durran-Oracle
    Mike Durran-Oracle Mod

    Hi Karthick, thanks for logging this idea. I know we have spoken about this in the past but could you give some examples of the types of interaction you'd like to trigger the data action please? On page load? On filter change?

    Thanks

    Mike

  • Karthick_
    Karthick_ Rank 3 - Community Apprentice

    Hi Mike

    On Filter Change, I need to capture the filter values along with the parameters (comes along in context payload) for it.

    I should have the ability to receive the event from the OAC to read the JSON payload context and extract the required information like, Parameters, Filter Values, Column names,. ..

    Also, It would be great If I have an "event like triggering mechanism", That I pass to OAC to initiate the process to receive back the JSON payload context, whenever I would like to capture filter,

    Thanks

    Karthick.

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    I'm not sure I understand. You can store the filter value in a parameter by binding a parameter to the filter. This allows you to use that filter value in various ways. When the filter changes, the parameter will always store the current values.

  • Karthick_
    Karthick_ Rank 3 - Community Apprentice
    edited Sep 18, 2024 7:58AM

    Yes. The parameters will store the current applied filters values.

    But I need to store the filter values in my code.

    So I can able to pass the filter values seamlessly to other workbooks as well.

  • Avinash Krishnaram-Oracle
    Avinash Krishnaram-Oracle Mod

    Do you have values in filter that is not stored in the parameter? Otherwise the binding solution should work.

    Thanks

    Avinash

  • Karthick_
    Karthick_ Rank 3 - Community Apprentice

    Hi Avinash

    Though Parameter stores the Filter values, It can only be read by OAC to retain the filter values even navigating to another page.

    But I need the filter values (parameters + filter values) in my code.

    So I can use them for various purposes.

    Also, Through code do we can read the binding solution without user interaction to trigger the data action ?

    Thanks

    Karthick