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!

Oracle Apex 18.2 - Issue with LoV, Text with Autocomplete and DA

AshiwnJan 16 2019 — edited Jul 11 2019

Hi All,

     Good Afternoon.

I have an oracle apex page with these columns Score, EPrintID, UoA, LeadEprintID and Personno.

The users come in and score using a drop down list under the Score column.

I have a functionality when a user scores in a row and if there are same EPrintID and UoA in the same table then it should automatically update the selected score in the rest of the table where the EPritnID and UoA are same. I am using Javascript for this and its working.

Now the Lead EPrintID column - This column is nothing but when the user types in the EPrintID which is already scored then it should take the Score for that EprintID and update the table automatically with that score. I use Javascript for this.

Check out the page from the below Link you might get a better understanding.

LeadEpritnID.PNG

In the LeadEPrintID column when the user starts typing i want the list of values to show up so that the users can select the EPrintID which they want to enter rather than typing the whole thing. I Used Text with Autocomplete for this and then Used LOV using a Sql Script to get the list. The list is showing up but the javascript functionality to update the scores is not working in 18.2 but works in 5.1.4.

It works in 18.2 if i change the type to Number but the issue is i don't know how to create LoV when you change the type to Number.

LOV_LeadEPrintID.PNG

It was working fine in Apex 5.1.4 after we upgraded to 18.2 it stopped working.

In the below page link i have the functionality working but using type Number without the LoV.

I want the LeadEPrintID coloumn to have LoV and also update the score column with the score for that entered EPrintID in LeadEPrintID coloumn

Any idea or help will be much useful.

User ID : User

Password: Redcarpet007

https://apex.oracle.com/pls/apex/f?p=83223:4:100877929740422:::::

Thanks

Praveen

Comments
Post Details
Added on Jan 16 2019
16 comments
2,484 views