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.
Nice, thank you Anton
Great session,
So where can we find this plugin?
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.