tag:blogger.com,1999:blog-1271763227002553835.post2915392605624002600..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: Tree with Checkboxes - Pre-Select Data with JSONAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-1271763227002553835.post-80045332884188007172015-04-14T15:23:38.017+02:002015-04-14T15:23:38.017+02:00The method described is specific to the Tree compo...The method described is specific to the Tree component, I haven't tried this with other components.Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-29479617167880761882015-04-14T14:51:26.418+02:002015-04-14T14:51:26.418+02:00Alex,
Will this above method of pre-select-data w...Alex, <br />Will this above method of pre-select-data will work with "checkboxes with LOV"??<br /><br />Suppose say, Item P1_CHECKBOX is created using ("SELECT ENAME, EMP FROM EMP") which gives multiple checkboxes.Anonymoushttps://www.blogger.com/profile/01412054723414774418noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-11816860295515258422014-09-26T08:49:09.334+02:002014-09-26T08:49:09.334+02:00Further update - looks like IE9 is okay - the erro...Further update - looks like IE9 is okay - the error may be associated with the values I have used for the Tree - mine had spaces :-)<br />So I have created unique, non-spaced identifiers. I will continue working with your example and provide feedback (on Monday)...<br />RiFhttps://www.blogger.com/profile/04987723366578713674noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-9583962564620982112014-09-26T07:42:09.818+02:002014-09-26T07:42:09.818+02:00Alex - just been checking the versions of software...Alex - just been checking the versions of software, and the SOE is <br>.../widget.tree.min.js?v=4.2.1.00.08; <br><br />your version is .../widget.tree.min.js?v=4.2.5.00.08<br /><br />So I will check in my later, local version of APEX before going forward.<br />RiFhttps://www.blogger.com/profile/04987723366578713674noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-79218276919539020422014-09-26T07:06:38.003+02:002014-09-26T07:06:38.003+02:00I am using IE 9.0.31, as provided with our SOE.
F...I am using IE 9.0.31, as provided with our SOE. <br />FireFox 32.0.3 works okay. <br /><br />But wrt this example, I am having difficulties with the alignment of your instructions, and the APEX 4.2.1.00.08 environment. In particular the settings for the 'Dynamic Actions' and AJX Callbacks. I am incrementally adding the tree-with-checkboxes-pre-select with static data (select '123' as EMP from Dual;) before using my real situation. But I cannot get the check boxes enabled. <br /><br />Any suggestions or web links for the best way to debug? I am only just learning APEX and javascript. All the other components for my simple application have used the OOTB APEX capabilities.<br />RiFhttps://www.blogger.com/profile/04987723366578713674noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-43131502590343893202014-09-26T06:38:41.070+02:002014-09-26T06:38:41.070+02:00You did click on one of the pencils to go to page ...You did click on one of the pencils to go to page 16, right?<br />Which browser are you using? I'm using Chrome and just checked that my demo page still works, and it does.Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-91684310243258418972014-09-26T05:37:55.064+02:002014-09-26T05:37:55.064+02:00Excellant article.
But on attempting to run the e...Excellant article. <br />But on attempting to run the example APEX pages at <br /><br> https://apex.oracle.com/pls/apex/f?p=47888:15:0::NO::: <br><br />the check boxes do not appear - only folders.<br />Am I missing something?RiFhttps://www.blogger.com/profile/04987723366578713674noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-54383034575200034312014-09-09T09:10:18.920+02:002014-09-09T09:10:18.920+02:00Hi Yannis,
Thank you for your comments.
From what ...Hi Yannis,<br />Thank you for your comments.<br />From what I understand you have managed to create the tree with the checkboxes (from the first blogpost) and you want to implement the other two parts (loading and saving the data).<br />Loading the data is described (step by step) in this blogpost. Just continue on the page where you created the Tree with checkboxes and follow the steps.<br />Saving the data is described in http://nuijten.blogspot.nl/2013/11/tree-with-checkboxes-save-data-js-array.html<br />Continue on the same page and follow the steps. Of course you will also need to create the database procedures, but that is also described in the last blogpost.<br /><br />AlexAlex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-32337443840635582882014-09-08T13:06:06.179+02:002014-09-08T13:06:06.179+02:00Not sure why it says unknown as my username. Altho...Not sure why it says unknown as my username. Although I use my Google account!<br /><br />Thank you<br /><br />YannisUnknownhttps://www.blogger.com/profile/05101136437792496891noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-81997329264786657552014-09-08T13:03:57.012+02:002014-09-08T13:03:57.012+02:00I created in APEX a tree (no language selection is...<br />I created in APEX a tree (no language selection is implemented yet) using the following code:<br /><br />select case when connect_by_isleaf = 1 then 0<br /> when level = 1 then 1<br /> else -1<br /> end as status, <br /> level, <br /> "SCHEDULEB" || ' - ' || COMMODITY_DESCRIPTION as title, <br /> null as icon, <br /> "SCHEDULEB" as value, <br /> "COMMODITY_DESCRIPTION" as tooltip, <br /> 'f?p=&APP_ID.:25:'||:APP_SESSION||'::::P25_SCHEDULEB:'||"SCHEDULEB" as link <br />from "#OWNER#"."APP_PRODUCT_CATEGORIES"<br />start with "PRODUCT_PARENT_CATEGORY" is null<br />connect by prior "SCHEDULEB" = "PRODUCT_PARENT_CATEGORY"<br />order siblings by "SCHEDULEB"<br /><br /><br /><br />I was able to apply your 1st article (http://nuijten.blogspot.nl/2013/07/apex-tree-with-checkboxes.html) to create checkboxes on the tree. <br /><br />How do I implement the Pre-Select Data with JSON (http://nuijten.blogspot.nl/2013/09/tree-with-checkboxes-pre-select-data.html)<br /><br />and how to implement the saving of the selections (http://nuijten.blogspot.nl/2013/11/tree-with-checkboxes-save-data-js-array.html)<br /><br />Thank you<br />Unknownhttps://www.blogger.com/profile/05101136437792496891noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-28919914242798703882014-09-08T13:03:26.399+02:002014-09-08T13:03:26.399+02:00Alex,
This is a great series of articles. I think...Alex,<br /><br />This is a great series of articles. I think this concept needs to be incorporated in APEX itself.<br />I tried to use it in an application I am creating but the luck of javascript knowledge gives me a lot of headaches. Any help would be highly appreciated by me (and all those guys who do not know javascript as well)<br /><br />The problem I have is:<br /><br />I want a customer to sign up to as many product categories as he likes to receive updates by email when a change happens to any of those products<br />The customer must be able to select as many categories as he likes at any node or at leaf level.<br />When he wants to revisit to add or remove categories, I need to load all his selections on the tree so he can see at any time what is his current selections.<br /><br />The product table is using a tree structure of up to 4 levels deep defined with field "CODE_LEVEL" (Its about 25K English records which will be going up as we add more and more language translations and categories) <br /><br /><br />CREATE TABLE "APP_PRODUCT_CATEGORIES" <br /> ( "CHAPTER" VARCHAR2(2), <br /> "SCHEDULEB" VARCHAR2(30), <br /> "COMMODITY_DESCRIPTION" VARCHAR2(1000), <br /> "UNIT_OF_QUANTITY" VARCHAR2(30), <br /> "CODE_LEVEL" NUMBER, <br /> "LANG" VARCHAR2(2), <br /> "SCHEDULEB_LANG" VARCHAR2(40) GENERATED ALWAYS AS ("SCHEDULEB"||'-'||"LANG") VIRTUAL VISIBLE , <br /> "CODELEVEL" NUMBER, <br /> "PRODUCT_PARENT_CATEGORY" VARCHAR2(30), <br /> CONSTRAINT "APP_PRODUCT_CATEGORIES_PK" PRIMARY KEY ("SCHEDULEB_LANG") ENABLE<br /> )<br />/<br /><br />CREATE INDEX "APP_PRODUCT_CATEGORIES_IDX1" ON "APP_PRODUCT_CATEGORIES" ("SCHEDULEB")<br />/<br /><br />CREATE INDEX "APP_PRODUCT_CATEG_PRT_IDX1" ON "APP_PRODUCT_CATEGORIES" ("PRODUCT_PARENT_CATEGORY")<br />/<br /><br /><br />Then I have the table where I need to store the selections from the above table per customer (CREATED_BY)<br /><br />CREATE TABLE "APP_EMAIL_UPDATE_RULES" <br /> ( "ID" NUMBER, <br /> "SCHEDULEB" VARCHAR2(30), <br /> "CREATED_ON" TIMESTAMP (6) NOT NULL ENABLE, <br /> "CREATED_BY" VARCHAR2(255) NOT NULL ENABLE, <br /> "LANG" VARCHAR2(2), <br /> "SCHEDULEB_LANG" VARCHAR2(40) GENERATED ALWAYS AS ("SCHEDULEB"||'-'||"LANG") VIRTUAL VISIBLE , <br /> CONSTRAINT "EMAIL_UPDATES_PK" PRIMARY KEY ("ID") ENABLE, <br /> CONSTRAINT "APP_EMAIL_UPDATE_RULES_UQ" UNIQUE ("SCHEDULEB", "CREATED_BY") ENABLE<br /> )<br />/<br />ALTER TABLE "APP_EMAIL_UPDATE_RULES" ADD CONSTRAINT "APP_EMAIL_UPDATE_RULES_FK" FOREIGN KEY ("SCHEDULEB_LANG")<br /> REFERENCES "APP_PRODUCT_CATEGORIES" ("SCHEDULEB_LANG") ENABLE<br />/<br />ALTER TABLE "APP_EMAIL_UPDATE_RULES" ADD CONSTRAINT "EMAIL_UPDATES_FK" FOREIGN KEY ("CREATED_BY")<br /> REFERENCES "APP_USERS" ("USER_ID") ENABLE<br />/<br />continued...Unknownhttps://www.blogger.com/profile/05101136437792496891noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-19055806419432757232014-09-08T13:00:47.310+02:002014-09-08T13:00:47.310+02:00This comment has been removed by the author.Unknownhttps://www.blogger.com/profile/05101136437792496891noreply@blogger.com