tag:blogger.com,1999:blog-8185384792158425670.post437086815515308299..comments2024-03-28T07:25:40.651-07:00Comments on APEX stuff in one place: Interactive grid validationSLinohttp://www.blogger.com/profile/09438773517445280187noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-8185384792158425670.post-44623637884897258612021-01-26T07:06:47.274-08:002021-01-26T07:06:47.274-08:00To check duplicates among entered records you may ...To check duplicates among entered records you may use APEX_COLLECTION api.<br /><br />1) define apex collection as a PL/SQL process executed before header:<br /><br />begin<br />APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'EMPLOYEES');<br />end;<br /><br />2) use Validation like you do, but with collection instead of db table:<br />declare ln_count number :=0 ;<br />begin<br /> if :APEX$ROW_STATUS = 'C' then <br /> select count(*) into ln_count <br /> from APEX_COLLECTIONS <br /> where collection_name = 'EMPLOYEES' <br /> and c001 = :EMPNO; <br /> if ln_count = 0 then <br /> APEX_COLLECTION.ADD_MEMBER ('EMPLOYEES'<br /> ,p_c001 => :EMPNO<br /> );<br /> else return 'This is duplicate';<br /> end if;<br /> end if; <br />end;goto150https://www.blogger.com/profile/11656055057204474691noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-56556753126114984432020-07-21T09:07:16.246-07:002020-07-21T09:07:16.246-07:00Could post on IG with JS check on duplicate rows h...Could post on IG with JS check on duplicate rows help? I am not sure I understand your use caseSLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-25789733908222504582020-06-14T00:58:53.419-07:002020-06-14T00:58:53.419-07:00Sir, I want this validation on one column. Live va...Sir, I want this validation on one column. Live validation on one ITEMCODE in one row. If select same itemcode on next row then error message will show.mukulahmed@blogspot.comhttps://www.blogger.com/profile/15886317834083067491noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-83728295642769603092020-06-14T00:20:46.309-07:002020-06-14T00:20:46.309-07:00I select 2 rows, click submit, duplicate error sho...I select 2 rows, click submit, duplicate error shown..that's fine. But if i change one of them.. still duplicate error showing.. If i change both of them.. duplicate error showing.. even I reload the page again, and select only one row from previous selected, till duplicate error showing...mukulahmed@blogspot.comhttps://www.blogger.com/profile/15886317834083067491noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-43393433847889871012020-04-06T08:11:51.356-07:002020-04-06T08:11:51.356-07:00I added a post on how you could check for duplicat...I added a post on how you could check for duplicates using pure JS so it does not do Server side validation. <br /><br />Check it out on https://lschilde.blogspot.com/2020/04/interactive-grid-validation-duplicated.htmlSLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-85770690879430021642020-04-04T00:11:35.554-07:002020-04-04T00:11:35.554-07:00how to validation without save button which means ...how to validation without save button which means validation message through while enter duplicate values.<br />Tamil Khttps://www.blogger.com/profile/02941395917630463019noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-87463695919309585582020-03-04T03:36:13.604-08:002020-03-04T03:36:13.604-08:00This example works great when you have only 1 refe...This example works great when you have only 1 reference in the table. <br /><br />In case there is an additional reference, it won't work. <br />Let me explain my case:<br /><br />Every week an attendance sheet is entered using the EMPNO. <br />The week after when you have a new attendance sheet and also enter the EMPNO; <br />You will get 'This is duplicate' message when and employee (EMPNO) is in both attendance sheets (thus same table). <br /><br />I tried using the page reference :P10_EMPNO but the validation than does not work on this. <br /><br />How do you handle this? <br /><br />thanks in advance.<br /> <br /><br /><br /> WDDZhttps://www.blogger.com/profile/04486228983991018496noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-21600771861148343942020-01-08T18:05:27.925-08:002020-01-08T18:05:27.925-08:00Set editable regionSet editable regionWayne lenhttps://www.blogger.com/profile/17559859400621687937noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-15958675221974322942019-09-03T03:17:01.757-07:002019-09-03T03:17:01.757-07:00it's an helpful example.thank you.it's an helpful example.thank you. iRajhttps://www.blogger.com/profile/00375217218163757790noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-10227103347375915372019-08-29T07:28:32.353-07:002019-08-29T07:28:32.353-07:00How to handle this if there are more than one Inte...How to handle this if there are more than one Interactive Grids in the same page? Thanks in advance.Sunnyhttps://www.blogger.com/profile/01121908178936920522noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-57109059477788362702019-06-11T02:48:13.708-07:002019-06-11T02:48:13.708-07:00Fab. Just what I needed. Thanks very much.Fab. Just what I needed. Thanks very much.thetrouserpressguyhttps://www.blogger.com/profile/06173171269394003900noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-8472814982441967322019-04-17T23:55:34.170-07:002019-04-17T23:55:34.170-07:00@Sunny, I've been trying to find the exact sam...@Sunny, I've been trying to find the exact same IG Client side validation solution but no cigar. For new and updated rows (C and U), its fairly easy to validate against already submitted data. I'm guessing JS with for example "onBlur" with loop on records with rowstatus C and U. I'm just not that good in JavaScript.<br />@SLino, any idea how to validate against nonsubmitted rows?Vemphttps://www.blogger.com/profile/15824448230656028476noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-30226377038538589722019-04-13T12:39:33.291-07:002019-04-13T12:39:33.291-07:00Hi SLino,
Thanks for the clear explanation.
I trie...Hi SLino,<br />Thanks for the clear explanation.<br />I tried this but this is not covering the case where the user enters the duplicates within the new(now adding) rows.<br /><br />Is there a way to do this. Sunnyhttps://www.blogger.com/profile/01121908178936920522noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-43620468451970183992019-01-21T06:58:49.308-08:002019-01-21T06:58:49.308-08:00Is there a way to use APEX_$ROW_STATUS is JS? If t...Is there a way to use APEX_$ROW_STATUS is JS? If the row status is update I need to set the values of WHO_UPDATED column, if the status is create I need to set the value of WHO_CREATED column. Anonymoushttps://www.blogger.com/profile/05583052619264795262noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-47946404075321321472018-10-03T12:16:48.016-07:002018-10-03T12:16:48.016-07:00If a user select two duplicates values without sav...If a user select two duplicates values without saving it does not work???Aswanthhttps://www.blogger.com/profile/11627290971230201376noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-89340205790640101392018-05-29T03:11:32.768-07:002018-05-29T03:11:32.768-07:00Thank you this was helpfullThank you this was helpfullAnonymoushttps://www.blogger.com/profile/16056070812909201705noreply@blogger.com