User Info

Ray

Name:

Raymond Allo

Website:

https://www.apexia.com.au

Location:

Australia

Last Seen:

Nov 21st, 2022

Description:

 

Avatar

Profile Image

337 Questions

ThreadPostedQuestion
Check if grid has rows15.09.2022 01:09 How can I check that a grid has rows. The continueif has a condition grid is empty (No rows), but that does not work in the context I want. If the grid has after retrieval 1 row and you delete that 1 row, it still classifies the grid to have a row.   
Grid after load DA13.09.2022 02:09 I would like to know a little bit what happens behind the scenes with a window in a page. We have in a page a window which has a grid. Initially we place a DA on the After Load to hide or show a button, but that never works until the window has been displayed. Hence we have to put it on a After Render as well. So is this the expected behaviour?
GRID allowed operations and buttons13.09.2022 01:09 I have a question regarding the button management and allowed operations on a grid. We use a PLSQL expression for allowed operations on a grid. When it is set to READONLY all buttons are still enabled although you can not modify/add/delete. It would have been nice to disable the buttons when the allowed operations is set to READONLY. Now we disable/hide the buttons manually which is ok.
Upgrade to 21.2 FOEX reports errors08.09.2022 01:09 I think there is something wrong in you script with the sequence of statements .======================================================================== . Start upgrading FOEX Data to FOEX_210200 .======================================================================== . INSERT INTO FOEX_210200.FX_T_PATCH (ID,FX_T_VERSION_ID,ROW_VERSION,HOTFIX,BUILD_NO,TYPE,CORE_UPDATED,INSTALL_COUNT, ROLLBACK_COUNT,CREATED_ON,CREATED_BY,UPDATED_ON,UPDATED_BY) SELECT ID,FX_T_VERSION_ID,ROW_VERSION,HOTFIX,BUILD_NO,TYPE,CORE_UPDATED,INSTALL_COUNT,R OLLBACK_COUNT,CREATED_ON,CREATED_BY,UPDATED_ON,UPDATED_BY FROM FOEX_210100.FX_T_PATCH Throws Error ORA-02291: integrity constraint (FOEX_210200.FX_T_PATCH_FX_T_VERSION_ID_FK) violated - parent key not found INSERT INTO FOEX_210200.FX_T_PATCH_HISTORY (ID,FX_T_VERSION_ID,ROW_VERSION,HOTFIX,BUILD_NO,TYPE,CORE_UPDATED,CREATED_ON,CRE ATED_BY,UPDATED_ON,UPDATED_BY) SELECT ID,FX_T_VERSION_ID,ROW_VERSION,HOTFIX,BUILD_NO,TYPE,CORE_UPDATED,CREATED_ON,CREA TED_BY,UPDATED_ON,UPDATED_BY FROM FOEX_210100.FX_T_PATCH_HISTORY Throws Error ORA-02291: integrity constraint (FOEX_210200.FX_T_PATCH_HI_FX_T_VERSION_FK) violated - parent key not found   I ran those two afterwards and they ran in ok.
Multiple column values in POPUP LOV05.09.2022 01:09 Can you display multiple columns in a PopUp LOV in FOEX like in a LOV in APEX or can we only use grid combo? I created a list of values in shared components with more than 2 columns, but the LOV still only shows the display column.
Latest patch version 21.2 package error FTRANS_P_VIEW02.09.2022 03:09 We tried to rollout the latest 21.2 release (1/sep/2022) but getting a compile error Please rectify. Our DBA has lost all confidence in this release apparently.
FOEX Calendar31.08.2022 09:08 In the Calendar Month view I need to execute a DA when they click a date which has an all day event. Actually it does not matter too much just clicking on a day is enough, but I need to know what day it is they clicked. I know I need to use this.data && this.widget, but all this is still black art to me. I need to assign the day they clicked to a hidden field.
Wizard30.08.2022 06:08 Change Request for the Wizard - It would be nice to be able to place the Next and Previous Buttons on either side of the Wizard progress line like in APEX version - The Next and Previous is placed at the top and bottom of the region. Would be nice to be able to only display at the top.  - Version 4 option shows a tittle underneath each step. It would be nice to be able to do that in the Version 5 optionally too. APEX 4    APEX 5 In APEX 5 it is a guessing game /surprise what the next step is going to be. So not sure if any of these enhancements will be considered anymore or if it is game over and we can only request bug fixes
Date field calendar not displaying years30.08.2022 03:08 <img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAvoAAAIOCAYAAADJHKnaAAAgAElEQVR4Aey9fVBUV7rv31VT5X/5mz+pSiiposp45k6FU2fumSGZXGCiJ06SM068PxJIjg4mGTF6jXoNQXN0jCK+3GRQjAZiFF8PCb4kKIaICr7hS2t402kUEDiQNoGkLQc5h5rvr5619+7eu+luGuymX/ha1Xb37r3XXutZ373WZz3rWQuby+UCX7QBNUANUAPUADVADVAD1AA1EF8asLFC46tCWZ+sT2qAGqAGqAFqgBqgBqgB0QBBnzManNGhBqgBaoAaoAaoAWqAGohDDRD047BSOYrnKJ4aoAaoAWqAGqAGqAFqgKBP0OcInhqgBqgBaoAaoAaoAWogDjVA0I/DSuUIniN4aoAaoAaoAWqAGqAGqAG/oH/79m1cvXoVly5deqSXpCFpUWwUGzVADVAD1AA1QA1QA9QANTBxGvAJ+gLmTU1N6PvuO/zQ3/9IL0lD0iLsT1yl8gGirakBaoAaoAaoAWqAGqAGfIK+eOFDAfnGIEHSkjQpOAqOGqAGqAFqgBqgBqgBaoAamBgN+AR9CdcxID1U75ImK3ViKpV2pp2pAWqAGqAGqAFqgBqgBgj6XIzLARg1QA1QA9QANUANUAPUQBxqgKAfh5XKETxH8NSAVQOOslmw2Wza6/FUZOeX43Kv9Zzx2Kwm34ZZZY6J6xxbSzHLKIctAcnP5aGiScrRiIq3M5AovyUkI2NJBRyqbXPiclkeMlISVNkTUmZjbXWXnt8aFLjTSkTqKxtRp2xiPi73yMVG9zWazRr35iLVNgulrY9uw/HYndfQ7tQANUANBKeBcYB+Kz7f/DHWjvY63GoJ/2HoTnAVQuHSTtRA6DWgQD+/RgPcfgcqlqQiYU65DsO+7teI4vQC1IziCIgM6HvyVbdqOmz5NXAeyYPtxVI0Sn77nWh0aDDfdTAXCU8tRYVDK6PzeilmJ6Si4IwTLpcAvQHrXTi2fDqmr6vzOu5C18Vi0zVO1ORnIGP5UmS7r/VlPx7jc0wNUAPUQDRoYByg34/erh50dIzy+s66Ww9Bn4KPBsEzD5NThxbQFxh2HkOegGqTC84zG5GRkozUpxKRmJ6HilYnalalIdGWiNRn0pBWVAeXsw4bn0tG8lOpSHw8A3mfa158Af20eXmY9bjmSc/+rFENJhzi8ZY0UxKR/PuNqHO64GqqQF56MpJTEpGQkq3u7T72VDKSXzQ86nVY+3gCllb7qCvl0TdAX4Pz1KLLcNWvxfQntbx7NO5A+Rwbcg8aHnwtvcaP0mBbLoMeE+j3d6Hi7QRkbJP8m47rAx3PNWI770GCj3yOMkDy5JHX0hbUADVADYRTA3EB+s7GSrzz5gI8kTYfj2UuwO8KK3FVOlaXC7Ufzsdj/6cSbUbHc7EYj6UVYPcdF1zq83w8JtfJS867U4mXje/qvRi1Rjpp8/F06TV92ltP+8Nz6ntz1Rb87nktnf/xZhEO3PJxbyMPLhfO7Vik7vncPg0M3Hn1e4827P4/nrw+8a/vIHfHGXQPeD0gev7XXPQc99jAmoaU2XNeDw7ka+m/U/uDXkb9fL2MmhDPYY3FPto1L3/RoOXPfK7Z1u6ye+Xh+UXucjiv7car/6qll5K1Gh9e/k7LR+cZFP3fRUhR912Ap/9vKWo7TfVr5EfS2tUAp/teLrR9UYDHMreg6nvDHq34OHc+njDl81yp1IWuCdO1roE2HCjQdPXE60U43GakwfdwNkrhSHsE6CuYtaHgG6lLJ5z9Wp3WLDdCcQR2DaDWfnPqbYqreqnynktojID+9OU1muaaJKwmFxVdmldd02EjSp/X7uP4bDZsr5XCIfdS93Og9MUE5B0RcHbB8Vk2ElaJR92Jxm9q0OgrtMgSumOD7bm1qGvX8uf4ci1mpyQg8cUClF+RNCV9o4zaOeo+Esb0Yikc
How do you set the nr of cards from list view and control how many cards you want to display per line22.08.2022 02:08 1. I am trying to set the nr of items in the list, but can&#39;t find where to do that. No matter what it is always 15. Hiding pagination does not help either. 2. Is there a way where you can set the maximum nr of card columns. In my case I want no more than 4 per row. I saw in&nbsp;https://forum.foex.at/question/how-to-link-a-card-with-a-form-in-foex you specified something in list CSS class t-Cards--3cols&nbsp;
FOEX calendar how to move to another year on a DA19.08.2022 05:08 So I am at a total loss how I can make the calendar display/navigate to another month/year on a DA. I have a date field and a button. I have a DA on the button which executes action Calendar Action / Change Date. I tried putting a refresh after it, tried different formats. Clearly missing something here. The documentation failed to make me any wiser either.
FOEX Display field does not honour format mask28.07.2022 11:07 FOEX Display field does not honour format mask. Was asked before in 2016 but never answered. &nbsp;
Calendar errors on load25.07.2022 03:07 I get the following message when I add the calendar and just utilise the default query placed in the component. Why? &nbsp; &nbsp; SELECT &#39;ABC123&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS ID &nbsp; &nbsp; &nbsp;, &#39;DEF456&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS CALENDAR_ID &nbsp; &nbsp; &nbsp;, &#39;Appointment&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS EVENT_TITLE &nbsp; &nbsp; &nbsp;, sysdate &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS START_DATE &nbsp; &nbsp; &nbsp;, sysdate+1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS END_DATE &nbsp; &nbsp; &nbsp;, &#39;Some notes ...&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS NOTES &nbsp; &nbsp; &nbsp;, &#39;Vienna, Austria&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS EVENT_LOCATION &nbsp; &nbsp; &nbsp;, &#39;https://www.tryfoexnow.com&#39; AS EVENT_URL &nbsp; &nbsp; &nbsp;, &#39;true&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS IS_ALL_DAY &nbsp; &nbsp; &nbsp;, &#39;true&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS REMINDER &nbsp;FROM DUAL
How to force check for unsaved changes in form which opened a window where changes were made08.07.2022 11:07 Workspace: fx_ws_1963 App: 301 Page: 2 and 3 I have a form which opens a window ( show window) which is defined in the form page. This window shows a grid which can be updated. When you close the window, the changes remain unsaved until you click Save in the Form. But when you just close the form it does not check that the grid in window region has outstanding changes. How do I handle this? Beside forcing dirtying the record in the form somehow.
Execute DA on System message box &quot;Warning you have unsaved changes&quot; when clicked NO08.07.2022 03:07 When I close a tab and the form on the tab has unsaved changes I want to execute a DA when the user answers No. How do I do this?
Forum personal profile &quot;questions&quot; returns error30.06.2022 02:06
Closing a tab by ID with referencing a field which holds the ID does not work when tab is opened in iframe mode28.06.2022 06:06 Workspace: fx_ws_1963 App: 301 Page: 6010 Let me give you the scenario One page with grid <img alt="" height="367" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABHUAAAFvCAYAAADE5/d3AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAMTUSURBVHhe7P17lFXFue+Nd3LeP94z3pOz331GwptxdsK7d7KJO1GSqO0lisYLqBGNFzQqxFujUSRq8IYgQguCrYJ4pVGhURREsUXAFkRBwAZEwL7RN/oCNHTTdINE9z7j9+7xuzy/+a25ntW1atVavRa9uunLlzE+g141q2rWrHt951M1s/bvbZD6PTVStbtCvt61Q+6996+yo/7/RQghhBBCCCGEEEJ6MRR1CCGEEEIIIYQQQvogFHUIIYQQQgghhBBC+iAUdQghhBBCCCGEEEL6IF5R5+2V2wghhBBCCCGEEEJIL8Yr6rS2thJCCCGEEEIIIYSQXgxFHUIIIYQQQgghhJA+CEUdQgghhBBCCCGEkD4IRR1CCCGEEEIIIYSQPkhKok5dXV2/xX1WQgghhBBCCCGEkL4ARR3nWQkhhBBCCCGEEEL6AimJOv86Yky/xX1WQgghhBBCCCGEkL4ARR3nWQkhhBBCCCGEEEL6AhR1nGftUzQUy+yx02X+9r0dbhVr5MF758qHNZY/QgghhBBCCCGE9Dso6jjP2neokoKxt4bPcfmkUNip+EBuvzzybNctlO3ecIQQQgghhBBCCOkPUNRxnrUvUbLiKblIn+XysXKmCjojbpUxS6q8YQghhBBCCCGEENI/yHrx8WXypSXqjL3uojhPtgjS33Cfta8RI+wYKOgQQgghhBBCCCEDgazP590nr29UUWe1XHfxNXGebBGkv+E+a5+j4gMZE7XQCdCtWD6/hBBCCCGEEEII6Tdk7d+yQO6bs0pKIOp8NFcuvua2OE+2CNLfcJ+1T2GfoWNDYYcQQgghhBBCCOn3ZO3f+4UsvnemvLetQj5+4U659rZxcZ7iRIN+hPusKVGzWm6PhL9rRax4sv6p2Ph/e93Dctfr22W/5ae1ZqPMvvdu+a3xc6tchC9YFR+IiadzdsmLN+l9bpUxb5TJ9pgzdl6W9d5whBBCCCGEEEII6Q+Yg5K/XPqozFy2VF4Y/bTcfk/6ByV/+e/i/7d/k9e/zfv74bFZ3vdc+9d5VfJtcPXb0sXx1zKE+6ypUPfe1CDsBPnjLUEcD6yROutaKOr8VSa9t1E+XDJf7roJX6i6VR4siog2NWvkLljXXP5XuWv6yzLtqWdlzFUPy/yvO+JIlf3F8+WPl4eCjrqFZ+zcLZPW0VKHEEIIIYQQQgjpz4Rfv9q2RB695WYZ8+Q7Mv44vn71flWz1O9vlgMRcef/ORr+ri9+x+vfpu+JOnvk7XuDsHd/IOuXTArimC7vNXRcD0WdSVJQEXFbN9fcRw8v/mL22OD3WIouhBBCCCGEEEII6RLRT5p/sfhhmbWsuEufNJ9R+h9QaKT+E/91H31O1IlsvTIiDQ4pDv6+/b090euuqFPyBoQftdSpkoKxuM6tUYQQQgghhBBCCOkaRtSp3Fggj058TT7etaMbRJ2psqj0mBFnwn//Kd/WfxY9kyYUdY5JZX0YFtcPfLVYfo/rrqjz58Wybr/6C/79e5tsmne/uXb76n3y7X9G3HGPQztkSuQeyXCftTN061W4XapM5mML1r2ro1uw3DN1wEXTN0auF8skuN39gVRG/BNCCCGEEEIIIYQcD1n7y1ZI3qz58uE2fNK8O0SdMfJIcbPUl+6Q1Z9vlS8PGS9SWRheC0UdbNmqk3XFddJmhJn/kC/nB
Error installing FOEX 21.204.06.2022 14:06 As we already were on 21.1, I am not sure if I need to run this step. BEGIN &nbsp;&nbsp;FX_P_DEVELOPER_ADDON.Check_Preconditions(652); END; Well just in case, I get the following error &nbsp;
Enhancement request for Return Extra Instructions26.05.2022 12:05 It would be nice to be able to set fields in read_only mode directly. Now I have to add a custom event and add that to FireEvents I know I could use enable/disable field but that makes it visually faint. Yes I know I can add a class to correct that, but read_only mode would be nicer. Oh and of course to be able to set a field to insert mode again.
Date time field in expansion section of grid does not display correctly25.05.2022 00:05 A picture tells a story &nbsp;
Calculate cell based on change from other cell21.05.2022 14:05 Simple example Grid with columns product, price, quantity, total price when I change the price or quantity I need to calculate the total price In previous version of FOEX, you had to create hidden fields for price and quantity Define a DA Before Edit on the grid Have to actions: 1 place column value (cell) into hidden fields 2. Set column value on column change Looking now in current version some new events - FOEX Grid set column value on column change with a before and after Set values Not clear how I am supposed to use/set up this one - There is the action Set column value on column change. This as I understands combines to actions into one, but you still have to define hidden values if you want to use pl/sql expression etc. I got this to work by using the Grid - Before Edit Event
Change field text color dynamically with DA does not work22.04.2022 04:04 We seem to have a problem with changing the color of a text field dynamically. I tried several ways.&nbsp; 1. Form Item Actions, Set Style. Issue is that you need to specify "color:red !important", but extJS does not like the !important 2, Form Item Actions. Add class. What happens it adds he class to the label and not the field For your amusement fx-ws-1963, app 301 page 31&nbsp;
How to individualize the &quot;Do you want to delete message&quot; on click of the DELETE-Button (again)08.04.2022 04:04 This question was asked a log time ago (2014). Fast Forward 2022. Is this possible , beside writing you own DA with Message Box etc.?
Set the width of a column in a combo box23.03.2022 05:03 This is a question which has been asked in the past and I would like to share a solution which works for me. First set autosizeColumn and forceFit Then in the field Column Headings You specify the headings with some CSS styling like Epi ID,Episode,<div style="color:red;width:200px">Organisation Name</div>,URN,From Date,<div style="color:green;width:130px">Significant Event</div>,<div style="color:red;width:30px">RTA</div> The result in this case looks like&nbsp; <img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA0QAAAGTCAYAAAAIvdKQAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAEdQSURBVHhe7d3/c9zVnef7/gvuD7e2empv3ehW7Y2pvaw1lSLamnsrSjZL2nd3UGYyoJtJUCpltgs2I26yROylyGQJ9K3Egy6ZoECSaVcNacgwNLm4Oi5jGmxMGxvaNrabwaZjkNNGJo2/IeGQOF8YwPDe8/586f506yOpdSS1WkdPVz3K6s/3/ujT53Nefc7nKHHp0iUBVtvhw88DHYu7hgAAAGwQiAAAAACsWwQiAAAAAOsWgQgAAADAukUgAgAAALBuEYgAAAAArFsEIgAAAADrFoEIPSFuaGVgLnHXEACgu+LKZ2Ax4q6r1UAgQk/opQ8FehvXCgD0BspjLAWBCGhDoYpOca0AQG+gPMZSEIiANhSq6BTXCgD0BspjLAWBCGhDoYpOca0AQG+gPMZSEIiANhSq6BTXCgD0BspjLAWBCGhDoYpOca0AQG+gPMZSEIiANhSq6BTXCgD0BspjLAWBCGhDodqbpo4+K0enYubNTMqBA5My0z69C7hWAKA3UB5jKXo0ENUkN5SQRCIqI6XIwnOpTAxIcqwo0zHz7JQkY/afKcXNm1stN2SOOSnD+VrL9FLGvJdMqWXasqjlZCgxJLlazDwsCoVq75l8/FbZdMUVcsXGzfLIZGTezAHZ8tmNcoWZt+muA8sWin76/2+Xz/75l+Qvv3ij7Hxid+wyimsF6La1Xz+4VC/J+PAGSeqxJzfI4Mi4lOoxy62EUqbl3PUNDMlotiz1uGXXGMpjLEVPB6KhbEXq9XpgumXhufRWINLCblSK083pBKLeR6HaY6a2yWYNQ6EwFEXCUOjWx8/Gb2ORNAzt339InnzyGS8UxS2juFaAblvr9QP/+JPDWSnXzLFXy5LPFqQau+wK8ALRmBSCc1ctZSU9YIJRurDmQxHlMZaitwNRrrV1ZXUsIRCNZSWbSki/CUBhAUwg6n0Uqr1mRg7ctakl+Fyx8bNyXVsY2rj5QXl5Jm79uU09/lXZGNlG6H/8F1fI5cuX5d1335M/+p/+jbz11sXY9blWgG5b6/UDf52RfD1mXl0K6eTiW5xaLLANLxC1tahVs5JK9Mt4OTJtLuVxGRjKSS1u3iqjPMZSrL1A5FX80zKRG5VUnzb59kkqU2x8sxENHPXSuAxvSPotNX0DMpKt+MFkuiK50ZT06XRdfzQnlUYrzrRUsiOyIWnmJTfI8MS4pKMFXnRdnW/2HffNjh+ITBAyhU9/IiXZqj89enzeMtGCxSuomqFGlx2ayMtE0LSe3DAiuXIp8npYJsrBN2NBIBobjz8vcx+3Fs7DkisV
How to execute things in a DA before a Master-Detail21.02.2022 04:02 I have a Master Detail DA between a form and a grid in another page which is loaded using a content loader region. It all works fine. However if I add an action before the&nbsp;&nbsp;FOEX Master Detail action, something strange happens. The detail is fetched but ignores detail connection column and as a result retrieves all rows of the table. If I then issue a refresh it only retrieves the correct rows. Now I can imagine the MD is a special thing so "don&#39;t mess with it". But would be the best way to do things which may need to done before the Detail Retrieval. I know I can serialize two DAs but that may be taking it too far.
Open same page in new tab from grid and from navigation menu31.01.2022 07:01 I have a question as I am struggling to overcome the problem. When you open a form from a grid it is straight forward by using jQuery selector and .fx-new-tab (or .fx-<page>-new-tab) But we are opening page 1000 from the navigation menu with the content loader as well. Single dynamic action handling all menu options.&nbsp; But the problem is that if the page is loaded via the menu and via a grid (even in a new tab) they affect each other. We could make the page slightly different and show a grid when called from the menu and then use the .fx-new-<xx>-new-tab, but it would be an ugly hack. I am sure there is a better way of doing this.&nbsp;
File upload using file browse plugin errors08.12.2021 12:12 When using the file browse plugin to upload a file I get an ora-22835&nbsp;Buffer too small for CLOB to CHAR or BLOB to RAW conversion&nbsp; error. Any suggestions?
Simple master detail, click apply changes always shows success message even nothing has changed05.11.2021 01:11 Simple master detail, click apply changes always shows success message Records has been successfully updated even when nothing has changed. I tried clearing dirty status etc. Same result.
Form region with container and validations01.11.2021 04:11 I have a region which is a form with a container sub region and is not based on a view or table. So just a collection of fields. When we create a validation on one or more fields and then on a button cliick execute a DA with an action Validate, the field validations never fire. Is this to be expected as the form is not based on a table or view and hence the fields do not map to a database column.
Discard changes configuration missing in release 21.118.10.2021 04:10 Discard changes configuration missing in release 21.1. We had this problem before. I assume that the file in question is&nbsp;&nbsp;com_foex_plugin_foex_settings.sql. I have of course the version for hotfix 4514. Not sure if I could use that one.&nbsp;
Detecting unsaved changes with extended search07.10.2021 11:10 When we make a change in one of the fields&nbsp;on the right and click on another row on the left it correctly detects unsaved changes. But when instead click in the extend search row, it does not warn us for unsaved changes. Which is technically correct as have not taken any action. But when enter something and hit enter or tab it refresh the grid and you loose unsaved changes. Enhancement request?
Turn auto correction&#x2F;finishing off on a date field07.10.2021 09:10 Is there away to turn to auto completion off on a date field. Example: the date is 5-apr-1954. User deletes last two digits and tabs out of field it changes the year to 2019. We seem to have dumb and blind users as I suggested to put a check on the DOB that a person needs to be at least 18. I got voted down. Please shoot me now.&nbsp;
Enhancement Request for Show Regions as Tabs21.09.2021 12:09 I would like to see an additional option for dealing with changes on Tab Close. Either add an option "Alert Pending Changes on Tab Close" or Change this option to Alert Pending Changes on Tab Switch and/or Tab Close"
Force marking form as changed20.09.2021 09:09 I have a bit of an issue and though I found a solution of some sort, I wonder if there is a better way of doing it. If a user changes a field in a form (which maps to a column) but not tabs out of it or clicks on another field, the change event is not fired. We have the situation where a user changes a field leaves the cursor in the field and then for example clicks Close Window (modal). At that stage it does not detect a change has occurred and closes the window without prompting for unsaved changes. So what I do is perform a DA with Validate Form.&nbsp; Wondering if there is a better way or maybe should put in an enhancement request.
How do I use Content Loader - Before Close event16.09.2021 14:09 Page 22 has a grid. Select a row and detail page 95 is being opened in shared tab using the content loader. I need to do some housekeeping when they click the X to close the opened page 95. I am not clear what/where to specify the FOEX Content Loader - Before Close Event. I would assume that I create the DA in Page 22 and as selection type I use jQuery Selector. The content loader loads page 95 in a tab with the SHARED ID&nbsp; P95_SHAREDTAB. So I specify jQuery Selector #P95_SHAREDTAB&nbsp; But that does not work. Please let me know where I go wrong here.&nbsp;
Discard Changes08.09.2021 06:09 We have an interesting situation. Our Forms migration project to APEX/FOEX phase 1 is currently in UAT. When we go live the Forms application will run side by side with the APEX application and that will continue for at least 2 years. In UAT there was an interesting question raised by the users. In Forms when there are unsaved changes&nbsp;the message box is "Unsaved changes" "Do you want to save your changes?" Yes/No. That is actually a standard prompt in many applications like Notepad, Word etc. FOEX on the other hand takes the approach&nbsp;that when you are leaving you want to discard. So it is the opposite, but both are answered with "Yes". They are now concerned that when people switch between the two applications their brain/muscle memory will click automatically the "Yes" in the APEX app. Now we could start handling this ourselves in the app and then make the prompt "Unsaved changes" but that would mean a lot of work now and in the future. Not only form and grids but also on tab changes. Your thoughts please and if there are alternative options?&nbsp; &nbsp;
Suppress browser &quot;Unsaved Changes&quot; window02.09.2021 03:09 I have a page (page 95) which opens page 100 in a modal window. Before the user closes the window we need to a check and stop the window from closing if the check fails. So in page 95 We deal with that using the Before Close event with jquery selector. In normal use they would have pressed Save first and then close the window.&nbsp; But now we are in a situation where the close and we get the Browser confirmation window to Discard changes. That would be ok , but when we click No it still closes the window. I would be ok to suppress that window and then use FOEX to test for unsaved&nbsp;changes if possible. But in reality the click on No should just close the Browser Message and be done with it. I have an alternative if this is an issue. I would add a Close button and then hide the X. Not elegant but a temporary work around as we are in UAT with very close go Life date.
Wizard in vertical mode31.08.2021 15:08 Is it possible to define the wizard in a vertical setup instead of horizontal. Maybe by defining width and height? Also there is no example in the Cookbook anymore, or am I missing something?
Stop navigating to another Tab when unsaved changed24.08.2021 08:08 I would like some help how to handle the following situation I have it almost working Client Search is pages 22. Client Detail&nbsp; is page 95 loaded using content loader. Using the FOEX Layout - Tab Change and using the jquery selector I check pending changes. But at that moment the "Client Search" is already selected. It does pop-up the message. But here is where it gets tricky. When you answer Yes to discard changes it is fine, but I need to handle the No as I want to navigate back to the detail tab. But as far as I understand the action on the answer only handles the Yes (true) but the No (false) stops. Maybe I am approaching this wrong, but any help to handle this would be most welcome.
Header search executes after Reset Column Filters24.08.2021 06:08 I have a grid set to load on demand. But when I use a DA to Reset Column Filters it ignore the load on demand end populates the grid. Not exactly&nbsp;what I want as it queries a quite a big table with a nice order by and that takes a bit unfiltered. Is there a way to stop that or do I have to do something clever in the query and checking a field which is set when the DA resets the column filter.&nbsp;
double click and content loader dramas23.08.2021 12:08 We are running into a strange behaviour with fast double clicking. I have a grid with a list of clients. The grid&nbsp;has a DA "Row Single Click". This uses the content loader to open the detail window in another Tab (shared - current page) Now the strange thing. If I sort or normal speed double click it works still fine. But when I do a fast double click it all goes pear shaped. After the fast double click&nbsp;it loads and displays, but when I go back to the list to open another one with just a simple single click it does not load.&nbsp; But if I open the first time a detail record in the tab with a single click it loads. I go back then do a fast double click and it keeps working properly. It is only on the first time I fast double click a row in the grid and it opens the tab with content loader. Looking with the debugger, I noticed that it drops back to iframe doing the fast double click. I also get the following error&nbsp; You&#39;re trying to decode an invalid JSON String: Duplicate component id "P95_EPISODES_TOT" at new... which does not make much sense given the context. However based on this error I can understand it is dropping back to iframe mode, but again it does not make much sense to me. I tried to replicate the behavior in the demo ground (alas a much simpler 2 page master-detail) but to no avail. In&nbsp; my page I tried to to use delay/debounce, tricks to ignore the double click but with no success. &nbsp;
Uppercase conversion pushes cursor to end of field23.08.2021 01:08 FOEX Text field: Transformation - Upper Case When you move the cursor into another position in the string you typed to make a correction, the cursor always jumps to the end of the string after typing the first character. So I thought to be clever and set Transformation to No Transformation and put in the Field Style&nbsp;text-transform: uppercase, but alas that does not work as it transforms it on the screen to uppercase , but still writes it to the database in lowercase. Cunning plan fell of the cliff.
Page access protection11.08.2021 02:08 Can you please explain what the restrictions are setting page access protection with FOEX. Specifically using content loader. Thanks
Quick picks04.08.2021 02:08 Quick picks is at the moment static. But it would be really nice if we could set this dynamically.&nbsp; Specifically the QP Links. Enhancement request?
FOEX Big Number falls back to iframe01.08.2021 12:08 I have a region&nbsp;in my screen where I use the Big Number&nbsp;plugin. I noticed that using Big Number&nbsp;always falls back to IFrame. Is this as expected? The captured&nbsp;error&nbsp; FOEX SPA Error - URL: f?p=500:860:11642787006803::NO:::: Message: {"stack":"Error: Duplicate component id \"TOTALS\"\n &nbsp; &nbsp;at new Ext.Error (http://s2s-devdb-02:8080/i/foex/ext/resources/js/ext-all.js?v=20.2.0.4498.01:20:31981)\n &nbsp; &nbsp;at Function.raise (http://s2s-devdb-02:8080/i/foex/ext/resources/js/ext-all.js?v=20.2.0.4498.01:20:32383)\n &nbsp; &nbsp;at Object.Ext.raise (http://s2s-devdb-02:8080/i/foex/ext/resources/js/ext-all.js?v=20.2.0.4498.01:20:32530)\n &nbsp; &nbsp;at ctor.register (http://s2s-devdb-02:8080/i/foex/js/foex.min.js?v=20.2.0.4498.01:7:53026)\n &nbsp; &nbsp;at constructor (http://s2s-devdb-02:8080/i/foex/ext/resources/js/ext-all.js?v=20.2.0.4498.01:20:550093)\n &nbsp; &nbsp;at constructor.callParent (http://s2s-devdb-02:8080/i/foex/ext/resources/js/ext-all.js?v=20.2.0.4498.01:20:95062)\n &nbsp; &nbsp;at constructor (http://s2s-devdb-02:8080/i/foex/js/foex.min.js?v=20.2.0.4498.01:77:79861)\n &nbsp; &nbsp;at constructor.callParent (http://s2s-devdb-02:8080/i/foex/ext/resources/js/ext-all.js?v=20.2.0.4498.01:20:95062)\n &nbsp; &nbsp;at constructor (http://s2s-devdb-02:8080/i/foex/js/foex.min.js?v=20.2.0~ &nbsp;
Can I check when a Tab is closed which had a page loaded with the content loader26.07.2021 07:07 We have a page (#1000) which loads page 1100 with content loader in a new tab in page 1000. When they close that tab we need to do some house cleaning/checks. How would we need to do this. Do I need to use Content Loader Before Close or could I use Window Before Close somehow maybe. Sure a Tab is not a window, but if it has a static id. Just guessing here.&nbsp;
Context Menu Side effects22.07.2021 07:07 To get out of the issues using click and double click to open a detail window in a shared tab or new tab we decided to use the context menu. So when the user right clicks it gives them the option to open a detail window using content loader in a new tab. In principle this works. But now we get something else strange. Scenario: - click row 1 -> opens tab content loader in a shared tab - click row 2&nbsp;-> is loaded in the shared tab - right click row 3 -> select from context menu "Open in new tab" -> Opens new tab (content loader) - click row 4&nbsp;-> sets label of shared tab correctly with customer name , navigates to shared tab does not load row in shared tab I did see a fall back from SPA mode. Arguments(4)&nbsp;[constructor, {&hellip;}, &fnof;, Error: You&#39;re trying to decode an invalid JSON String: Duplicate component id "P95_EPISODES_TOT" &nbsp; &hellip;, callee: &fnof;, Symbol(Symbol.iterator): &fnof;]&nbsp; Now I checked the page for P95_EPISODES_TOT but I can only find the Hidden field P95_EPISODES_TOT and a reference in a Tab title (#P95_EPISODES_TOT#). I am open to any suggestions where else to look.
pop-up calendar refinement date field19.07.2021 12:07 This might be a strange request. The client&nbsp;asked if it is possible to hide the "Today" button in the calendar of the date field. I had a bit of a browse on Google and the Sencha doc, and seems there are possibilities, but before I embark on and adventure with no destination, I would like to run it by you. I did find in ExtJS Kitchen Sink that you can display the calendar without today.&nbsp; &nbsp; xtype: &#39;container&#39;, layout: &#39;hbox&#39;, items: [{ title: &#39;Date Picker (no today)&#39;, margin: &#39;0 20 0 0&#39;, items: { xtype: &#39;datepicker&#39;, showToday: false, handler: &#39;onDatePicked&#39; } All I need is a little help with the correct place/format for FOEX. Thanks.
Can you add a class and remove a class dynamically from a label19.07.2021 08:07 I have a field which is sometimes mandatory and sometimes not. I want to change the label dynamically between "*&nbsp;My Field label" and "My Field Label". I know you can add and remove a class but that is for an item, icon and badge. But not for a label. Do I need to use the "set label" action in Form Item Actions or use a javascript function
APEX filtering in grid not working when using function body returning SQL query11.07.2021 06:07 When I use function body return SQL Query and have a column which is a number like Age and use the APEX filtering > 67 it only ever executes = 67 instead of > 67 Interestingly using the > sign on dates works. Using a > on a varchar2 column like last_name also does not work for example > F Using a grid on a table/view the filtering works as expected. &nbsp;
  • 1 - 50

82 Answers

AnswerThreadCorrect Posted
So I had a look at this and it is not even working properly. The PL/SQL Expression Returning JSON, which sets the address and postal_code is only setting the address. The postal_code is not even set. So I do not know why that is. Maybe the&nbsp;&nbsp;PL/SQL Expression Returning JSON is not working as it should or your json format is not what it expects. So let me know what the case is her. &nbsp; I would also like an example/explanation how I am suppose to use this DA It never shows columns unless I change Region to the query of the grid. I just want to know if this is really working or in an unfinished state Calculate cell based on change from other cell24.05.2022 01:05
We can close this issue. The actual error was caused by a (historic) data problem which was never corrected. Ora-01427 single row sub query returns mote then one row FOEX_040200.FX_P_FORM_DML16.03.2021 03:03
Menu Search05.02.2021 08:02
HFXP-4409 Update 2 has resolved the issues. At least the ones we know off ;-) Chrome is failing miserably06.01.2021 00:01
Applied HFXP-4409, but Chrome is still not behaving. Example: Page 1400, grid with list of bookings Page 1410, Form with booking details Open page 1400 (first time) Click on booking to open detail window (Page 1410)&nbsp;in tab (Content Loader). Page 1410 replaces Page 1400 , This is consistent until I reload page 1400 and then open page 1410 Sometimes reloading page 1400 and then open Page 1410 works, sometimes not. It is about 50-50 Content Loader configured to open in "Current Page". If I change loading into &nbsp; "Current Page iframe" it behaves the same way. (I initially thought it was working, but ran into the same behavior. Firefox works fine. Chrome is failing miserably31.12.2020 05:12
So now we are at a total loss what is going on. We tried every option (clear cache, deinstall/reinstall FDA, deinstall/reinstall browser) to no avail. Brought up the app, opened Developer Tools / Network to capture what happens when we try to activate the FDA. For some unknown reason we were able to activate the FDA now for&nbsp;this one particular app. The others worked fine. We did the same steps in Firefox and that works now too. Bowl me over with a feather. I have no explanation, maybe you. If not we can close&nbsp;this thread. FDA not activating28.09.2020 10:09
ws: fx-ws-1963, app 301, page 24 You have to perform a search (like above). runthe page again from the designer and it comes up warning "Leave site save&nbsp;changes" Grid is flagged as dirty when using Extended Search28.09.2020 04:09
&nbsp; Master detail Tree-Grid and form does not refresh master row08.09.2020 06:09
Query Grid SELECT auco.rec_id AS ID , auco.auth_component_rec_id AS PID , auco.description AS TEXT , apex_util.prepare_url(&#39;f?p=&#39;||:APP_ID||&#39;:61:&#39;||:APP_SESSION||&#39;::NO::P61_REC_ID:&#39;||auco.rec_id) AS URL , NULL AS DISPLAY_SEQ , CASE auct.code WHEN &#39;APLN&#39; THEN &#39;fa fa-globe green-color&#39; WHEN &#39;MENU&#39; THEN &#39;fa fa-flag-o darkblue-color&#39; ELSE &#39;fa fa-briefcase brown-color&#39; END AS CSS_CLASS , auct.description AS INFO , NULL AS CUSTOM , auct.description AS COMPONENT_TYPE , (SELECT COUNT(*) FROM auth_role_profiles aurp where aurp.auth_component_rec_id = auco.rec_id) AS PROFILE_COUNT FROM auth_components auco, auth_component_types auct WHERE auct.rec_id = auco.auth_component_type_rec_id ORDER by auco.auth_component_type_rec_id NULLS first, auco.name &nbsp; Form TABLE "AUTH_COMPONENTS" ("REC_ID" NUMBER(10,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE, "NAME" VARCHAR2(30 BYTE) NOT NULL ENABLE, "DESCRIPTION" VARCHAR2(100 BYTE) NOT NULL ENABLE, "AUTH_COMPONENT_REC_ID" NUMBER, "AUTH_COMPONENT_TYPE_REC_ID" NUMBER NOT NULL ENABLE, "APEX_APPL_ID" NUMBER(10,0), "APEX_PAGE_ID" NUMBER(10,0), "APEX_PAGE_ITEM" VARCHAR2(50 BYTE), "CREATED_DATETIME" DATE NOT NULL ENABLE, "CREATED_BY" VARCHAR2(128 BYTE) NOT NULL ENABLE, "LAST_UPDATED_DATETIME" DATE, "LAST_UPDATED_BY" VARCHAR2(128 BYTE), CONSTRAINT "AUCO_PK" PRIMARY KEY ("REC_ID")) Master detail Tree-Grid and form does not refresh master row08.09.2020 06:09
Well found in the end the problem. in the console the 404 error is reported for the GET which looks something like this http://devserver19:8080/ords/wwv_flow.show?p_flow_id=500&p_flow_step_id=1600&p_instance=16182722412809&p_debug=NO&p_request=PLUGIN=fXyzMfowk8Zy-gIAa9RRESrdTXGJ9ss5HDbjeJikccCF325KmZxo8oESEhyQDVHw&p_widget_action=DISPLAY_IMAGE&x01=[%2777F0D610AC244A8B859D38C392C87AB8%27]&x02=A7871ABC0A75C08DDE9CFB4103C8C116&x03=?x10=0.38327580591510024 The problem is that the string is not properly encoded and the problem section is&nbsp; DISPLAY_IMAGE&x01=[%2777F0D610AC244A8B859D38C392C87AB8%27]&x02 It contains a [ and a ] and this causes a problem for Tomcat. Not sure if this is an ORDS or APEX problem. The solution is to add an attribute to the server.xml file in the conf directory of Tomcat. In the Connector section add the attribute relaxedQueryChars like this <Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" relaxedQueryChars="[],{}"/> Using FOEX Display_image plugin results in ORDS&#x2F;Tomcat error27.12.2019 07:12
Thank for your help here and highlighting the issue with SPA.&nbsp; There is still one thing not right. - Launch page 1200. - Open villa 101 - Click Tab pricing - Modify a price to something like 6000.10 and click Save - Close the tab, it pops up a window "You have unsaved changes" Uhhh really how? - Click Discard Yes - Javascript error Uncaught TypeError: Cannot read property &#39;getComputedStyle&#39; of undefined &nbsp; &nbsp; at $.CKEDITOR.tools.extend.getComputedStyle (ckeditor.js?v=4.6.1:101) &nbsp; &nbsp; at $.getDirection (ckeditor.js?v=4.6.1:124) &nbsp; &nbsp; at $.setup (ckeditor.js?v=4.6.1:372) &nbsp; &nbsp; at $.m (ckeditor.js?v=4.6.1:874) &nbsp; &nbsp; at ckeditor.js?v=4.6.1:28 ext-all.js?v=4.1.0.4134.03:20 Uncaught TypeError: Cannot read property &#39;isEmptyStore&#39; of null &nbsp; &nbsp; at constructor.getValue (ext-all.js?v=4.1.0.4134.03:20) &nbsp; &nbsp; at constructor.callParent (ext-all.js?v=4.1.0.4134.03:20) &nbsp; &nbsp; at constructor.getValue (foex.min.js?v=4.1.0.4134.03:30) &nbsp; &nbsp; at foex.min.js?v=4.1.0.4134.03:100 &nbsp; &nbsp; at Object.elevate (ext-all.js?v=4.1.0.4134.03:20) &nbsp; &nbsp; at c (ext-all.js?v=4.1.0.4134.03:20) &nbsp; Master Detail when detail in content loader first time detail does not get key passed27.11.2019 10:11
Worked it out. Forgot to give the Notes page a STATIC ID. Ughh Open Window from jQuery selector passing value foreign key to page with grid20.10.2019 10:10
Oh duh. Found the answer. Set&nbsp;in step 2&nbsp; in Attributes "Refresh on Focus" to Yes. Wizard Execute refresh on next15.07.2019 07:07
There is still a real&nbsp;problem with content loader in multiple tabs. This is how to reproduce it in the cookbook app - open 12 examples - close 7 examples - open another 8 examples - close a tab somewhere in the beginning, for example the fourth from the left. The tab closes but leaves a blank screen. After this it closing other tabs same thing happens and then it is a lost case. Only way to resolve it is to reload app. - As far as I can see you need to open more then 10 tabs and then close a few and open new ones so you get over 10&nbsp; Examples&#x2F;Cookbook 4.105.06.2019 01:06
Thanks for the link. That was helpful. The solution is very simple. In foex/lib/ckeditor edit the config.js file change the line config.extraAllowedContent = "span(*)[*]{*};i(*)[*]{*};p(*)[*]{*};div(*)[*]{*};li(*)[*]{*};ul(*)[*]{*}" to config.extraAllowedContent = "span(*)[*]{*};i(*)[*]{*};p(*)[*]{*};div(*)[*]{*};li(*)[*]{*};ul(*)[*]{*};tr(*)[*]{*};td(*)[*]{*}"; Clear your browser cache and it is all good. One thing to be aware of is that CKEditor likes individual style items style="border: 1px solid #CCCCCC" gets changed to style="border-style:solid; border-width:1px". You need&nbsp;to specify it as&nbsp;style="border-style:solid; border-width:1px; border-color:#cccccc" Yes, every time you upgrade FOEX, you have to remember to update/copy that file. Minor inconvenience. CKEditor does not save edited source04.06.2019 05:06
The Triton Theme does have of course that reference to FoexVita.less. I cleared caches (browser, tomcat) but I do not get the new features in Theme Roller (Font Weight, Font Family etc) I have applied hotfix 3909. And yes I copied the css files, before you ask the obvious question.&nbsp; Btw your patch level on demo ground seems to be higher than 3909&nbsp; Big Numbers24.04.2019 07:04
I found the problem. The problem is in the Triton Theme. If I use the Vita theme it works fine, Triton theme stuffs it up. In the demo ground I can not choose the Triton Theme, so I can&#39;t reproduce it there for you. The question now begs, is the Triton theme still required/valid or should I use the Vita theme and recreate my customisations? Big Numbers24.04.2019 05:04
I found the problem and it is data related. If they put in an emoji in the text of varchar2 field and it is only in the first 100 rows it produces the json error. If the emoji is in row 180 it is no problem. I think it is even when a row in the first set (less than 100) has an emoji the problem can occur. Change show # rows in grid json error04.10.2018 00:10
I installed version 4.0.1 (and upgraded to 18.1) and I can inform you that version 4.0.1 has solved the problem. Content loaded page close properly again. Some did in version 4.0.0, but this particular form with quite a few tabs, regions and panels had some problems. The form still loads quite fast for its size (4-5 seconds, so kudos to you all). Still I will look again at the page and break it up in smaller chunks. But so far all good. Content Loader Pages opened in new tabs don&#x27;t close properly19.09.2018 12:09
Well this issue is that the V2.2.0 app has to stay for the next 3&nbsp;months on V2.2 as we have no time to upgrade. We&nbsp;have to move to a new server and hence I thought to upgrade the database. Anticipated as much so installed on 11.2.0.4. But even that had problems at the tail of the install. &nbsp; *********************************************************************************** do some post-install steps *********************************************************************************** PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. DECLARE * ERROR at line 1: ORA-06550: line 12, column 44: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 6, column 25: PL/SQL: SQL Statement ignored ORA-06550: line 23, column 28: PLS-00364: loop index variable &#39;CCOL&#39; use is invalid ORA-06550: line 23, column 25: PL/SQL: Statement ignored ORA-06550: line 30, column 50: PLS-00364: loop index variable &#39;CCOL&#39; use is invalid ORA-06550: line 30, column 25: PL/SQL: Statement ignored ORA-06550: line 41, column 54: PLS-00364: loop index variable &#39;CCOL&#39; use is invalid ORA-06550: line 41, column 54: PL/SQL: ORA-00904: "CCOL"."ID": invalid identifier ORA-06550: line 37, column 25: PL/SQL: SQL Statement ignored ORA-06512: at line 13 Which version of database is supported by FOEX 2.2.127.07.2018 11:07
Error log screen shot javascript console Enabling header search in demo ground 4.0 breaks app29.05.2018 07:05
And the log file 4.0 Beta: Content Loader setting to Current Page makes tabs inoperable11.05.2018 07:05
Well hope you can make some sense of this 4.0 Beta: Content Loader setting to Current Page makes tabs inoperable11.05.2018 07:05
For all interested. If you only use Tomcat/ORDS and not Apache with compression configured (like our Dev environment). Edit the file server.xml in your tomcat/conf directory Look for the section <Connector port=8080 ... and add the lines in bold. Make sure you have no doubling of parameters like connectionTimeout as Tomcat will not startup <Connector port="8080" protocol="HTTP/1.1" compressableMimeType="text/html,text/xml,text/css,text/javascript, application/x-javascript,application/javascript" compression="on" compressionMinSize="128" connectionTimeout="20000" redirectPort="8443" /> Load time page in Designer17.04.2018 12:04
month picker in grid20.10.2017 07:10
Yes min and max value in grid not working14.06.2017 13:06
workspace: fx-ws-1963, application 301, page 7 region collapsed via DA stuck12.06.2017 22:06
Uhmmm now I am wondering if there are a few more which are missing in the release notes. Could you please check, FXP-2974, FXP-3107, FXP-3096. Sorry to be a pain. show page in expander grid01.06.2017 21:06
Ok, thanks, I have been going though the release notes and checking the fixes there. fxp-3141 was not in the list, so I (think I rightfully) assumed it was not fixed. show page in expander grid01.06.2017 12:06
Can you please tell me which next release / hot fix this will be as it is not 3.0.1 unfortunately. show page in expander grid01.06.2017 09:06
Thanks so much. That is just the best solution. I now have also a clear understanding how to use the "continue if". Btw the button I needed to disable is not part of the grid and is on a form region. Disable button on delete success grid09.05.2017 13:05
Yes I do understand that, but my question is how do I disable the button on that event. It only is executed once. Disable button on delete success grid07.05.2017 09:05
Ok I found the particular situation. Set "Loading Grid Data" to "Load on Demand" Run the page Enter search value in any of the column headers Hit return Nothing happens Click mag glass to execute Enter new search criteria Hit Enter Data is retrieved. I displayed the search plugin to enable the query for the first time. So the only time when the "enter" does not work is the first time you open the page and have the grid set to "Load on Demand" Behaviour grid with QBE05.05.2017 00:05
After importing the V2.2/APEX 5 application into V3/APEX5.0 development I do not get the options from V3. I should see If I import the application into V3 environment (lets say appid 150) and then create a new application in the same workspace (appid 60) and subsequently copy the pages from the appid 150 into appid 160 things work. And I am using Chrome. import foex 2.2 app into foex 3.024.04.2017 23:04
In my app version FOEX 2.2/APEX 5.0.4 (and FOEX 2.2/APEX 4.2) it always worked in this config. Now you can argue that is not how it is suppose to work, but it is the only way I can get it to work in a shared TAB. FOEX 3.0 content loader shared tab not working31.03.2017 10:03
When you switch between Neptune themes for about 5 or 6 times the drop down list becomes unselectable. The artefact see below. Apple iMac , OS Sierra, Chrome Version 56.0.2924.87 (64-bit) I tested Firefox and Safari and they have no problems. FOEX 3.0 Theme switch demo app drop down list unselectedable21.03.2017 12:03
I have created in the demo ground app 301 page 1 (home with menu), 4 and 5. Your assistance would be very much appreciated. Using media list02.03.2017 05:03
Yes there is no problem. It runs fine. We are running on 12c non-CDB structure, EE and SE1 (+SE2). If you ever switch to CDB/PDB install APEX/FOEX in a PDB. FOEX 2.2 on Oracle 12c (Non-CDB)19.01.2017 05:01
I found a workaround for the performance problem. It only works if you don't use the order by clause in the form plug-in. I added to the where clause of the form plug-in "customer_site_id = :P10_CUSTOMER_SITE_ID". This pushes the predicate into the inline view. ...Execute Statement: SELECT * FROM ( SELECT CUSTOMER_SITE_ID COL1,CATALOGUE_ADDRESS_1 COL2,CATALOGUE_ADDRESS_2 COL3,CUSTOMER_NAME COL4,STORE_NAME COL5,CATALOGUE_ADDRESS_3 COL6,CUSTOMER_CODE COL7,CATALOGUE_POSTCODE COL8,v('P10_FILLER_01') COL9,CUSTOMER_SITE_CODE COL10,STORE COL11,ADDRESS_1 COL12,ADDRESS_2 COL13,ADDRESS_3 COL14,POSTCODE COL15,ALLOWED_BRANDS COL16,CUSTOMER_ID COL17,lead(CUSTOMER_SITE_ID) over(ORDER BY CUSTOMER_SITE_ID) AS fx#lead1,lag(CUSTOMER_SITE_ID) over(ORDER BY CUSTOMER_SITE_ID) AS fx#lag1,NULL AS fx#last1,NULL AS fx#first1 FROM DS_CUSTOMER_SITE_SALES_VW WHERE (customer_site_id = :P10_CUSTOMER_SITE_ID) ) WHERE COL1 = :P10_CUSTOMER_SITE_ID Execution time drops from 1.92 seconds to 0.0039 Of course it is only temporary hack Form query on view contains lag and lead why?17.01.2017 09:01
All Master-Detail DA convert the master query to a new query with the analytical function. The problem is that the optimizer processes the inline view first and then performs the filter. This is not an issue created by missing statistics etc. CUSTOMER_SITE_ID is the primary key. I tested a master-detail which where the master and detail are a table (not views) and the same behavior occurs. Oracle will simply not push the predicate up into the inline view. SELECT * FROM ( SELECT CUSTOMER_SITE_ID COL1,CATALOGUE_ADDRESS_1 COL2,CATALOGUE_ADDRESS_2 COL3,CUSTOMER_NAME COL4,CATALOGUE_ADDRESS_3 COL5,STORE_NAME COL6,CATALOGUE_POSTCODE COL7,CUSTOMER_CODE COL8,v('P10_FILLER_01') COL9,CUSTOMER_SITE_CODE COL10,STORE COL11,ADDRESS_1 COL12,ADDRESS_2 COL13,ADDRESS_3 COL14,POSTCODE COL15,ALLOWED_BRANDS COL16,v('P10_FILLER_02') COL17,CUSTOMER_ID COL18,ORGANIZATION_ID COL19,lead(CUSTOMER_SITE_ID) over(ORDER BY CUSTOMER_SITE_ID) AS fx#lead1,lag(CUSTOMER_SITE_ID) over(ORDER BY CUSTOMER_SITE_ID) AS fx#lag1,NULL AS fx#last1,NULL AS fx#first1 FROM DS_CUSTOMER_SITE_SALES_VW) WHERE COL1 = :P10_CUSTOMER_SITE_ID If I make the inline view the query as in SELECT CUSTOMER_SITE_ID COL1,CATALOGUE_ADDRESS_1 COL2,CATALOGUE_ADDRESS_2 COL3,CUSTOMER_NAME COL4,CATALOGUE_ADDRESS_3 COL5,STORE_NAME COL6,CATALOGUE_POSTCODE COL7,CUSTOMER_CODE COL8,v('P10_FILLER_01') COL9,CUSTOMER_SITE_CODE COL10,STORE COL11,ADDRESS_1 COL12,ADDRESS_2 COL13,ADDRESS_3 COL14,POSTCODE COL15,ALLOWED_BRANDS COL16,v('P10_FILLER_02') COL17,CUSTOMER_ID COL18,ORGANIZATION_ID COL19,lead(CUSTOMER_SITE_ID) over(ORDER BY CUSTOMER_SITE_ID) AS fx#lead1,lag(CUSTOMER_SITE_ID) over(ORDER BY CUSTOMER_SITE_ID) AS fx#lag1,NULL AS fx#last1,NULL AS fx#first1 FROM DS_CUSTOMER_SITE_SALES_VW) WHERE CUSTOMER_SITE_ID = :P10_CUSTOMER_SITE_ID the query performs as expected (fast) Form query on view contains lag and lead why?17.01.2017 08:01
I can confirm that it actually works now. In my test case it was working as well. I have removed the field in my application, saved the page, and the re-added it (FOEX Display Field). Added the CSS Class and low and below it works now. I have encountered a few other times a similar issue with a page which has been upgraded from 4.2 to APEX 5.0.4 + FOEX 2.2. I did notice that one part of the CSS I had to now add !important, which was not required in 4.2. But that was not unexpected. I think we can safely close this issue as resolved. Thanks again for the quick follow up. Display Item CSS class is not being added09.12.2016 01:12
Hi Team, Will version 3 have the option to reconfigure the grid on a refresh. I have a similar issue. It is easy to hide or show a column when the page is loaded, but when you use FOEX Content Loader, there is no rendering or loading page, only loading data. I have a requirement when I load another record in the Content Loader screen, that I want to hide/show a column. I guess currently the only way to do this is to use javaScript. Conditional column display on treeGrid after refresh24.11.2016 04:11
I created a test case in the demo ground, but of course it works absolutely fine there, sigh. I then recreated the grid region from scratch (copy and pasted the SQL statement) and it worked without a problem. What the ? I suspect something went not so kosher when I upgraded from 4.2 to 5.0.2. I had one or two other occurrences where I had to do a similar thing to get it to work correctly. Oh well, I guess it is one of those things. Export filtered data problem26.10.2016 07:10
SELECT A.CON_ID, A.PERIOD_ID, get_con_name(a.con_id) consultant, A.ACTUAL_STATUS, A.PAID_STATUS, A.UPLINE_ID, case a.upline_id when 0 then 'Head Office' else (select initcap(given_name||' '||surname) from consultant t where t.con_id = a.upline_id) end upline, A.P_BV, A.OWN_TEAM_BV, A.FLBK_TEAM_BV, A.TEAM_BV, A.OWN_LEADERSHIP_BV, A.FLBK_LEADERSHIP_BV, A.LEADERSHIP_BV, A.REBATE_OWED, A.REBATE_ALREADY_PAID, A.SPON_BONUS, A.TEAM_BONUS, A.LEADERSHIP_BONUS, A.ELEVATION_BONUS, A.TOTAL_BONUS, A.CAR_ALLOWANCE, A.ONGOING_ELEVATION_BONUS, A.P_SPON, A.PG_SPON, A.D_NEW_APPT_SALES, A.DIR_MAINT, A.GST_ON_REBATE_OWED, A.GST_ON_TEAM_BONUS, A.GST_ON_SPON_BONUS, A.GST_ON_TOTAL_BONUS, A.GST_ON_LEAD_BONUS, A.GST_REGIST, A.ADJUST_AMT, A.GST_ON_ADJUST_AMT, A.ADJUST_REASON, A.GST_ON_CAR_ALLOWANCE, A.NUM_ACTUAL_STATUS, A.NUM_PAID_STATUS, A.TOTAL_PAYMENT, A.GST_ON_REBATE_ALREADY_PAID, A.TOTAL_REBATE, A.GST_ON_TOTAL_REBATE, a.rowid rowid_pk FROM CONSULTANT_PERIOD_STATS A Thats all there is Export filtered data problem25.10.2016 14:10
I created my demo app in the demo ground. App 301 page 2. Right align of labels22.09.2016 08:09
I am not able to right align the labels even at region level using template options. It just does not get honoured. I looked at page 4000 in the demo/documentation, but I seem unable to get the alignment field for labels. The only difference I see is that page 4000 has FOEX Layout Plugin in the level above my FOEX form plugin. I am currently migrating an app from 4.2 to 5. Right align of labels22.09.2016 07:09
I created in my workspace APP 330 I can't even add a FOEX region to an APEX page. I really need some help here as I am completely stuck and to be honest a bit frustrated. Building Apex pages with FOEX Regions25.08.2016 09:08
Still getting nowhere Building Apex pages with FOEX Regions25.08.2016 08:08
OK I must do something really wrong here as I am getting this error. My workspace : FX_WS_1963 Application: Demo 1 Page : 2 Building Apex pages with FOEX Regions25.08.2016 00:08
Headers on tree grid not showing24.08.2016 13:08
  • 1 - 50

419 Comments

AnswerThreadPosted
Well I tried to login to trial, but alas fx_ws_1963 Check if grid has rows27.09.2022 05:09
Thanks for confirming Multiple column values in POPUP LOV05.09.2022 23:09
It is the full release. We are on 21.1 APEX and upgraded FOEX from 21.1 to FOEX 21.2 Latest patch version 21.2 package error FTRANS_P_VIEW05.09.2022 23:09
Thanks! FOEX Calendar01.09.2022 02:09
Oh that is weird my screenshots etc seem to have not come through. My apologies. &nbsp; The DOB field is in a Form Region container. All the field in the search criteria container are just fields being used for building the sql statement. The weird thing is that the year not showing only happens with a few users. 90% has no issue, 10% has the issue. We thought it might have been browser related,, but the users who experience it have it both in Edge and Chrome. There is nothing special about the field &nbsp; And by accident (sheer luck) we found the problem. For one or another unknown reason the user has set their browser to 90%. Setting back to 100% solved the issue. OMG 1 year it took us to figure this one out.&nbsp; Date field calendar not displaying years31.08.2022 02:08
Bump. Any suggestion how to set the number of cards per page to 100 or more? How do you set the nr of cards from list view and control how many cards you want to display per line22.08.2022 12:08
OK Thanks but how about issue nr 1. I need to able to display all cards non paged and this can be 100+ cards.&nbsp; How do you set the nr of cards from list view and control how many cards you want to display per line22.08.2022 08:08
Please refer to page 6000 of the cookbook, Simple Listview. in that example the page is limited to 25/per page. In regards to nr 2 I can set the width of the region to limiit the nr of cards per row. But what I saw in the forum what you did for another client I was wondering if there is some CSS you can set to specify the number of columns. By default it is responsive and depending on the size of the cards it will fill the available space.&nbsp; How do you set the nr of cards from list view and control how many cards you want to display per line22.08.2022 07:08
Another observation: the sql query from the calendar, it does not submit the "page items to submit". I have to put in a dummy action (PL/SQL null;) to submit the variables. Either I am hopeless and clueless or the plug-in is buggy like hell. FOEX calendar how to move to another year on a DA19.08.2022 05:08
Yeah I thought this would be the case. The other option is to define the field as date or number with format mask and set field to read only then defines css to remove border from field. Anyway multiple options. Thanks FOEX Display field does not honour format mask01.08.2022 04:08
In the most simple form I give it a static value Tried DA, same thing. If it is defined as a number field it works. fx_ws_1963, app 301, page 3 to fiddle FOEX Display field does not honour format mask28.07.2022 13:07
Oh problem solved. Need to cast dates to timestamp SELECT &#39;ABC123&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS ID &nbsp; &nbsp; &nbsp;, &#39;DEF456&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS CALENDAR_ID &nbsp; &nbsp; &nbsp;, &#39;Appointment&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS EVENT_TITLE &nbsp; &nbsp; &nbsp;, cast(sysdate as timestamp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS START_DATE &nbsp; &nbsp; &nbsp;, cast( (sysdate+1) as timestamp)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS END_DATE &nbsp; &nbsp; &nbsp;, &#39;Some notes ...&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS NOTES &nbsp; &nbsp; &nbsp;, &#39;Vienna, Austria&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS EVENT_LOCATION &nbsp; &nbsp; &nbsp;, &#39;https://www.tryfoexnow.com&#39; AS EVENT_URL &nbsp; &nbsp; &nbsp;, &#39;true&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS IS_ALL_DAY &nbsp; &nbsp; &nbsp;, &#39;true&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS REMINDER &nbsp;FROM DUAL Calendar errors on load25.07.2022 08:07
In the demo ground I get other errors , Uncaught TypeError (reading &#39;gettime&#39;) workspace fx_ws_1963, app 300 page 22 Steps I did&nbsp; - create foex page - add region calendar (accepts all defaults) including default query - run page SELECT &#39;ABC123&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS ID &nbsp; &nbsp; &nbsp;, &#39;DEF456&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS CALENDAR_ID &nbsp; &nbsp; &nbsp;, &#39;Appointment&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS EVENT_TITLE &nbsp; &nbsp; &nbsp;, sysdate &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS START_DATE &nbsp; &nbsp; &nbsp;, sysdate+1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS END_DATE &nbsp; &nbsp; &nbsp;, &#39;Some notes ...&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS NOTES &nbsp; &nbsp; &nbsp;, &#39;Vienna, Austria&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS EVENT_LOCATION &nbsp; &nbsp; &nbsp;, &#39;https://www.tryfoexnow.com&#39; AS EVENT_URL &nbsp; &nbsp; &nbsp;, &#39;true&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AS IS_ALL_DAY &nbsp; &nbsp; &nbsp;, &#39;true&#39; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AS REMINDER &nbsp;FROM DUAL Calendar errors on load25.07.2022 07:07
I have a solution which works but may not be the right/elegant way. I define in the form region a hidden dummy field. In the window with the grid I define a DA FOEX Grid - Data Changed not yet saved and assign a value to the dummy field. This marks the form as dirty and we are good. The strange thing in my page is that I have set "Warn on unsaved changes" but when I close the window with the grid it ignores that there are unsaved changes. I need to investigate this further. How to force check for unsaved changes in form which opened a window where changes were made08.07.2022 12:07
No that is not the behaviour they want. They want to be able to close the window and the Save is handled on the form. But then when the form is closed (page 3) they want the page to check that the grid has outstanding changes. The form and grid become a single logical transaction. How to force check for unsaved changes in form which opened a window where changes were made08.07.2022 11:07
Definitely the FOEX Message Execute DA on System message box &quot;Warning you have unsaved changes&quot; when clicked NO08.07.2022 10:07
No not that that I can think of at this stage.&nbsp; Calculate cell based on change from other cell25.05.2022 23:05
My bad I missed the difference between row and cell editing mode. All good. Calculate cell based on change from other cell25.05.2022 00:05
The Delete button on a form and a Grid, but I might as well throw in the Tree Grid too. What would be nice is when you select at Database Action - SQL DELETE action that you get a field "Delete message" and you can specify your own message with support for&nbsp;Substitutions: Application, Page Items and System Variables. How to individualize the &quot;Do you want to delete message&quot; on click of the DELETE-Button (again)12.04.2022 00:04
I sorted it out. It is working ok now. File upload using file browse plugin errors12.12.2021 12:12
The record has been successfully updated. Simple master detail, click apply changes always shows success message even nothing has changed05.11.2021 09:11
It is the form Simple master detail, click apply changes always shows success message even nothing has changed05.11.2021 07:11
The patch still has the wrong&nbsp;com_foex_plugin_foex_settings.sql Discard changes configuration missing in release 21.122.10.2021 02:10
When can we expect this. We need to let the testers loose on our 21.1 validation environment, so we can decide to upgrade the development environment. We did find some issues with layout of regions, but it is easily corrected. (yes we did everything as per installation manual). Will report this separately.&nbsp; Discard changes configuration missing in release 21.119.10.2021 23:10
I know and I am as bad at testing as you. ;-) Detecting unsaved changes with extended search13.10.2021 08:10
It clears the grid before testing the changes Detecting unsaved changes with extended search13.10.2021 08:10
I fail to see the relevance. That is on-demand loading. Detecting unsaved changes with extended search13.10.2021 08:10
That was a good idea, but it does not quite work as we hoped. The problem is that the before load event is timing wise too late. When you are in the extended search and enter a string and hit enter or tab, it clears the grid, then shows the Unsaved message. That is too late. Detecting unsaved changes with extended search12.10.2021 11:10
Nope. Tried it. Well enhancement request to satisfy dumb and blind people with no brain either. Ugh Turn auto correction&#x2F;finishing off on a date field07.10.2021 10:10
Can&#39;t I "overwrite/overrule" in Additional Config either? Turn auto correction&#x2F;finishing off on a date field07.10.2021 09:10
Wohoo that works great. Force marking form as changed21.09.2021 14:09
That is interesting I&#39;ll see if I can use that. In one other place I actually do some trickery stupid stuff on key down event to force a change in the form. It works but is not very elegant. This might be a better solution if it works. Force marking form as changed21.09.2021 13:09
I think I can be actually a bit more specific. It only seem to apply to the last field. Other fields when you change and do not tab out of it and click on another tab the change is detected. &nbsp; Force marking form as changed21.09.2021 11:09
Thank you. One day I will remember that one. Ugh. How do I use Content Loader - Before Close event20.09.2021 09:09
I am getting a Javascript error How do I use Content Loader - Before Close event17.09.2021 06:09
If you set it to No the window closes immediately. It has to be set to Yes. I have emailed a video and some additional&nbsp;explanation Suppress browser &quot;Unsaved Changes&quot; window02.09.2021 11:09
LIve on the edge is my motto. Wizard in vertical mode02.09.2021 06:09
Bump Wizard in vertical mode02.09.2021 06:09
Magic! Too easy. I am always surprised how much is actually already handled for you. Thanks! Anyway I went of an interesting path, but did discover a few new things and learned something new. Not the right path, but lets just call it the scenic route. Stop navigating to another Tab when unsaved changed24.08.2021 11:08
Well you proved me wrong. I just looked in the console and did not look in Network. Lesson learned. Thanks! double click and content loader dramas23.08.2021 15:08
ws_1963 App 301 page 2. Run with console and see that Row selection change only&nbsp;executes once double click and content loader dramas23.08.2021 14:08
No. That has been removed. double click and content loader dramas23.08.2021 13:08
Oh, I see. But that would mean it would load twice, once for leaving the row you are on an once for the row you are selecting? I don&#39;t see that happening in the console. double click and content loader dramas23.08.2021 13:08
Yes for database fields it is handled on the server side. In this case the fields are used in a custom search screen which is used by a region which builds the where clause. Uppercase conversion pushes cursor to end of field23.08.2021 12:08
The debounce was set correctly with "Wait for result" and Fire Immediately was not checked. I tried different timings, and other options (just in case). I changed the event to "Row Selection Change" and that solved the issue, but it changed the behaviour slightly&nbsp;that of course when you click on the selected row nothing happens,&nbsp;where as with the Click it would activate the tab again. But your suggestion to use "After Row Select" is in my scenario the same. To be honest I am not sure what the difference is between&nbsp;Row Selection Change and After Row Select. A slight timing difference? Is Row Selection Change executed before After Row Select? But given that APEX executes DA async is it relevant?&nbsp; double click and content loader dramas23.08.2021 12:08
Hmm, to me it is a bug in the plugin. Suggesting to me to add a computation on the server or use a trigger defeats the purpose of this option in the plugin. If this is what you suggest to do , then why enhance the plugin with a transform option in the first place? But you are telling me that the behaviour is intentional? So if you want to add&nbsp;2 characters to the front of the string, you place the cursor at the beginning of the string type two characters , and you see the first character is at the start and the second character is now at the end. You then have to delete the last character, place the cursor after the first character in the string. Wow that is a whole new paradigm on editing a string. Actually&nbsp;set Transformation to No Transformation and put in the Field Style&nbsp;text-transform: uppercase does work, but that is beyond the point. Uppercase conversion pushes cursor to end of field23.08.2021 07:08
Thank you! Can I check when a Tab is closed which had a page loaded with the content loader28.07.2021 08:07
"FOEX SPA Error - URL: f?p=200:95:26920714108400::NO:95:P95_CLI_ID:3268606 Message: {"stack":"Error: You&#39;re trying to decode an invalid JSON String: Duplicate component id \"P95_EPISODES_TOT\"\n &nbsp; &nbsp;at new Ext.Error (https://orabsqrdev.test.health.qld.gov.au:8443/i_bsqrd1/foex/ext/resources/js/ext-all.js?v=20.2.0.4498.00:20:31981)\n &nbsp; &nbsp;at Function.raise (https://orabsqrdev.test.health.qld.gov.au:8443/i_bsqrd1/foex/ext/resources/js/ext-all.js?v=20.2.0.4498.00:20:32383)\n &nbsp; &nbsp;at Object.Ext.raise (https://orabsqrdev.test.health.qld.gov.au:8443/i_bsqrd1/foex/ext/resources/js/ext-all.js?v=20.2.0.4498.00:20:32530)\n &nbsp; &nbsp;at Object.Ext.decode.Ext.JSON.decode (https://orabsqrdev.test.health.qld.gov.au:8443/i_bsqrd1/foex/js/foex.min.js?v=20.2.0.4498.00:7:279)\n &nbsp; &nbsp;at f (https://orabsqrdev.test.health.qld.gov.au:8443/i_bsqrd1/foex/js/foex.min.js?v=20.2.0.4498.00:77:231236)\n &nbsp; &nbsp;at constructor.parseResponse (https://orabsqrdev.test.health.qld.gov.au:8443/i_bsqrd1/foex/js/foex.min.js?v=20.2.0.4498.00:77:233116)\n &nbsp; &nbsp;at success (https://orabsqrdev.test.health.qld.gov.au:8443/i_bsqrd1~" So I am now wondering if what I am trying to do creates the issue somehow. They can open page 95 either/or in a shared tab&nbsp;or in its own tab. As I try to open in "Current Window" could this cause the&nbsp;problem&nbsp;and should I open the "in its own tab" in an iframe? Context Menu Side effects26.07.2021 06:07
great thanks. pop-up calendar refinement date field20.07.2021 06:07
It was actually even simpler.&nbsp; Just remove or add the class&nbsp;x-form-item-label-required No need to define my own class. Thanks! Can you add a class and remove a class dynamically from a label19.07.2021 12:07
  • 1 - 50