User Info

Vince

Name:

Website:

Location:

Last Seen:

Jan 20th, 2016

Description:

 

Avatar

VI

95 Questions

ThreadPostedQuestion
FOEX Content Loader - Page Loading Question22.02.2016 15:02 Hi ! When we are using the FOEX Content Loader plugin, I noticed that there is a Loading Mask (which says "Page Loading...") that appears. This is not the one configured into the Page Template. When I load a small 100% APEX page in it, I can see the page being shown, but the Loading Mask is there for like 2seconds, and I am not sure that something is going on, since nothing happens in the Chrome Network debug.. Is there a way to remove the "Page Loading..." when loading a page with FOEX Content Loader since the page seems to have finished loading? Thanks!
FOEX Grid - Cannot search on a Popup LOV column19.02.2016 14:02 Hi! We have a FOEX Grid, which has query that a retrieves 40,000 rows. In the search plugin of the Grid, if we choose to search only on "Display as Text" columns, the search is being done. But, if we select one column "Popup LOV" in the search columns (The query behind the Popup LOV is not big..) the grid does not retrieves the information and we receive a "Exception - communication failure" error. Why? Thanks!
FOEX Grid - Checkbox value is lost upon page change17.02.2016 16:02 Hi !! Let's say I have a FOEX Grid which has a checkbox as a column. The grid displays 25 records at once, and is separated by pages. If I check one checkbox and then go to the next page of the grid, when I come back to the first page, my checkbox is unchecked.. Is there something we can do about it (Implying we want to keep the pages)? Thanks!
FOEX File Browse - Error when updating more than one at once16.02.2016 16:02 Hi !! We noticed that there is a problem when having more than one "FOEX File Browse" item and we try to update them at once. We receive the following error: An error occurred whilst uploading the file. File: Error: ORA-00001: unique constraint (APEX_040200.WWV_FLOW_COLLECTION_MEMBERS_PK) violated ORA-06512: at FOEX_020101.FX_P_FILE_UPLOAD, line 1179ORA-06512: at FOEX_020101.FX_P_FILE_UPLOAD, line 1981 In our scenario, we have three File Browse item and when we modify more than one at once and we are executing the Update on the FOEX Form, we have the error. It is working fine if we update one BLOB and then Save.
FOEX Grid - Cannot Create since Hot Fix02.02.2016 13:02 Hi !! I have a strange problem.. It seems that with the latest Hot Fix, we cannot create a line in a FOEX Grid, when we are in French? I was not able to reproduce the problem on my FOEX workspace.. :/ Here how I could reproduce it in our dev environment.. Create a new grid Add a number item in the grid Cell Edit Mode (Did not test Row Edit Mode though..) For the number field, select a Default Type = PL/SQL Expression and 1 as the default value Run the grid, and when pressing the Create button, we receive an empty Message Box "Erreur" (Which means Error) and nothing happens It does not happens when we are in English.. Maybe it has to do with the fact that in French the decimal is separated with a "," and not a "." ? And when we test the same grid in our environment without the hotfix, it is working fine..
FOEX Popup LOV - Not working when there is a carriage return in description28.01.2016 13:01 Hi !! When we have a FOEX Popup LOV and the description contains a carriage return, we receive an Invalid Number error from the database when saving because the value of the item in the session state is not the "return value" but the description. Thanks!
FOEX Content Loader (Browser Window)26.01.2016 17:01 Hi !! I have an issue with the action "FOEX Content Loader (Browser Window)". I am using a custom URL (like www.google.ca ) The target is _blank and I did not choose any Affected Element. When I execute the action, nothing happens and in the Developer Tool I have the following error: record.id.indexOf is not a function I tried to reproduce the problem in my workspace and I did not achieve it.. Do you think there is a reason why I have this error? Thanks!
Collapsed Region; Loaded on Demand18.01.2016 21:01 Hi !! Let's say I have two FOEX Grid region in a VBox. The first region is shown when the page is rendered and the second region is collapsed when the page is rendered. Is it possible to have the second region to be executed only when the region is expanded? Thanks!
FOEX Form/Grid - Number Format14.01.2016 13:01 Hi !! What would be the best way to format a number so the information is shown with two decimals? Let's say the field's value is 5; I want the value to be shown as 5.00 If the field is in a Form (Number Field, Text Field, Display Field, etc...) or if the field is in a Grid, how it can be done ? Thanks !!
APEX Interactive Report - Action Menu with FOEX07.01.2016 16:01 Hi !! There is a problem with the Actions Menu when using an APEX Interactive Report on a FOEX Page. I created a test case in my workspace: FX_WS_476 / 448 / 8945 and 8946 8945 is using a FOEX page template and 8946 is not. If you click on the Action Menu in page 8945. you will notice that the sub menu (that appears when the cursor is on "Rows Per Page") is being opened over the menu. If you do the same with the page 8946, you will notice that the sub menu appears on the right of the menu. Is there a workaround and/or a fix to make it work? Thanks!!
FOEX Grid - Sort Insensitive05.01.2016 14:01 Hi !! I would like to know, when using a FOEX Grid, if it is possible have an insensitive sort for a column? Thanks!
FOEX Grid - Filter18.11.2015 16:11 Hi !! In a FOEX Grid, a user can click on a Header column and put a filter. Is there a way that we can set a default filter when the Grid is loaded? Thanks!
FOEX Text Field vs FOEX Display Field03.11.2015 18:11 Hi !! We have a requirement and we would like to know what would be the best way to acheive it. Let's say we have a form that has some fields that are displayed only; those fields are Database Column and depending on the value of another field, those fields can be modified (They need to be saved in the database). The fields that are Database Column are saved as a Number in the database, but we want to show the description to the user (the internal number is not shown in the page). We could not use the FOEX Display Field in this case, since the value is not transfered to the database when saving. Also, when we refer a FOEX Display Field (PL/SQL Block for example), the returning value will be the description; not the internal number. We do not want to have a FOEX Display Field for the description and a hidden item that contains the internal number from the database (We want to use as less as possible page items) In some of our pages, depending on a parameter, some fields are editable and sometime they are read-only. When they are read-only, we want them to look like a FOEX Display Field and when they are not, we want them to look like a Textfield, Popup LOV, Autocomplete, etc.. So, we came up with an idea; we created a read-only css that removes the border of the read-only fields. In this case, we created some read-only FOEX Text Fields and FOEX Popup LOVs. This solution is nice because the FOEX Popup LOVs allow us to have a Database Column field that shows the description to the user, saves the value into the database and we just have to switch the read-only property so it look like a Popup LOV or a Display Field, even at runtime. The problem that we have, is that since the fields are Text Field or Popup LOVs, they will never be on multiple lines (like a real FOEX Display Field). We were wondering what would be the best practice for this? Is there something we can do to acheive this? Thanks !
FOEX Grid - Hide Search Plugin Dynamically01.10.2015 18:10 Hi !! I was wondering if it possible to hide the Search Plugin on a FOEX Grid at runtime? Is there a Javascript expression that I can use on the region to hide/show it? Thanks a lot!!
FOEX 2.1.0 Makes the Tab Switch Plugin Fail28.09.2015 23:09 Hi !! I noticed a problem with the Tab Switch plugin that was working fine with FOEX 2.0.1 I created a testcase: FX_WS_476/448/4748 If you press the button; the Tab Switch doesn't work because I entered a region ID. If you enter a number (Tab position) it is working fine.. Thanks !!
How to remove a field's border with CSS?24.09.2015 17:09 Hi !! Let's say I have a FOEX Popup LOV and I want to remove the field's border (when it is Read Only); so it has the look of a FOEX Display Field. I tried to put my class (which contains "border:0px !important;") on the different ExtJs cls properties, but none seems to work.. Is there a property I can use so I can remove the border on my field? Thanks!!
apex.initXXXXX error with two FOEX Windows in a Page with Cache17.09.2015 18:09 Hi !! We have a really strange issue that appears for an unknown reason. We have a page that can be opened by different pages. Sometimes, when we open the page, it remains stuck on the loading icon; the error in FireBug is like "apex.init is not a function." And from that moment, we are unable to enter the page until we use the FOEX clear cache procedure for the application.. It seems like the problem is related to the Cache; since we did not have this problem in our development environment (the cache is disabled), but I managed to reproduce it with the cache enabled. I took a look at the script which was in error.. and here's what I found: I think that the problem seems to be caused by the fact that I have two FOEX windows in my page. I noticed in the script that when a FOEX Window is created, the javascript looks like this: apex.init132888306738915902 = function() { Ext.create("Ext.foex.Window", {"id":"R132888306738915902","layout":{"type":"fit"},.... with all the properties of the window BUT If I look at the apex.initNUMBER which correspond to the number that I have, I noticed that the function is the following: apex.init161650707038116917 = function() { Ext.create("Ext.foex.Window", )}; Seems like there is no properties generated! Hence why it is not working.. If I set a condition of Never on the FOEX Window, the page runs fine. I have not been able to reproduce the problem on my FOEX Workspace.. :S Maybe it is something that has been fixed in 2.1.0 ? Is there something in the cache that could interfere with the IDs when generating a window? Thanks!!
FOEX Display Field - Problem when refreshing the field based on a LOV01.09.2015 14:09 Hi ! I created a test case: FX_WS_476 / 448 / 5999 Here's the problem: I have a FOEX Display Field with property "Based On" : "Display Value of List of Values". The field is based on the FX_T_DOC_STATES table and it has the 'CA' value (which is California). If you run the page, you will notice that the field displayes "California", which is good.. BUT, if you press the button Refresh (which is doing a FOEX Action - Refresh on the display field), you will notice that the field will show 'CA' instead.. It seems that when doing a Refresh on a display field, it does not display the description. Thanks !!
Error apex.init is not a function with conditions13.08.2015 20:08 Hi !! I created a test case; FX_WS_476 / 448 / 5154 I got a "apex.init is not a function" error when running this page. The problem happens when I am referencing a page item in the condition of a region. In this case, region vtest1 has a condition on P5154_FLAG page item, which is causing the problem... why ? Thanks !!
FOEX Message Box Plugin - Title not Translatable10.07.2015 19:07 Hi !! We noticed that for the FOEX Message Box Plugin; Title component is not included in the XLIFF. (ie.: Not translatable) Is it possible to switch the value so that the value is defaulted at Yes ? Thanks!! :)
FOEX Grid Set Column Value on Column Change - Crash with to_number07.07.2015 16:07 Hi !! I created a test case; FX_WS_476 / 448 / 8484 In my page, I have a grid with two column. The first column is a Popup LOV and when I choose a value, I am changing the second column with the FOEX Grid Set Column Value on Column Change Action. You will notice the problem if you do the following steps: - Click on the first column of the first row - Press "R" and wait for the list to come up - Click on one of the entry (You will notice that the description appeared on the second column) - Here, everything is fine, no error.. We will do the same again for the second row - Click on the first column of the second row - Press "R" and wait for the list to come up - Click on one of the entry - Notice the error message (ORA-01722: invalid number) The problem is caused by the fact that I am using a to_number in my SQL Query of the True Action for the trigger value AND the description that I choose is character.. Here in the office, we really need to use a to_number and we receive this error when we are choosing a value that has a character description (it works fine if we have a numeric description). It seems like the description is sent as the Trigger Value.. Thanks!!
FOEX Grid - Add tooltip on column header for long label05.06.2015 12:06 Hi !! I was wondering if it is possible to have a tooltip on a column header of a FOEX Grid? I would like the tooltip to show the complete column header label IF the header size is too small for the content. That way, the user does not have to expand to column header to see the column header label. Thanks!
FOEX Checkbox (Simple) - Field not in the translation03.06.2015 13:06 Hi !! We noticed that, for a FOEX Checkbox (Simple), the field "Display Label" is not included in the translation when exporting the xliff of the page. Is it possible that the value of this field could be exported? Thanks!!
FOEX Grid - How to link Additional Config property to an Apex LOV ?01.06.2015 14:06 Hi !! I have a special case in a FOEX Grid, and I don't know what would be the best solution. My problem is that, for a FOEX Grid in cell edit mode, I want to be able to change the column type (xtype) depending on a value in another cell. I can get this done with the "getEditor" property.. BUT, I have a problem because one of the column type that I want to chose is a Combo Box which is linked to a Apex LOV.. How can I achieve this? Here's an example of the code that I am using at the moment (sorry for the bad indentation): "getEditor": / / function (record) {var fieldType; if (record.get('DUMMY3') == 2){ fieldType = 'foextextfield'; } // I WANT TO HAVE A COMBO BOX LINKED ON AN APEX LOV else { fieldType = 'foexnumberfield'} return Ext.create('Ext.grid.CellEditor', {field: {xtype: fieldType, allowBlank: false} }); }/ / So in this case, when the field's value = 2, I would like to show a combo box (or APEX Select List) based on an APEX LOV.. Thanks!
FOEX Popup LOV - Error when switching Tab (Content Loader)21.05.2015 15:05 Hi !! We noticed a problem with the FOEX Popup LOV plugin, I created a test case, so it is easier to see! :) Workspace FX_WS_476 / 448 / 5152 (5151 is the one with the problem though) Run the page 5152 Press the button in the top left section Enter a value like "iiiiiiii" in the Popup LOV field (do not unfocus the field) Press on the "Placeholder Page" Tab You will notice the following message: "AJAX call returned server error ORA-01722: invalid number for Set Value." The problem happens because I have a Set Item DA (onChange of the Popup LOV) that refers my Popup LOV value in it. I think that the problem is that since I change the Tab, the plugin does not have the time to process the information to validate if the value is valid or not. And then pass the "iiiiii" value to the SQL query, which gives an error. Thanks!
FOEX Actions - Set Items, Problem with child pages?08.05.2015 15:05 Hi!! I am not sure, but I think the dynamic action FOEX Action - Set Items - "Set page items values on child pages" property is not working properly. I created a test case!! FX_WS_476 / 448 / Pages: 3100 - 3101 - 3102 Run the page 3100, press the button and page 3101 will open. From page 3101, you can open page 3102 with two different context (Current or Parent page). If you open 3102 from the Current Page context, you will notice that it is possible to affect the value of the field. (The value of the field in the page 3102 will be affected to the item in the page 3101) BUT, if you do the same but you click to open page 3102 in the Parent context, it is not possible to affect the value, why? I thought that setting the "Set page items values on child pages" property to "Yes" in my action would solve my problem, but it does not work. Also, I noticed something strange. If you set "Set page items values on child pages" to 'Yes', you will notice that the Set Items will not work anymore when opening the page in the Current Context (even if the "Set page item values on parent pages?" property is still set to 'Yes'). This is important for us, because we have some pages that are shared at different places in our application (they are used to return information) and we are using those pages in different contexts; sometimes Current and sometimes Parent depending of the caller. So, we would need that the "Set Items" works for both of the case. Thanks!!
Translation issue with Processing Procedure Override05.05.2015 19:05 Hi ! When we are exporting a page's XLIFF, we noticed that the value of the property "Processing Procedure Override" is included in the XLIFF file. Is there a way to avoid having this value into the XLIFF file? Thanks!
FOEX Grid - Refresh the Search Column's Title04.05.2015 19:05 Hi !! Let's say I have a FOEX Grid and a radio button on top of the region. The FOEX Grid is based on a dynamic SQL, and when the user changes the radio button value, the Grid is refreshed with a new SQL. Some of the column's "Column Heading" are based on a Page Item value. So, when the radio button value is changed, we are changing the value of the Page Item, and then we execute the dynamic action "FOEX Grid Header Refresh" on the grid to see the new column names. This is working fine, but the only problem that we have, is that when we press the Search button on the top left of the grid, the names are not updated.. Is there a way to update it? In short, we want the equivalent of "FOEX Grid Header Refresh" but that is affecting the columns shown in the Search button so it is consistent with the headers title. Thanks !!
Any way to have a general FOEX Form Alert on Pending Changes?28.04.2015 14:04 Hi !! Since the dynamic action "FOEX Form (or Grid) Alert on Pending Changes" is pretty interesting. We were wondering if there is a possibility to have this feature whenever a Form/Grid is closed? (Closed by closing the browser window, by closing a Tab, by closing a Popup Window, etc.. ) I tried to put it at the "Page Unload" event but it does only seems to be working when the browser page is closed. Is there also a way so it is applied by default on every Form/Grid? Thanks!!
FOEX NumberField - French typo on default maxText21.04.2015 18:04 Hi !! When I am using FOEX in French, there is a typo in the translated sentence when the user enters a value over the maximum (or under the minimum) in a FOEX NumberField. The sentence is: "La valeur maximum de ce champ doit être de " And should be: "La valeur maximale de ce champ doit être de " How can I translate this text? Thanks!
Popup LOVs in Grid (Cell Edit) - Data Problems27.03.2015 14:03 Hi !! In our application, we have using a lot of "Popup LOVs" in Grids and we noticed a couple of problem with this items.. I have created an example on my Workspace: FX_WS_476 / 448 / 1515 I don't have a specific case, since the behavior is not always the same (I think it is caused by the timing).. But we noticed that there is a couple of problem when switching the data a bit too quickly. Here are some cases that I found in my Example: Go to line 2, which is "Avalue", add some character and then quickly click on the line 1, you will notice that line 1 has been modified to "Avalue" When doing it really quickly, if I click on the line 2, completely change the value to some random characters (which obviously does not appear in the list of valid choices) and quickly click on the first line, the invalid selection will be accepted (even if I have the option "forceSelection":true on my cell), and after this moment, the grid is acting really weird (like showing the number value of the field, and not the description, etc..) I noticed that there is always a problem when I click on a cell, begin to enter some data, and while I type some value, I click on a new cell while I am typing. Thanks!
FOEX Tab - Is it possible to change the Tab name after being opened18.03.2015 12:03 Hi ! Let's say I have a Tab that is opened with an Unique ID. I was wondering if it is possible to change the name of the Tab and the Unique ID for the already opened Tab? Thanks!
FOEX Content Loader (Browser Window) - Loading content in a new Browser Tab13.03.2015 19:03 Hi!! I was wondering if it is possible to use the dynamic action "FOEX Content Loader (Browser Window)" to open up a page in my application in a new Browser Tab? Thanks!
FOEX Tree Grid - Hyperlink on a column13.03.2015 18:03 Hi! I tried to put an Hyperlink on a column of a FOEX Tree Grid (Via the Column Link property of the column). When I do so, the data in the column disappears and the column is blank. Are the Hyperlinks supported in a FOEX Tree Grid? Thanks!
FOEX Form Reset - "Exclude Item from Reset" property is not working?12.03.2015 18:03 Hi !! I have made a test case here : WS: FX_WS_476 / App: 448 / Page: 950 I created a FOEX Form with two fields. The Reset button on the Form has an onClick event on it that executes a FOEX Form Reset dynamic action. In my dynamic action, I entered the field "Examplcol" in the Exclude Item from Reset property. Here's my problem: If you enter data in the two fields, and then press the Reset button, why does both fields are resetted? I thought that the Examplecol field would not be resetted since it has been entered in the Exclude Item from Reset property. If this is a normal behavior, how can I exclude a field from resetting? Thanks!
FOEX Pane - Expand Upon Mouse Over04.03.2015 14:03 Hi !! I was wondering if it is possible that a collapsed FOEX Pane can be expanded upon a Mouse Over? I came across an example on the net of an ExtJS solution of the problem, but I don't know how I can implement this in my Application. I made some tests, but it did not work.. ;( Is it possible to make it work, or an update of the plugin is needed? http://jsfiddle.net/3FJ58/9/ Thanks!
FOEX Grid Combo - Does not display "Null Display Value" at startup03.03.2015 20:03 Hi !! I created a FOEX Grid Combo in my page. In the Page Item Properties screen, in the tab "List of Values", I selected "Display Null Value" to Yes and put my default display value. When I run the page, the default display is not shown. But, when I set a value in the field and I clear the value, the default display is shown! It is only not shown when the screen is opened? Why? I tried to clear the field when the screen loads up and I tried to put a ExtJS property (emptyText), but it did not work :(
Disable Tab - FOEX Tree Grid?23.02.2015 13:02 Hi !! I have a page with a couple of Tabs. Most of my tabs are FOEX Grids, but one of my tab is a FOEX Tree Grid. Depending on a condition, I am disabling the tabs. If I am doing a Disable action on a tab that is linked to a FOEX Grid, it works fine; the tab is grayed out. If I do the same on the tab containing a FOEX Tree Grid, it does not work. Is there a reason I can Disable a FOEX Grid but not a FOEX Tree Grid? Thanks!!
FOEX Form - Error when handling large tables/views19.02.2015 20:02 Hi !! We have a FOEX Form based on a very large view (with 60ish columns) and when we call a FOEX Form Action / Create, we receive the following error message: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" We debugged it, and we think that the problem should be in the PL/SQL code that is executed when processing the CRUD. We think this is where the problem is because we do not have the error message when we override the processing AND (with no override) the "instead of" trigger of the view is not executed.. So it tells me that the problem is inbetween the two operations. Is it possible that the variable that is containing the SQL query is not large enough? Thanks!
FOEX Grid Set Column Value on Column Change - Trigger manually?16.02.2015 20:02 Hi! I have a FOEX Grid and in this grid I have a couple of fields. My first field is containing a code and this field is acting like a FOEX Autocomplete; A Popup Key LOV.. My second field is an unbased column that contains the description of the code entered. I used a FOEX Grid Set Column Value on Column Change to update the description whenever the user changes the value of the code. This is working fine and the description is updated depending on the value entered in the code field. The only problem that I have, is that, since the user might need more information than the one shown in the Autocomplete, we are allowing the user to open a new window (with a lot of criteria/information) to find the code that he wants and return the information. I can return the information into the Popup Key LOV Field, BUT, since the value has been changed via a javascript (data.record.set), the "Grid Set Column Value on Column Change" is not triggered SO the description field is not updated. Is there something I can do to trigger the "Grid Set Column Value on Column Change" or do something to achieve the same? Also, I noticed that, if I change the value in javascript, I need to set the return value into "COLUMN_NAME" and to set the display value I need to set it into "COLUMN_NAME"+"_FX", it's normal? Thanks!
FOEX Grid - Use Autocomplete field13.02.2015 15:02 Hi !! I would like to know if it is possible to use the equivalent to a FOEX Autocomplete field in a FOEX Grid? I tried to put the xtype combobox, but it is not the same as the autocomplete.. Thanks!!
FOEX Grid - Allowed operations on a specific field12.02.2015 14:02 Hi !! Let's say I have a FOEX Grid with some fields. My Grid is in Cell Edit mode. I was wondering what would be the best practice for the following cases: One of my field is "Insertable/Updateable" but the rest of my fields in the grid are "Insertable" only. One of my field is "Insertable/Updateable" but only updateable when the field in the database is NULL Thanks!
FOEX Grid Combo - Item dependency10.02.2015 16:02 Hi!! I have a FOEX Grid Combo and I am using a bind variable in the query (Page Items). When I change the value of the Page Item, which is refered in the query, I noticed that the query is not refreshed automatically; I have to press on the Refresh button to have the good values­ showing up. Is there a way that could allow me to refresh the FOEX Grid Combo on demand when the value of the page item is changed? Thanks!!
FOEX Grid - Unfocus a field05.02.2015 20:02 Hi !! I would like to know if it is possible to unfocus a field in a FOEX Grid? I have a FOEX Trigger Field in my FOEX Grid (which is in Cell Edit mode); and when the user press on the trigger button, I would like to put a True Action that unfocus the current field so the Edit Field disappear, is there a way to do it ? Thanks!!
FOEX Grid - Feed Cell from another Window04.02.2015 23:02 Hi! Here's my case: I have a FOEX Grid (in Cell Edit mode) and I have a Customer Number field in it. We would like that the user could either type in the value directly in the field OR he could use a button (like a Grid Row Action for example) to open up a modal FOEX Window so he could do an advanced search (since it is pretty complex, with a couple of option, etc..) to retrieve the customer number that he wants. We were wondering what would be the best way to make the FOEX Window communicate with the Customer Number cell in the grid of the parent? If I am using the Grid Row Action, the problem that I see is that the focus will not be on the Customer Number field, so is there a way to access it to modify it with the value that has been selected in the FOEX Window? Thanks!
FOEX Grid Combo - Exclude search plugin?03.02.2015 13:02 Hi !! I am using a FOEX Grid Combo, and I was wondering if it was possible to exclude the search plugin? Just like a FOEX Grid. I tried to put the same Additional Config that is used in a FOEX Grid ("excludeSearchPlugin":true), but it did not work.. Thanks!!
Timer Plugin?27.01.2015 18:01 Hi ! I was in my FOEX Workspace, to look at the examples concerning the Messages Boxes. (Page 8010) When looking into the dynamic action "Progress Message Box & Execute Task", there is a Timer Plugin that is used. In my development environment, I don't have such Action.. Is it normal? Is there a way I can get this plugin? Thanks!!
FOEX Tree Grid - Changing cells CSS since 2.0 does not work26.01.2015 16:01 Hi !! I am using the following code : .node-to-fix .x-grid-cell-TREE_DETAIL-col-NODE_VALUE { background-color: red !important; color: white; } Before FOEX 2.0, it was working fine, but now it is not doing anything when I return this CSS to a row. I made a test with td {} And it was working fine; All my line was highlighted in color.. So I guess the x-grid-cell- is now obsolete in a Tree Grid?? Thanks !!
FOEX Button - Need to be Fixed in a Stretch Region06.01.2015 15:01 Hi !! I have a Form region that is stretched; all item in the Form expand to cover all the space. The problem that I have is that I want to be able to have a FOEX Button that is not part of the stretch; I want to have a Fixed size for that item only. I have a Text Area and the button is right next to it (a little Edit button that open up a Window); since this button is only an icon, I want it to be fixed. So, is it possible to have a FOEX Button with a Fixed size in a region that is stretched? Also, I would like to wish you an Happy New Year, and keep up the good work!! ;) Thanks!
FOEX Window - Trap the Close Event16.12.2014 18:12 Hi !! I noticed that I can trap the event when the user is closing a FOEX Window (Pop-up) with the following event on the calling screen: "FOEX Window - Close". But I was wondering if it is possible to cancel the Close event under a certain condition? We would like to validate that the user does not have any pending changes, and if he has, ask him if he wants to close the Window or not; but I did not find anything to stop the window from closing.. Thanks !
  • 1 - 50

12 Answers

AnswerThreadCorrect Posted
Hi Matt! I was wondering if this fix will also correct the following problem: With a FOEX Display Field (Display Value of List of Value), when using a "Set Value" on the field, the value shown is the one that has been affected; not the one corresponding to the list of value. Thanks ! FOEX Display Field - Problem when refreshing the field based on a LOV21.09.2015 11:09
Hi !! Any updates on this? I have the exact same problem; When using the "FOEX Form Alert on Pending Changes" event on a button (with FOEX Button - Normal Button Click event), the Alert message appears BUT the DA is not cancelled :S Thanks! FOEX Form - Alert on pending changes followed by further DA's17.09.2015 12:09
Hi !! I was aware of this problem; we fixed it now! Just letting you know of the solution: If anybody has a problem of "Network communication error" when using the File Browse plugin, you need to check if you have a Global Page (Page Zero) in your application. If yes, be sure that any region in this page has this Condition: "Current Page Is NOT in Expression 1 (comma delimited list of pages)" and Expression 1 = 57565 Thanks! Error "Network communication failure" when save uploaded image file08.05.2015 17:05
I found it! :) It is the Oracle Plugin "Timer" that can be downloaded on the Oracle website. Thanks! Timer Plugin?27.01.2015 18:01
Interesting, we have the same problem when multiple users use the application at the same time. We turned off the caching for now, but we never had this problem before FOEX 2.0 FOEX 2 caching26.01.2015 16:01
Hi Matt, The example is working fine, but I have a question regarding this. When you are using the "FOEX Action" to set the value, how can I pass some parameters? The problem that I have is that I need to put "," in the URL value to separate the parameters, but the Set Items thinks it's a value for another page items so the value is truncated before the first comma.. Is there something I can do to make it work?? Thanks!! Open Window in parent page24.09.2014 15:09
Any updates on this ?? We have the EXACT same problem when trying to put more than one validation in a FOEX Form. In the alert log I got the same qercbiQBCompare() error We are running on 11.2.0.1.0 Is there a version after 11.2.0.1.0 that is known to be working? AJAX communication failed when using multiple validation03.06.2014 17:06
Hi Matt !! Thanks for the reply, with it, I managed to have a solution. I created the following js: function oneCheckBox(v_grid_id, v_checkbox_id) { var nbCheckBox = 0; var grid = Ext.getCmp(v_grid_id); if (grid) { grid.getStore().each(function (record) { if (record.get(v_checkbox_id) === true ) nbCheckBox += 1; }); } if (nbCheckBox === 1) { return true; } else { return false; } } I used this function in the JavaScript expression of my Save button (Click Event) and I throw an error message when it is returning False. Thanks! FOEX Grid - CheckBox; One and Only One25.03.2014 14:03
I got a reproductible case! You can check out Pages 54 (Working) and 55 (Not Working) on: Workspace: FX_WS_476 Application: 456 When there is one column that is freezed in a grid; the grid row action stops working. FOEX Grid Row Action / Problem: Stop working!19.12.2013 13:12
I got FF25 on Win7. Peter, you tried with my example on my workspace and scrolled down to the last record? (Be sure that the "Rest of the Grid" got a vertical AND horizontal scroll bar) And the freeze section was synchronized with the rest of the grid? All the users here have the problem.. Jaganbreddy, I retried with Chrome, and you are right, it is not working with Chrome.. (on Win7) FOEX Grid - Freeze Column / Desynchronization of the line17.12.2013 19:12
Hi Matt, With the new configuration, I do not have the error message anymore. But, I made a test and it is not working.. I have done an example on my FOEX workspace.. you can take a look Workspace FX_WS_476 / Application 456 / Page 7 I put the FOEX Text Field in a Toolbar (like in my real example) and I used the OnLoad trigger to execute the SetLabel, and the label for my item at runtime is still showing the default label; not the dynamic one.. Thanks ! FOEX Text Field - Dynamic Label29.11.2013 14:11
Hello Peter, It is working fine with the solution ! :) Thanks a lot!! FOEX List view - Content Loader12.11.2013 20:11
  • 1 - 12

123 Comments

AnswerThreadPosted
Thanks for the answer, it would be nice to omit the load mask; Is it something that can be included in the next hotfix due out soon? :) FOEX Content Loader - Page Loading Question24.02.2016 14:02
Thanks a lot! FOEX Grid - Cannot search on a Popup LOV column22.02.2016 12:02
Number of Rows: 25 / Maximum Row Count: 26 FOEX Grid - Cannot search on a Popup LOV column22.02.2016 12:02
Sorry for the delay; yes indeed, the hot fix was not correctly installed! Sorry for the trouble.. Thanks a lot !! FOEX Grid - Cannot Create since Hot Fix04.02.2016 17:02
2.1.1.2184 for both English and French versions I will send you the HTML code via mail FOEX Grid - Cannot Create since Hot Fix02.02.2016 15:02
... Error: ORA-20001: JSON Parse Error: Grid Set Session State for Submit Items Error Text: ORA-20101: JSON Parser exception @ line: 1 column: 2 - Expected string or } JSON: {0.4950412844773382} ... Back Trace: ORA-06512: à "FOEX_020101.FX_P_UTILS", ligne 1919 ORA-06512: à "FOEX_020101.FX_P_GRID", ligne 6142 Stop APEX Engine detected FOEX Grid - Cannot Create since Hot Fix02.02.2016 13:02
.. JSON Parse Caller: Grid Set Session State for Submit Items ... JSON String: {0.4950412844773382} ... Error Text: ORA-20101: JSON Parser exception @ line: 1 column: 2 - Expected string or } ... Back Trace: ORA-06512: à "FOEX_020101.JSON_PARSER", ligne 461 ORA-06512: à "FOEX_020101.JSON_PARSER", ligne 628 ORA-06512: à "FOEX_020101.JSON_PARSER", ligne 649 ORA-06512: à "FOEX_020101.JSON", ligne 13 ORA-06512: à "FOEX_020101.FX_P_UTILS", ligne 1908 ... Proc/Func: FX_P_GRID.ajax FOEX Grid - Cannot Create since Hot Fix02.02.2016 13:02
And APEX 4.2 FOEX Grid - Cannot Create since Hot Fix02.02.2016 13:02
http://tryfoexnow.com/i/D363987425/HFXP-2228.zip FOEX Grid - Cannot Create since Hot Fix02.02.2016 13:02
I have a test case; FX_WS_476 / 448 / 7070 You can run the page, select the value and press Create. You will have the Invalid Number error. The value has a carriage return at the end FOEX Popup LOV - Not working when there is a carriage return in description29.01.2016 20:01
I have some problem creating data with the APEX SQL Workshop with a carriage return.. But, yes, secure values = Yes. The test is relatively easy to reproduce; create a table with a key / description, have a carriage return in the description, base a LOV on that new table, create a form that has a field based on that LOV, select the value with a carriage return and save the form FOEX Popup LOV - Not working when there is a carriage return in description29.01.2016 14:01
This email I was referring FOEX Content Loader (Browser Window)26.01.2016 18:01
You can download the hotfix here: http://tryfoexnow.com/i/D363987425/HFXP-2228.zip Please find the installation instructions and the list issues addressed enclosed within the README.pdf file. If you have any plugin usage questions could you please log them on our Forum at http://forum.tryfoexnow.com/osqa and send sensitive questions/problems via Email to support@ tryfoexnow.com FOEX Content Loader (Browser Window)26.01.2016 18:01
Hi Vincent, We would like to inform you of the latest hot fix that is available for v2.1.1 of the FOEX Plugin Framework. If you have not yet installed v2.1.1 you can now download the updated full release which includes the fixes and does not require the application of the hot fix, using the following link: http://tryfoexnow.com/i/F0F5A56BCB77FE1AE040007F01007EB1/foex_v2_1_1.zip Please find the installation instructions and Release notes enclosed within. If you have previously installed v2.1.1 please install the hotfix separately. FOEX Content Loader (Browser Window)26.01.2016 18:01
This is exactly what I noticed.. The problem was that in the mail that you sent us, you said that the hotfix was included in the full release of 2.1.1 We installed the full release of 2.1.1 (since it was not installed yet), but it seems that the hotfix was not included. FOEX Content Loader (Browser Window)26.01.2016 18:01
Hi! We have two environments with different FOEX versions; one with 2.1.0 and one with 2.1.1 The same page in 2.1.0 is working well (Popup LOV, LOV Mode: Remote); the list is all shown BUT in our environment with 2.1.1, the list only show the current selection.. Why ? Popup LOV - List of values20.01.2016 20:01
FX_WS_476 / 448 / 6868 As you can see, I have Grid1 and Grid2. Grid2 is collapsed by default (Additional Config) and "Loading Grid Data" = "Load when Grid is shown". I just want to be sure that the data is loaded ONLY when the grid is expanded; and not when the page is loaded. By the way, Grid1 and Grid2 have the same query; There seem to have a problem when trying to expand Grid2.. There is no data shown when expanded.. Collapsed Region; Loaded on Demand19.01.2016 13:01
Any updates on this? We have a lot of additional config and we would like to keep after updating FOEX.. keep custom additional config on plugin after an upgrade ?15.01.2016 16:01
Thanks a lot!! ;) APEX Interactive Report - Action Menu with FOEX11.01.2016 12:01
Thanks a lot Matt! ;) We had a LOV which returned a Number.. hence why it was not working!! FOEX Grid - Sort Insensitive05.01.2016 17:01
Hi Matt! We are using Chrome v. 47.0.2526.80 m popup Lov on Grid column with null value issues11.12.2015 12:12
Hi!! ;) Do you have any updates on this? We have the same problem and we would like to know if a fix is coming Thanks! ;) FOEX Grid searching26.11.2015 13:11
Thanks a lot Matt! ;) FOEX Grid - Filter19.11.2015 12:11
Excellent Matt! ;) Thanks a lot !! FOEX 2.1.0 Makes the Tab Switch Plugin Fail30.09.2015 11:09
I updated the test case; I am using a custom event that receives the region ID and do a Tab Switch based on the received ID. In my example, it should switch to the Tab #4.. If I pass a value like '1', it is switching to Tab #2, so this is working; it just seems like the Static ID does not work.. Thanks !! FOEX 2.1.0 Makes the Tab Switch Plugin Fail29.09.2015 12:09
Hi Matt !! Sorry, I guess this is only a bad luck that the region type that I choose for the test was not working!! :P Alright, so, the reason why I logged this problem, is because I have a case in our application that was working fine pre-2.1.0, and now it is not working anymore. I recreated the case to be similar to what we have in our environment, and I found out that it is not working. FOEX 2.1.0 Makes the Tab Switch Plugin Fail29.09.2015 12:09
Excellent! ;) Thanks a lot Matt for the explanation; it is working wonderfully! :) How to remove a field's border with CSS?28.09.2015 12:09
Hi Matt !! Thanks for the answer! If you go see FX_WS_476/448/4033 The first two fields have the same setup; they use the class readOnlyInputs2 and they are Always Read-Only.. As you can see it is working fine for a FOEX Text Field, but it is not working with a FOEX Popup LOV; is there a reason? Thanks a lot !! How to remove a field's border with CSS?25.09.2015 13:09
Let's say I have a Page Item that is based on a LOV of cities; If the source is 'CA', it will show California, for example, which is fine. BUT, if I use the dynamic action "Set Value" on the field with value NY, the field will show NY, and not New York. FOEX Display Field - Problem when refreshing the field based on a LOV21.09.2015 16:09
Hi Matt! I was wondering if this fix will also correct the following problem: With a FOEX Display Field (Display Value of List of Value), when using a "Set Value" on the field, the value shown is the one that has been affected; not the one corresponding to the list of value. Thanks ! FOEX Display Field - Problem when refreshing the field based on a LOV18.09.2015 17:09
AHhhhh Nevermind! I just saw that it is fixed in 2.1.0 with this: FXP-1855 Alert on pending changes is missing "Wait For Result" and should cancel TRUE actions when pending changes exist Thanks a lot !!! FOEX Form - Alert on pending changes followed by further DA's17.09.2015 12:09
2.0.1, is it something that is fixed in the latest version? FOEX Form - Alert on pending changes followed by further DA's17.09.2015 12:09
Excellent!! Thanks a lot Matt! FOEX Display Field - Problem when refreshing the field based on a LOV03.09.2015 17:09
session state, it returns null Error apex.init is not a function with conditions14.08.2015 15:08
Hi Matt !! Yes, in our development environment, the problem still occurs! :S The problem still occurs even with the workaround! :S This is some strange issue.. even more knowing that now it is working in the FOEX workspace.. I have a question regarding the first answer; I understand what you meant with the session state value.. but still.. EVEN if the value was not stored in the session state, I think that APEX would only put the value to NULL for the bind variable, and not crash the entire page.. It is possible to put any bind variable in PL/SQL, but if not found in Error apex.init is not a function with conditions14.08.2015 15:08
Thanks for the answer Matt! ;) Is something changed in the workspace regarding this? I just can't reproduce the problem at all now! I even created a new page (5155), I have done the same steps, and it is working.. why? I got a condition based on a page item which has not been explicitly set into session state, and it is working.. Thanks! :) Error apex.init is not a function with conditions14.08.2015 12:08
Hi Matt !! Do you think this will make it into the next FOEX version due out soon? Thanks ! Popup LOVs in Grid (Cell Edit) - Data Problems12.08.2015 15:08
Excellent!! :) Thanks a lot Matt !! FOEX Grid Set Column Value on Column Change - Crash with to_number08.07.2015 12:07
When I made my case, I did not select the same search value twice.. As for the workaround, the problem that we have with this solution is that the user cannot just type the value and then press Tab (The event will not be triggered in that case). Do you think the fix for would be included in the next release? Thanks!! FOEX Grid Set Column Value on Column Change - Crash with to_number08.07.2015 11:07
Alright good! I'll keep you posted on this.. Thanks! FOEX Grid - How to link Additional Config property to an Apex LOV ?01.06.2015 17:06
Nice! :) Thanks a lot Matt ! FOEX Actions - Set Items, Problem with child pages?11.05.2015 11:05
Excellent! :) Thanks Matt! Translation issue with Processing Procedure Override06.05.2015 11:05
That's excellent news! :) Thanks a lot Matt! FOEX Grid - Refresh the Search Column's Title05.05.2015 11:05
The Tab ID is important in our case because we are using the Tab ID to set the focus if the Tab is already opened. If the user is querying an existing Establishment, we are creating a Unique ID with the primary key in it, SO, if the user is requerying the same Establishment, it will set the focus on that Tab instead of reopening the same Tab. BUT, if the ID is not changed, the "New Establishment" tab will still contain the Unique ID of the previous value. (before reset) So, if the user tries to reopen the previous Establishment, it will set the focus on the Tab with resetted information FOEX Tab - Is it possible to change the Tab name after being opened18.03.2015 13:03
Hi Matt! Here how we are doing in our application: Let's say I can manage Establishments. The user can either create a new Establishment or query an existing Establishment. When he is creating a new Establishment the Tab is named "New Establishment" When he is querying an existing Establishment the Tab is named "Establishment #EstablishmentNumber" In the page, there is a button used to "Save and Create Another" which will save the information and Reset the Form. It is when the Form is resetted that I want to change the Tab Name and Tab ID. (Back to "New Establishment") FOEX Tab - Is it possible to change the Tab name after being opened18.03.2015 13:03
Hi Matt! I confirm that this workaround works very well! Thanks a lot for all the help and the quick responses!! FOEX Content Loader (Browser Window) - Loading content in a new Browser Tab16.03.2015 19:03
Wonderful!! :) Thanks a lot Matt for your support!! Really appreciated! FOEX Tree Grid - Hyperlink on a column16.03.2015 13:03
Hi Matt! :) Workspace: FX_WS_476 / Application: 448 / Page 953 I made a little test case, am I doing something wrong? I can't make it work :( I created a button that uses the Content Loader (Browser Window) and it does not seems to do something.. Thanks! FOEX Content Loader (Browser Window) - Loading content in a new Browser Tab16.03.2015 13:03
Workspace: FX_WS_476 / Application: 448 / Page 952 As you can see in the Tree Grid, VTEST0 and VTEST1 are the exact same column, but, VTEST1 is an hyperlink. If you execute the page, you will notice that there is no data shown in column VTEST1. Thanks! FOEX Tree Grid - Hyperlink on a column16.03.2015 12:03
Cool! ;) Thanks a lot Matt!! Bug with Popup LOV (and Select List) with Checkbox10.03.2015 17:03
  • 1 - 50