hi, this is very nice, thank you all Insum Team. my query is can someone populate a select list or popup lov without the values already exist in IG to prevent duplication? i knew there is a solution 'After Selection' of a value we can prevent user if it is already in IG but what if we do not want to populate those values in a select list query ( Like using NOT IN etc., may be using a page item which contains comma separated values populated on load and add / remove a value when user select or change selection etc.)? i do not know JS, but i knew without JS we can't prevent duplication in IG. if there is a way for this, it will be very helpful for all.
I don’t quite understand what you are asking. Take a look at episode 139. That may be what you need. If not, can you give a specific example? Give me a select statement and tell me the results, and then tell me what you don’t want to see in the results and why.
@@antonnielsen7630 thank you Sir Anton for very quick response. very sorry for any incovenience what i want to. let me explain: i am using Apex 23.1, if i have a master detail page of HR.DEPARTMENTS and HR.EMPLOYEES, interactive grid of HR.EMPLOYEES (Detail) contains a column JOB_ID which is an LOV, the sql quiry is " Select JOB_TITLE d, JOB_ID r from JOBS " ... the restriction is all Employees should have a unique JOB in every Department ... now I want LOV populate values each time on every row when user click on JOB_ID LOV column it should NOT contain the JOB_ID's which are already selected in previous rows in IG ( even IG rows not yet saved in database ), if there is no previous row(s) it should display all values to select. i hope its clear now. with kind regards.
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
Nice, thank you Anton
Great session,
So where can we find this plugin?
There is a link in the show description. You can get it there.
hi, this is very nice, thank you all Insum Team. my query is can someone populate a select list or popup lov without the values already exist in IG to prevent duplication? i knew there is a solution 'After Selection' of a value we can prevent user if it is already in IG but what if we do not want to populate those values in a select list query ( Like using NOT IN etc., may be using a page item which contains comma separated values populated on load and add / remove a value when user select or change selection etc.)? i do not know JS, but i knew without JS we can't prevent duplication in IG.
if there is a way for this, it will be very helpful for all.
I don’t quite understand what you are asking. Take a look at episode 139. That may be what you need. If not, can you give a specific example? Give me a select statement and tell me the results, and then tell me what you don’t want to see in the results and why.
@@antonnielsen7630 thank you Sir Anton for very quick response. very sorry for any incovenience what i want to. let me explain: i am using Apex 23.1, if i have a master detail page of HR.DEPARTMENTS and HR.EMPLOYEES, interactive grid of HR.EMPLOYEES (Detail) contains a column JOB_ID which is an LOV, the sql quiry is " Select JOB_TITLE d, JOB_ID r from JOBS " ... the restriction is all Employees should have a unique JOB in every Department ... now I want LOV populate values each time on every row when user click on JOB_ID LOV column it should NOT contain the JOB_ID's which are already selected in previous rows in IG ( even IG rows not yet saved in database ), if there is no previous row(s) it should display all values to select.
i hope its clear now. with kind regards.