search

Pretius / Pretius-APEX-Enhanced-Lov-Item

Oracle APEX plugin
MIT License
24 stars 11 forks source link

Popup Lov pluging Multiple Selection #56

Closed jbernal507 closed 4 years ago

jbernal507 commented 4 years ago

Hi experts

Im using APEX 18.2 and I m need it to particular functionality of List, return more than one value for example I need to show to end uer at least 6 field in select, and return 4 values to differents apex item before submit...

any ideas to fix this issue..!

Thanks a lot..

bostrowski commented 4 years ago

Hi @jbernal507

this functionality is not ready to use out of the box but it can be done via the plug-in configuration.

Imagine your plug-in item is based on emp table and its SQL query looks like below:

select
  ename d,
  empno||'#'||deptno||'#'||mgr||'#'||job r,
  empno,
  ename,
  deptno,
  mgr,
  job,
  sal,
  comm
from 
  emp

It will produce popup report with almost every column from emp table but it will be returning concanated string with values of

separated with # character.

When you define dynamic action listening to change event on this item you can use true action Set Value to assign these values to items you want.

Lets say you have text items:

True actions Set Value should have attribute Set Type set to JavaScript Expression and JavaScript Expression should look like

this.triggeringElement.value.split('#')[0]

Where number in square bracket refer index of the value:

True actions should be using Execution Options \ Fire on Initialization set to No (not checked) so the true action won't be executed on page load.

In general it looks like this: image

The end result looks like this: example

Don't forget to set the plug-in attributes so the plug-in popup report won't contain d and r columns.

jbernal507 commented 4 years ago

Thanks Bartosz

works great....

jbernal507 commented 4 years ago

One little thing... After submit the apex item keep with the last value...

image For example in my case the field is called Order its OK or I can perform some reset?

bostrowski commented 4 years ago

I'm not sure what you are trying to say here

For example in my case the field is called Order its OK or I can perform some reset?

If you want to clear the field after selecting and redistributing values you can use dynamic action to Clear the field.

Please be more specific.

jbernal507 commented 4 years ago

Thanks Bostrowski... OK I said that the field that contain the LOV, after I selected the value, and perform submit the record are insterted into DB, but the filed keep the last value selected..! I would like to crear all fields in the page after submit

Do you understand me ?

jbernal507 commented 4 years ago

Hi Other main issue its possible that the Plugin allow me to align values of the list for example for amount column align right? when Show the list

image

bostrowski commented 4 years ago

@jbernal507

Thanks Bostrowski... OK I said that the field that contain the LOV, after I selected the value, and perform submit the record are insterted into DB, but the filed keep the last value selected..! I would like to crear all fields in the page after submit Do you understand me ?

yes, you can achieve this by using APEX process called clear. You can clear items via dynamic actions, You can clear APEX items from PL/SQL process. All depends on your requirements.

Please spend some time learning APEX. The plug-in support doesn't stand for ask me anything about APEX.

Hi Other main issue its possible that the Plugin allow me to align values of the list for example for amount column align right? when Show the list

Yes, please read the plug-in docs here on github and inline page desinger help/texts for the plug-in attribute Popup Settings \ Report Columns Configuration.

I'm closing this thread since the main question is answered.

jbernal507 commented 4 years ago

OK thanks for your help... but all developers can help or not? Now I see that only you answer my questions and its not the idea..! So I did I posted here to learn from all apex expert..! Then you say some words like " Please spend some time learning APEX. The plug-in support doesn't stand for ask me anything about APEX. " Of course Im learning but the process is a little slow.

Thanks for your time and help..!

regards..!

bostrowski commented 4 years ago

@jbernal507 The case is that this is github repository dedicated to one particular Oracle APEX plug-in. I'm answering because I'm the author of the plug-in and I do support other developers according to the support described in the plug-in readme file.

image

If you want to learn from APEX developers (world wide) you should consider using apex.world slack or write at official Oracle APEX community forum: https://community.oracle.com/community/groundbreakers/database/developer-tools/application_express

Here I do support Oracle APEX developers only in case they find bug in my plug-in Pretius APEX Enhanced LOV item. For example, you found the bug and you want to know when it can be fixed.

Regards Bartosz