mortenbra / apex-plugins Goto Github PK

If the plugin is used on a page, it doesn't show the apex page in browser. It shows a JSON text instead.
Looks like a simple issue, but I couldn't find it out :(

Hi
How can i set the aggregator to "integer sum" as the default action? And set a column to summerize?
Without need the user drag and drop at screen

Thanks
Lior

After migrating our apex, the plugin was broken
upon inspection, I found the l_ajax_id contains invalid characters

We need to change

  l_ajax_id                      varchar(2000) :=  replace(apex_plugin.get_ajax_identifier, '-', '_');
  l_data_name                    varchar2(2000) := 'pivot_data_' || l_ajax_id; 

to

  l_ajax_id                      varchar(2000) := replace(replace(apex_plugin.get_ajax_identifier, '-', '_'),'~~/','_');
  l_data_name                    varchar2(2000) := 'pivot_data_' || l_ajax_id; 

After making the above change it started working properly

Regards
Darshan

This code is giving error when trying to create a plug in in the application.

i tried to install plugin and get error Invalid Plug-in File.

I was using this plugin for many years since version 5, and it was working until version 20, but now i migrate to last version 21.1 and the plugin just don't work, it shows blank region.

Pls Help

Hi Morten,

i am using your plugin "Execute PL/SQL code and return content" in apex 20.2 application and i manage to find possible bug.

On one page i have 3 dynamic acntions (after page load). Each executes one "PL/SQL Code and return content" with different page element with different data using different page item. Every plugin action has 5s interval for refresh data. Mode is "Replace". The problem is in property "Javascript callback". Every action has setup different Javascript Callback (For Example: loadedA(); loadedB(); and loadedC();)

In page settings in "Function and Global Variable Declaration" definition i have declared all of these 3 JS functions and in everyone of them there is simple console.log("Callback A") with different last letter(A,B or C). The problem is, that somehow plugin register only first JS Function for callback even for the other two javascript callbacks. Result in console, is that there is 3times same text (Callback A).

Thanks for looking in to that and have a nice day ,

Lukas Fiala from Czechia

Hi Morten.
Recently I created a page with your plugin and use on it the interval setting with value of 5 seconds for refreshing content with data. It works great but than I realize that that´s a lot of requests per minute so I created another version with using DBMS Alert. I have a working solution and now I can only refresh my data using your plugin when something happens in DB and alert is signalled. Therefore, I was wondering that it would be awesome if your plugin could do it same way and if I can only setup alert name in settings for example below interval parameter as an optional setting. What are your thoughts about this idea?