tag:blogger.com,1999:blog-8185384792158425670.post4218402127750444163..comments2024-03-28T07:25:40.651-07:00Comments on APEX stuff in one place: Interactive grid validation duplicated rows checkSLinohttp://www.blogger.com/profile/09438773517445280187noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-8185384792158425670.post-60494671147618255352024-03-28T07:25:40.651-07:002024-03-28T07:25:40.651-07:00i would like to check duplicate in a single column...i would like to check duplicate in a single column.. is it possible to check ?Amirthahttps://www.blogger.com/profile/13720354172653661531noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-1933094792493668912022-11-19T09:52:42.144-08:002022-11-19T09:52:42.144-08:00thankyou i found the issue work now perfect soluti...thankyou i found the issue work now perfect solution.Zakria Nawazhttps://www.blogger.com/profile/07780236325224674129noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-12389143876952161642022-11-18T10:23:14.014-08:002022-11-18T10:23:14.014-08:00Hi I have two column i.e STORY_WORK_ORDER_ID(prima...Hi I have two column i.e STORY_WORK_ORDER_ID(primary_key) and WORK_ORDER_ID and i want to validate that user cannot add two same work_order Zakria Nawazhttps://www.blogger.com/profile/07780236325224674129noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-85340864692190582052022-08-13T21:31:24.545-07:002022-08-13T21:31:24.545-07:00This comment has been removed by the author.Taralhttps://www.blogger.com/profile/14539705386525584613noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-36000100183266361342021-10-04T23:13:03.042-07:002021-10-04T23:13:03.042-07:00Thanks Sir.Thanks Sir.Usman Chaudhryhttps://www.blogger.com/profile/17858163417482744682noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-89689047875399135302021-07-13T06:45:41.219-07:002021-07-13T06:45:41.219-07:00https://jsfiddle.net/xn50cr6a/https://jsfiddle.net/xn50cr6a/SLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-32542707101967993212021-07-09T23:19:12.686-07:002021-07-09T23:19:12.686-07:00Hi, Even we have the requirement to check duplicat...Hi, Even we have the requirement to check duplicate for the Varchar ( Ename ) example, is there a chance to share that JS codeAnonymoushttps://www.blogger.com/profile/07555895854465261462noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-48763142531208632652021-07-07T05:01:47.968-07:002021-07-07T05:01:47.968-07:00It should be easy.... similar to before https://ap...It should be easy.... similar to before https://apex.oracle.com/pls/apex/f?p=84111:22 does the ename checks. This is the JS used here https://jsfiddle.net/xn50cr6a/SLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-56520138865067850682021-07-07T02:25:28.183-07:002021-07-07T02:25:28.183-07:00Hello,
i tried to check duplicate records on ENAM...Hello, <br />i tried to check duplicate records on ENAME columns but no luck.<br />could you please let me know how to check duplicate ENAME in the same JS.<br /><br />Thanks bhatthttps://www.blogger.com/profile/03751490536254249408noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-22667126031383604142021-06-23T05:25:35.750-07:002021-06-23T05:25:35.750-07:00Copy and paste it into your Function and Global Va...Copy and paste it into your Function and Global Variable Declaration section of the pageSLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-55772381401250744292021-06-23T01:50:27.680-07:002021-06-23T01:50:27.680-07:00its looking good but i don't know where to wri...its looking good but i don't know where to write this code and how to call it. any one can please guide me.Anonymoushttps://www.blogger.com/profile/14208503115708469137noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-36436786910358567402021-05-12T23:43:00.012-07:002021-05-12T23:43:00.012-07:00Please make sure you copy the code into Function a...Please make sure you copy the code into Function and Global Variable Declaration and that you give your IG region a static ID empSLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-39799666225288654492021-05-12T23:42:42.376-07:002021-05-12T23:42:42.376-07:00Please make sure you copy the code into Function a...Please make sure you copy the code into Function and Global Variable Declaration and that you give your IG region a static ID empSLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-8345639229775942352021-05-12T09:09:58.403-07:002021-05-12T09:09:58.403-07:00Where should I call this function? SHould I create...Where should I call this function? SHould I create a DA on the Emp Name and call update(model)?tanmatramhttps://www.blogger.com/profile/01334743388741335260noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-25772929778190022192021-02-06T12:50:56.554-08:002021-02-06T12:50:56.554-08:00hey so i added this in Function and Global Variab...hey so i added this in Function and Global Variable Declaration but its not working....added a table with columns id, emp, sal ...any idea why?amzihttps://www.blogger.com/profile/12151589263196661777noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-47646224692001418372020-08-09T06:53:07.033-07:002020-08-09T06:53:07.033-07:00I didn't try this with filters yet. It may hav...I didn't try this with filters yet. It may have to do with a 'filtered' view and data collected by IG where it seems my current solution looks at whole loaded model. SLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-15195915384000213692020-07-27T07:45:17.941-07:002020-07-27T07:45:17.941-07:00I tried disabling the filters before the model is ...I tried disabling the filters before the model is fetched but as disabling filter is asynchronous it dint helpSrinivashhttps://www.blogger.com/profile/17491557762499386000noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-16416695050960730762020-07-26T00:40:35.968-07:002020-07-26T00:40:35.968-07:00Will it work with filters Will it work with filters Anonymoushttps://www.blogger.com/profile/06015008477738948951noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-31238822369724200982020-05-05T09:02:09.171-07:002020-05-05T09:02:09.171-07:00It works fine in apex 19.1, thank you very much. I...It works fine in apex 19.1, thank you very much. I'll see the way to solve that problem in apex 5.1Anonymoushttps://www.blogger.com/profile/09207512448877063020noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-78259608970632237862020-05-05T09:00:26.728-07:002020-05-05T09:00:26.728-07:00not working in apex 5.1 not working in apex 5.1 Anonymoushttps://www.blogger.com/profile/09207512448877063020noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-14045979116773266952020-04-22T20:16:24.430-07:002020-04-22T20:16:24.430-07:00Please ignore my previous post.
I was able to reso...Please ignore my previous post.<br />I was able to resolve the sameAnonymoushttps://www.blogger.com/profile/14906726016512632455noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-21247747776243829832020-04-22T19:19:28.036-07:002020-04-22T19:19:28.036-07:00Can you please explain what is salary in line 28
A...Can you please explain what is salary in line 28<br />Also hitting with the below error, how to fix <br />Error: Line 28:['salary'] is better written in dot notation.Anonymoushttps://www.blogger.com/profile/14906726016512632455noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-34182347337975756452020-04-21T23:42:00.970-07:002020-04-21T23:42:00.970-07:00Yes it is possible, check how we are getting Salar...Yes it is possible, check how we are getting Salary and Empno on JS lines 11 and 12SLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-50555516508240922192020-04-11T07:17:41.019-07:002020-04-11T07:17:41.019-07:00it's working. thanks.
i want auto serial no in...it's working. thanks.<br />i want auto serial no in a IG column for save. not Sequence Row Header. is it possible.mon!rhttps://www.blogger.com/profile/03184904423074849326noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-76295593078899540742020-04-10T06:18:46.341-07:002020-04-10T06:18:46.341-07:00Copy and paste it into your Function and Global Va...Copy and paste it into your Function and Global Variable Declaration section of the pageSLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.com