Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Skillbuilders Super LOV - Search Columns don't update with Change of LOV Information

bh56Jun 16 2014 — edited Jun 27 2014

I'm using 2.0.2 of the Super LOV.

Not sure if your plugin was meant to handle List of Values information coming back from a function.

http://apexplained.wordpress.com/2012/04/05/manage-your-lovs-in-plsql/

So I have another Select List that determines for the List of Values I'm using Super LOV for.  It passes a value to determine which LOV query to return. For the most part Super LOV handles it.  But the Selectable Search Columns that get displayed are from the first time the page is rendered.  When I change the driver Select List which then changes the Super LOV value, the List is correct but the Search Columns are from the first time through.

Wondering anyone has any suggestions?

Thanks!

Comments

Tom Petrus

No suggestions except modifying the plugin to suit your need. The plugin as it is is not built to handle changing columns at runtime. The initialization code has several options, which are filled out by the plugin render. One of them is the property "reportHeaders", which obviously contains the headers for the columns. So your column headers will always be like those determined by the plugin during rendering, but do not change after the render. I suppose that if you have a way of determining the column header you may just need to extend the code to allow setting the reportHeaders property. Alternatively, change the plugin ajax calls to include column headers in their return, and change the javascript to handle that return, setting the column headers to those returned. Also unsure as to how the enkitec modal lov works in this regard, maybe that does dynamic or maybe not - might be worth a looksie?

bh56

Thanks for your suggestions, will take a look further into what you are suggesting and update what results.

Dave SkillBuilders

Hi bh56, Thanks for using SkillBuilders Super LOV.  I am interested in how this works out - we can provide some assistance if you'd like.

Also, just FYI, we now have a Tabular Form Super LOV available (also free).  Free Oracle APEX Plug-Ins by SkillBuilders

bh56

Tom,

Thanks for your help and suggestions. 

enkitec modal lov  Looks like it does this on rendering as well.

I'm a bit knew to APEX and Plugins. Is there anyway to get the page or item to re-render with a Dynamic Action?

Wondering if you can point me in the right direction as how the rendering works?


I will start looking further into your suggestions as well.  This is one of the last items on my list to resolve, so I am just getting started with this.


Thanks again for your help.


Brian

bh56

Dave,

I will let you know how this works out for me.  I'm a bit new to APEX and Plugins.  As I asked Tom, can you shed some light for me about how the rendering works and if there is any way to get the plugin to re-render without making plugin changes.  Will reach out once I get a bit further. Just picking this back up.  Thanks for your offer to help.  I'm surprised that not many people have hit this yet.  I know this is a bit more complex, but would think there a situations where there would be this need and dynamicnes.

Brian

Tom Petrus

In theory it's certainly possible to reinitialize a plugin item. After all, it's a jQuery UI widget and thus destroying or initializing is nothing too hard. The struggle would likely be to collect the correct options (parameters) such as the ajax identifier. It could be an option, once again, to change the plugin code so it would so something extra like putting out basic options - though it might be worth it to look into checking out if it might not just be able to pass on column headers as I initially suggested. As you talk of rerendering I read it as fetching the html the plugin would put out during a re-render. I'd say that isn't feasible - in theory, once again, you could fetch the page through ajax again and then lift out code from there but that's hardly worth it, making it very complex.

Dave SkillBuilders

hi Brian, I'm passing this to our tech team.

Be back.

Dave

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 25 2014
Added on Jun 16 2014
7 comments
2,887 views