Skip to Main Content

Java Development Tools

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!

creating dynamic LOV from a table containing multiple columns

TayyebJul 21 2022

I have a table (A) with multiple columns and want to create a LOV to be used for other table (B).
ColumnS in Tabel (A=CURRICULUM) are: CURRICULUM_ID, SUBJECT_ID, GRADE_ID, DOMAIN_ID, CATEGORY_ID, STANDARD_CODE, STANADARD_STATEMENT, LEARNING_TARGETS.
My query is as below:
SELECT CURRICULUM_ID CI, STANDARD_CODE SC FROM CURRICULUM
WHERE
SUBJECT=:P48_SUBJECT_ID
AND GRADE_ID=:P48_GRADE_ID
AND DOMAIN_ID=:P48_DOMAIN_ID
AND CATEGORY_ID=:P48_CATEGORY_ID
Its working fine if I use one parameter. but If I use more than one parameter its not working for me. Anyone please elaborate and thanks in advance.

This post has been answered by dvohra21 on Jul 21 2022
Jump to Answer

Comments

Scott Wesley

Open up the browser tools and look in the console for any report JavaScript errors.

Apostolos Papoulis
Answer

I found it!
pic.pngFrom now on you can only double click on days (the letters of the word day at the top of the calendar), not anywhere else in the calendar.
pic2.png

Marked as Answer by Apostolos Papoulis · Jul 14 2022
1 - 2

Post Details

Added on Jul 21 2022
5 comments
407 views