User Info

Lata S

Name:

Website:

Location:

Last Seen:

Aug 13th, 2016

Description:

 

Avatar

LS

53 Questions

ThreadPostedQuestion
Column chart not showing anytihng if value below 1 - FXP-237504.04.2016 19:04 Hi, I have values below 1 in column chart but chart doesn't show anything. It shows fine in case of more than 1 values. I tried giving decimals property as 4. Not sure if I am missing something here. Please find the test case below:- http://demo.tryfoexnow.com/apex/f?p=172:13005
Pagination scheme21.12.2015 12:12 Hi, We are running on Foex 2.0.1. In one grid, we have query returning 1,00,00,000 records. Because of lots data page showing the below error. We tried using maximum number of rows as 10000, but it doesn't seems to be reflected. If in query we made a where clause as rownum< 10000, the screen shows the records successfully. In apex, we used to use the maximum number of rows to be 10000 And it used to work. Want to understand what can be done to support this in Foes. Please suggest..
Set Items on parent page is setting value in session but not client side14.09.2015 10:09 Hi, We are on 2.0.1 and I am not able to replicate the issue here but I created same setup as we have:- http://demo.tryfoexnow.com/apex/f?p=172:8012 I have two content loader regions as tabs on parent page i.e. 8012. On the second tab, in "Grid After Add Success" Dynamic action, I am setting parent page item i.e. P8012_HID_ITEM as Y I want to refresh again the first tab only if this item is Y. So I have a on tab change dynamic action with condition :- this.data && this.data.newCard && this.data.newCard.id === 'STATIC_ID_DESKTOP' && $v('P8012_HID_ITEM') == 'Y' I can see the item updated as Y in session but in js, it is not showing. and dynamic action is not calling because of this condition- && $v('P8012_HID_ITEM') == 'Y' If I remove this, its working. Is this something which is fixed recently in 2.1.0. It was working fine in 2.0.0. Please suggest how we can fix it in 2.0.1 Thanks in advance.
Gauge chart max value07.09.2015 07:09 Hi, I am trying to create a gauge chart. Just want to know how it calculates the max value as in normal Apex gauge dial chart, the query looks like select my_column as value , MAX(my_column ) maximum_value from my table GROUP BY my_column but in foex it is like select product_id id, product_id link , product_name label , '#LABEL# - #VALUE#' tooltip , value1 FROM table Thanks In advance.
FOEX 2.0.1 Bind form issue07.08.2015 06:08 Hi, After upgrading our application to FOEX 2.0.1 which was build on 1.2.4, our grid - form bind pages broke. In one or the thread ( http://forum.tryfoexnow.com/osqa/questions/3371/foex-2-grid-form-bind), I saw that we should give Primary key for readonly grids as well. I did that still issues exists. In Demo application, we are not able to replicate the issue. In Console I can see below error:- TypeError: B.map is not a function Please suggest..
Apex Optimistic Locking Message customization04.08.2015 16:08 Hi, As Apex implements optimistic locking, I can see the below message in demo app in case if we try to update same record in two different session. My question here is :- Is there any way in FOEX that we can customize this message?
FOEX column sorting04.08.2015 15:08 Hi, I am trying the sort option of a grid column. It is considering Case (Upper Case/Lower Case) separately while Sorting. We are on v2.0.1. I replicated it in http://demo.tryfoexnow.com/apex/f?p=172:3009 If we sort the first column ascending, we can see "ACTION" and "Action" seperately with other values in between. Please suggest..
Refreshing the main URL21.05.2015 17:05 Hi, I have a scenario where I have same as FOEX documentation application - page 3032 (Grid context Menu (Open in Tab or window)). My context menu items open windows like page 3007. On Click of save button in the pop up window (3007), I want to refresh the whole main page 1 same as reloading it. Can you suggest how can we achieve this. Thanks in Advance..
Grid grouping getting messed up in 2.0.024.03.2015 02:03 Hi, I enabled grouping for a column in readonly grid in 2.0.0. It is not grouping the data correctly. I am able to replicate it in FOEX demo as well. I just enabled grouping for one column( Page Id2 ) in Page 3002 of documentation application. Please check the test case here:- http://demo.tryfoexnow.com/apex/f?p=172:3002 Thanks in advance..
Error while creating tree grid using function returning query20.03.2015 01:03 Hi, I tried creating tree grid using function returning query but it is giving me the below error. I just moved the same query to procedure which is used on 5002 page number in documentation application. Can you please check my test case here http://demo.tryfoexnow.com/apex/f?p=172:37
Auto Column Width based on content13.03.2015 00:03 Hi, Is there any way to have grid column width to automatically set based on max content width. I found a method in ExtJS 4.2.0 here:- http://docs.sencha.com/extjs/4.2.0/#!/api/Ext.grid.column.Column-method-autoSize Can you please suggest how we can use it.
Hyperlink column08.03.2015 08:03 Hi, I have created a grid using a table in which one column is having values as website links. (for example data for this columns is like "www.google.com" etc) In 1.x version, when i used to click on this column data in grid, it used to open a new tab with the url. i.e. www.google.com in this case. But in 2.0 version, it is opening the tab but the url is concatenating my saved url with prefix of server address. Because of this, the url is not opening. Please suggest what can we do to fix it in new version. Thanks in advance
Group Header in grid02.03.2015 22:03 Hi, Is the FOEX group header for grid columns supports substitution string i.e. can we use a page item to derive the group header.
How to stop Tree grid region dynamically increasing height in v2.013.02.2015 04:02 Hi, My page is divided into two parts. I have a FOEX tree region in top and a grid in bottom. When I am expending the tree nodes as the content increases, my top region height is getting increased (which in turn hiding my bottom region). Is there any way to stop this. I checked and found that this is happening only in v2.0. I tried "shrinkWrap":0 in Additional config but it didn't help. Please suggest..
Change cell color dynamically based on other column value change22.01.2015 04:01 Hi, In grid, I have a column which needs to be disable based on the other values in grid. I tried achieving it using the logic used on Page 3008 in Demo app. It's working fine. Is there any way to change the color of the cell in the same code where we are disabling it. Thanks in advance
Creating Grid using collection24.11.2014 23:11 Hi, I have some questions on the example in demo application on page 3011. (1) Is the FOEX collection are different from Apex Collection. (2) I can see FX#COL_DEMO1 as the collection name. But I didn't find where we are creating this collection. (3) If I want to create a collection which is based on more than one table and use it in grid, how to do that. Do we have any example for that. (4) Do we have any document where we can read about using collections in grids in FOEX. Thanks in advance
How to use item value in Set Title dynamic action26.09.2014 11:09 Hi, I have a layout which is having title as "All Products". After an onchange event of select list P22_CATEGORY , I want to change its title as "Products-#P22_CATEGORY#" . I tried using FOEX-ACTIONS--> Set Title dynamic action and found that it works with static text but not able to fetch item value to show in title. Can you please suggest any other way to do it. Thanks in advance,
Cant copy cell values22.09.2014 19:09 Hi, We found that we can't copy the grid cell values using Ctrl + C as we can do with normal apex reports. It is useful when we want to copy some value and use it somewhere else for search or some other purpose. Can you suggest if it is achievable.. Thanks in advance
Refresh of content loader region17.09.2014 18:09 Hi, In content loader region, we have a property to choose Action on Apex refresh- Trigger contents refresh or reload contents. My question is for example- if after action 1, we want to reload contents and after action 2, we just want to trigger content refresh for same region, is there any way to achieve it? Currently, if we choose Action on Apex refresh as Trigger contents refresh, then everytime we do refresh for this region it will just refresh the contents. Same for other option. Thanks
Open Window in parent page12.09.2014 09:09 Hi, I have a page with center pane and a grid. I have given Static id to my page 110 -> center pane - i.e. MAIN_TAB. In grid, on context menu click- > I have a dynamic action to open another page 112 using FOEX content loader (plugin). In Page 112, I have a bottom Tab which is content loader region opening page 111. On page 111, in grid context menu click, I open a window. Right now this window open in the bottom tab only. I want it to come on top page i.e. center of page. for that as affected elements, I gave jquery selector as #MAIN_TAB but its doesn't work. Can you please suggest what can be done to open window to position on main page instead of just bottom tab. Here is a repcase:- http://demo.tryfoexnow.com/apex/f?p=172:110 Thanks in Advance
Close the content loader page dynamically09.09.2014 06:09 Hi, I have a grid on which in context menu click- > I have a dynamic action to open another page using FOEX content loader (plugin). I have alos mentioned a Unique Indentifier (ID) as "MyTab-#P26_RP_ID#" Now Once this page is opened, do we have any dynamic action which can close this tab using the Unique Indentifier (ID) which is now stored in a page item. Thanks in Advance, A.S.
Context menu not getting refreshed11.08.2014 21:08 Hi, I have a grid with context menu which is using some pages items for disabling and enabling of some options( Query is given below). I have a button on click of which I have created the dynamic action having two true actions. First one will do some processing and then fetch data for my page items so my page items value got changed ( P4_TEST_FLAG,P4_RESUME_FLAG ). Second true action will refresh the grid. Now issue is I can still see the same context menu even if item values are changed in session i.e. it is not getting refreshed. If I reload the page, the context menu query got refreshed. If I do the same thing for Menu button and try refreshing it on same button click after processing, it's getting refreshed and changing the disabling. Not sure why the refresh of grid is not refreshing the context menu query. Please suggest... SELECT 1 menu_id, null menu_pid, 'My First Option' TEXT, null URL, 1 display_seq, 'app-icon-edit' css_class ,null info , CASE WHEN :P4_TEST_FLAG = 'N' OR :P4_RESUME_FLAG = 'Y' THEN '"disabled":true' ELSE NULL END custom ,'AC' widget_id from dual UNION ALL SELECT 2 menu_id, null menu_pid, 'My second option' TEXT, null URL, 2 display_seq, 'app-icon-edit' css_class ,null info , CASE WHEN :P4_TEST_FLAG = 'Y' OR :P4_RESUME_FLAG = 'N' THEN '"disabled":true' ELSE NULL END custom ,'MA' widget_id from dual Thanks, Anuradha
Parent page item refresh not working10.08.2014 08:08 Hi, I have a item as FOEX menu button on my parent page for example page 1. On child page i.e. page 2, after save I want to refresh this menu button. I tried using FOEX actions--> Refresh action with Refresh Affected Elements on Parent Pages? as Yes. In affected elements- > ITEM --> P1_MY_MENU_BUTTON. Is there anything I am missing... Please suggest
Error while file upload10.08.2014 02:08 I tried uploading a file using FOEX file browse item and got the below error. Not sure what is causing this. Can you please suggest..
FOEX Form- Create Success dynamic action missing07.08.2014 22:08 We have created a dynamic action on event as FOEX Form - Create Success. But now I don't see such event any more. Also already existing dynamic action shows as below:- Please let me know how to fix it. Thanks, Anuradha
Grid refresh row not working after row action06.08.2014 02:08 Hi, I have dynamic query based grid, and implemented a column as row action. But after row action, the row refresh is not working, when we refresh the whole grid, it works fine. Is it because we have dynamic query ? Please check the rep case here :- http://demo.tryfoexnow.com/apex/f?p=172:111 To replicate the issue, click on row action, but it will not refresh the row. If u refresh the page it changes. Thanks, A.S.
Content Loader region- reload contents using dynamic action05.08.2014 19:08 Hi, I can see the addition in v1.2.2 to have an option either to refresh contents or reload contents in case of Content Loader Region (FXP-784 Content Loader region needs to have the option to refresh or reload when apexrrefresh is triggered.) Do we have similar option while creating a dynamic action to reload the contents on refresh of the content loader region. I want to reload the contents on change of a item. Thanks, Anuradha
Application Process behaviour23.07.2014 17:07 Hi, In Standard Apex, whenever we do some operation, we submit page and page get reloaded or load some other page based on branch. In such case, if I have a application process with process point as "On Load: Before Header(page template header)", it will be called every time whenever any operation happen as page is again reloading or loading a new page. Now in FOEX like as in Demo application, we always stay on page 1, only our center pane changes. In such case, If we want to run some code same as what our application process was doing previously, is there any way to do it in FOEX? Please let me know in case any more details required. Thanks, Anuradha
Multiple rows select on grid and context menu based on the selected rows23.07.2014 17:07 Hi, Is there any way to select multiple rows and when right click, have context menu based on the selected rows together in a grid. We are looking for this requirement from long time. If it is already in the plan, please let us know by when we can get it. Thanks, Anuradha
Grid using Dynamic query and processing procedure override21.07.2014 23:07 Hi, If we have a grid based on function returning query, and we have update operation enabled on the grid, the primary key column drop down shows us columns like COL01, COL02 and so on. We are using "Processing procedure override" for processing in which we are not using COL01, COL02 ... The problem occurs when we click on save, it execute our "Processing procedure override" succesfully but on UI it shows exception saying "COL01": invalid identifier. Can you suggest how to get rid of this error.. Thanks Anuradha
Conditionally enabled checkbox not getting checked in first click18.07.2014 03:07 Hi, In a grid, to disable the checkbox column based on the other values in grid, I have created a dynamic action as FOEX Grid- before edit. It checks for a column value and based on that it will allow or not allow the checkbox to be checked. It is working perfectly fine. But issue is when I first time click on checkbox which should be allowed to be checked based to the condition, it moved slightly from its position towards left but remain uncheck. Again if I click, then only it will get checked. In this way, user get wrong feeling that it may not allowed to be checked based on condition. I have created a rep case for it, if column A4 is "N" then user can check the checkbox else not. Try checking second and third row checkbox. http://demo.tryfoexnow.com/apex/f?p=172:111 Is it a bug? Please suggest how can we fix this issue Thanks in Advance, AS
Is ther any limit to number of Grid Columns shown03.05.2014 12:05 Hi, I have a grid based on function returning query. My function is returning almost 198 columns but I can see only 99 columns in my grid. If I export the data, I am getting all 198 columns in excel. Is there any limit to the max number of columns which can be shown in grid??? If not, then what can be the reason for it? Thanks in advance
FOEX Menu button stopped working after button refresh11.04.2014 10:04 Hi, I have a FOEX button - type as Menu Button. My menu Query is something like this:- SELECT 1 id, NULL pid, 'OPTIONS AVAILABLE' text, NULL url, 1 display_seq, NULL css_class, NULL info, 0 disabled_flag, NULL custom FROM DUAL UNION ALL SELECT 2 id, 1 pid, 'Details' text, NULL url, 3 display_seq, NULL css_class, NULL info, 0 disabled_flag, NULL custom FROM DUAL UNION ALL SELECT 3 id, 1 pid, 'CLOSE' text, NULL url, 4 display_seq, NULL css_class, NULL info, 0 disabled_flag, NULL custom FROM DUAL WHERE :P1_IS_EDITABLE = 'Y' UNION ALL SELECT 4 id, 1 pid, 'OPEN' text, NULL url, 5 display_seq, NULL css_class, NULL info, 0 disabled_flag, NULL custom FROM DUAL WHERE :P1_IS_EDITABLE = 'N' When I land to the page first time, It shows me correct Menu. On click of "Close" Menu, I Have a Dynamic action which shows me alert, then update tbl_data table column to 'N' (i.e. P1_IS_EDITABLE to 'N') and after that refreshes the button. Result of which my Menu hide the option "Close" and show the option "Open" On click of "Open" Menu, I Have a Dynamic action which shows me alert, then update tbl_data table column to 'Y' (i.e. P1_IS_EDITABLE to 'Y') and after that refreshes the button. But this dynamic action is not firing at all... If I refresh the page, then the Dynamic action on Open menu started working. Again once it changed to Close menu and I try the Close menu then dynamic action on close menu will not get triggered. If I again refresh the page, the close menu starts working. Is it a bug... how can we get rid of it.. Please find the repcase here --- http://demo.tryfoexnow.com/apex/f?p=173:1 Thanks in advance...
Open new tab only if not existing10.04.2014 13:04 Hi, I have a grid having context menu on it. In my context menu item click, I am passing primary key column to another page item and opening that page as a tab using content loader. Now, suppose I have a tab already open and I click on another row's context menu, I want to open a new tab but if I click on same row, I don't want to open a new tab, I just want to have focus on the existing tab. But in both the cases, it is opening new tab. I am having Unique Id as "ViewProduct- #P2_PRODUCT_ID#" The rep case is here :- http://demo.tryfoexnow.com/apex/f?p=173:2 Please suggest... Thanks in advance.
Hiding Columns on a Dynamic Grid - JS Error09.04.2014 09:04 Thanks Matt, it worked well in FOEX GRID- ROW SELECT SET ITEM VALUES[PLUGIN] . Now I tried hiding two columns using A4 and A5 on "FOEX Grid - After Load" event, but it results in some error. After adding dynamic action to hide these two columns, the grid stopped fetching data as well. I checked in Firebug and found the error saying "TypeError: col[config.action] is not a function". For more reference, I just now sent you the html page source. Can you please advise, where should I check to fix this issue. Thanks in advance
Grid Using Dynamic query04.04.2014 06:04 Hi, I have a grid which is having function returning query. For Column headers, I am using pl-sql option which gave me colon separated headers. Now, the issue I am facing is with Dynamic action- FOEX GRID- ROW SELECT SET ITEM VALUES[PLUGIN] I am trying to set some items to the values in some columns but when I checked the console, I can see that the items are not setting to anything i.e. not fetching any getting for the columns. I am sure it is because of dynamic headers but not sure how I can resolve it. Please suggest.. Thanks in Advance..
Grid having nested query erroring out29.03.2014 21:03 Hi, I have created a foex grid using the below query:- SELECT a1 "Product No",a2 "Name of Product",a3 "Product Desc",a4 "Enabled" FROM (SELECT PRODUCT_ID a1,PRODUCT_NAME a2,PRODUCT_DESCRIPTION a3,FLAG a4 FROM A_product) WHERE 1 = 1 but when I run the page it shows exception saying "FROM keyword not found where expected". My query is working fine when ran in SQL workshop. Can u please suggest how to fix it. A rep case can be found at http://demo.tryfoexnow.com/apex/f?p=173:5 Thanks in advance
Tab color change dynamically07.03.2014 11:03 Hi, I am having a Tab panel with 5 Tabs. I want one tab font color to appear as Red if the grid in that tab is having more than one record. I have already fetched the count in a item. But even after trying to change color for .x-tab button, Its not working. Is there any way to do it in FOEX. or some workaround. Please suggest..
Grid Refresh27.02.2014 12:02 Hi, I have one Parent grid and two child grids (as bottom tabs). On selecting each row, the below tabs wil get refreshed. Here issue is when I select a row, the below tab which is shown is refreshed but not the second tab. if i select second tab and again change row selection, second tab will be refreshed but not the first one. i tried to replicate the issue in the below page but same thing working fine here :- http://demo.tryfoexnow.com/apex/f?p=173:2 Can you suggest what can be the issue... we are having recent patch v1.2.2... Thanks in advance
Issue in download file01.02.2014 10:02 Hi, I have a form having File Browse item and a text area for Comments. In my form I can uploaded a file or add some comments or can add both. Now I have a grid which showing the data of this table and allowing user to download the uploaded files. Now issue is if I have added only comment, not the file to the table, when it shows in this grid, Still I got Download link for that record too. When I clicked on that link, it shows me error. Can I make this download link not to be visible in case there is no file. Please suggest.. Thanks in advance.
Enable Save if checkbox checked11.01.2014 20:01 Hi, I have a grid having first column as simple checkbox. I want my save button to be disabled if no checkbox is checked and enabled only if atleast one checkbox is checked. The checkbox column is editable. Can you please suggest how can we achieve it. Thanks in advance..
Disable grid checkbox conditionally11.01.2014 07:01 Hi, In grid, I have a checkbox column which needs to be disable based on the other values in grid. I tried achieving it using the logic used on Page 3008 in Demo app. It works for other columns but not for checkbox column. Please find the test case below:- demo.tryfoexnow.com/apex/f?p=173:4 I used condition - if FLAG column value equal to D_flag column value then Check box should be disabled else enabled. Please suggest how can we achieve it? Thanks in advance
How to use prompt message in GRID Processing Procedure Override06.01.2014 10:01 Hi, In a grid, I want to have a comment box(Prompt Message) on Save button and want to use its value in "Processing Procedure Override". But I can see that save is firing independently without waiting for the prompt message to be entered. Is there any way to do this..Please suggest.. Thanks in Advance..
Menu button options getting messed up27.12.2013 06:12 Hi, In My Center pane(Tab panel), I have two layouts as displayed as Tabs. In each layout, I am having separate Action button of FOEX button type as Menu Button based on Sql query. Now I see a weird issue. I can see the options from one button in another button. Please suggest what can be the issue. Thanks in advance
Window close programatically23.12.2013 07:12 Can we close a window programatically if it is opened using FOEX WINDOW OPEN plugin. I tried the below code but does not find it working. $('div#mywindowid.x-window').remove(); Please suggest..
Actions and validations on Save button when it is not doing any crud operation20.12.2013 05:12 Hi, I have a grid on which I have a context menu (For example page# 7). On clicking on context menu item, I am opening a different page (for example page# 8) as a window using FOEX WINDOW OPEN plugin. On page# 8,I have a save button on click of which I have a dynamic action which is executing a pl sql block, My pl sql block is calling a procedure which have a out parameter( which will return error if exists) in Pl sql block, I am assigning it to a page item. Now my requirement is once my pl sql block execution is done, then check if page item is not null, show the error as notification else show a message saying Action complted Successfully. Any idea how I can do it. Also in the same senerio, I want to have validation for some items which should run on click of my Save button. If fails, then validation error should be shown and no other dynamic action on this button should called. for both requirements, Please Suggest ..
Foex Menu button query using page items not refreshing13.12.2013 11:12 Hi, I have a FOEX button - type as Menu Button. My menu Query is something like this:- SELECT 1 id, NULL pid, 'OPTIONS AVAILABLE' text, NULL url, 1 display_seq, NULL css_class, NULL info, 0 disabled_flag, NULL custom FROM DUAL UNION ALL SELECT 2 id, 1 pid, 'EDIT' text, NULL url, 3 display_seq, NULL css_class, NULL info, 2 disabled_flag, NULL custom FROM DUAL WHERE :P4_IS_EDITABLE = 'Y' UNION ALL SELECT 3 id, 1 pid, 'VIEW' text, NULL url, 3 display_seq, NULL css_class, NULL info, 0 disabled_flag, NULL custom FROM DUAL WHERE :P4_IS_EDITABLE = 'N' When I land to the page first time, It shows me correct Menu. On click of "Edit" Menu, I Have a Dynamic action which changes P4_IS_EDITABLE to 'N' and after that refreshes the button. When I checked the session, it is having the updated value of page item. But my menu is still same. It is still showing "Edit" whereas it should show "View" option now. Is there any way to make it work... Thanks in advance..
Foex page opened as Window09.12.2013 10:12 Hi, I have a grid on which I have a context menu (For example page# 7). On clicking on context menu item, I am opening a different page (for example page# 8) as a window using FOEX WINDOW OPEN plugin. My requirement is when I click on a button which is on page# 8, I want to close this window i.e. page 8 and refresh my grid on page 7. Please suggest how can I do this.... Thanks in Advance
Foex Combo value not reflecting09.12.2013 02:12 Hi, I am having an item of type Foex combo. On change of this Item I have to call a database procedure which will take the combo value as parameter. So I created a Dynamic action on change of this item and Action is Execute pl-sql code where I am calling the procedure. Issue is it is not passing the value of item to procedure, It is passing null all the time. Even I tried inserting item value in a table before calling procedure to see is it able to access. In table, it is inserting null. In Page Items to Submit, I already gave the combo name so i can see value in session too. What can be the reason behind not changed getting value in pl sql code... Thanks in Advance
Editable grid in FOEX using dynamic query04.12.2013 11:12 Can we have a editable grid in FOEX using dynamic query? I already created a readonly grid in FOEX using dynamic query but facing issues in creating editable grid in FOEX using dynamic query. Please suggest!!
  • 1 - 50

4 Answers

AnswerThreadCorrect Posted
Hi, I tried this in 2.1.1. But it shows just zeros after decimals. For example, if the value is 2031.47 and I gave renderer as renderer" : /**/Ext.util.Format.numberRenderer("0,0.00") It shows 2031.00 as Label. I am expecting it to be as 2031.47 I tried this on this:- http://demo.tryfoexnow.com/apex/f?p=172:13005 But it is working here as it is FOEX v2.2 But when I tried comparing the view source in debug mode, I find only one diffrence type of Value1 field (float in 2.2 but int in 2.1.1) in storeCfg:- From FOEX 2.2:- "storeCfg" : { "fields" : [{ "name" : "ID", "type" : "string" }, { "name" : "LINK", "type" : "string" }, { "name" : "LABEL", "type" : "string" }, { "name" : "TOOLTIP", "type" : "string" }, { "name" : "VALUE1", "type" : "float" }] } From FOEX 2.1.1:- "storeCfg" : { "fields" : [{ "name" : "ID", "type" : "string" }, { "name" : "LINK", "type" : "string" }, { "name" : "LABEL", "type" : "string" }, { "name" : "TOOLTIP", "type" : "string" }, { "name" : "VALUE1", "type" : "int" }] } But I didn't find any place to change storeCfg. Can you please suggest some way to show decimal values on Bar chart ( label or tooltip) in FOEX 2.1.1. Thanks in advance, Lata Formatting value in Bar chart13.08.2016 23:08
Thanks Peter for response!! Actually my senerio is not about FOEX content loader dynamic action. It is about content loader region. Initially, it was not reloading the contents when I create a dynamic action to refresh it. but now it is working fine as I made the region as reload contents in apex refresh. Thanks, Anuradha Content Loader region- reload contents using dynamic action07.08.2014 22:08
Hi Matt, As per mentioned in V1.2.2 CHANGE LOG- improvements:- FXP-827 Support refreshing a FOEX menu/split/cycle button I tried refresh action using affected Elements as Item and choosed my Foex Menu button but still I am not seeing it refreshing. Can you please let me know if any other changes required . Foex Menu button query using page items not refreshing10.02.2014 10:02
Hi Peter, Please find the screenshot below. Also repcase here:- http://demo.tryfoexnow.com/apex/f?p=173:5 Menu button options getting messed up17.01.2014 16:01
  • 1 - 4

86 Comments

AnswerThreadPosted
Please help on this.. Formatting value in Bar chart16.08.2016 09:08
Hi Matt, I am trying to achieve same result for grids in terms of performance as it used to be in Apex. In our scenario,we have more than 10000000 so we want to count( ) to be removed. In Apex, we used to put max count as 10000,pagination scheme as Row X to Y, 25 records per page. Screen takes 0.5 second & works fine. Now in FOEX 2.1.1, we used same query. To remove count( ),we tried giving 10000 as number count and maximum count. It is taking too much time and page responds very slow after that like context menu options etc. Can you please suggest what can be done. Thanks in advance Pagination scheme05.04.2016 00:04
Thanks for the response, Just want to give a brief background on our issue. As suggested in your answer, We are already using custom CRUD processing and we use a checkbox column to check which one user want to do particular action. It was working fine till 2.0.1, it worked fine even in previous versions and so many of our customers are on 2.0.1 and using it. Now for performance additions in 2.1.1, we are trying to upgrade to 2.1.1 and this started breaking. Can you please suggest how we can fix it. Thanks in advance Not able to save the record by selecting the checkbox04.04.2016 20:04
Hi Matt, I can see 502 proxy error. Can you please tell me the suggested pagination scheme to be used so that I will send the page in Apex debug mode with that change.. Thanks in advance Pagination scheme21.12.2015 14:12
Thanks Matt for quick response... The thread which you shared was raised by my team member only and we did the workaround suggested by you in the thread. The hidden item is in a HTML region. Can you please have a look in my test case and suggest. Set Items on parent page is setting value in session but not client side14.09.2015 11:09
Hi Matt, I sent a Test mail. can you please check and confirm if you got it. Thanks FOEX 2.0.1 Bind form issue10.08.2015 13:08
No, I sent it to support@ tryfoexnow.com Just now I sent it again(please search for mail from anuradha.s ) FOEX 2.0.1 Bind form issue10.08.2015 11:08
Hi Matt, Thanks for your reply. I just now sent the HTML source and debug output to support@ tryfoexnow.com as asked. I can see an error in console which says:- Uncaught TypeError: array.map is not a function Regarding the version, I checked in console and found same as you showed i.e. "2.0.1.0" FOEX 2.0.1 Bind form issue10.08.2015 09:08
Thanks a lot Matt... Is there any way to remove the ORA error number from the error message? Apex Optimistic Locking Message customization05.08.2015 10:08
Thanks a Lot Matt, Is it possible for you to tell us if we can get a hot fix for it. (Also how many credits it requires) FOEX Grid LOV column sorting04.08.2015 15:08
Hi Matt, Sorry for the delayed response, We recently upgraded to v2.0.1. We can still see this LOV issue. I replicated it in http://demo.tryfoexnow.com/apex/f?p=172:3002 In the column CONTENT_TITLE, I made it as Select List (Static LOV). Now if we try to sort the data with this column, it shows same error. Please suggest how we can overcome this issue. Thanks in advance.. FOEX Grid LOV column sorting03.08.2015 08:08
Thanks a lot Matt For quick response.. I already tried it, it doesn't work.. I was trying to achieve it through any FOEX dynamic action. Also I just dont want to refresh opener window. Just want to reload the main application page 1. so can i reload my url in current browser tab instead of loading it in current page or parent page. Refreshing the main URL21.05.2015 22:05
Thanks Matt, But In our query I have dynamic where clause which is based on the selection of row i.e. Node Id item.. In our case, we don't have anything big other than dynamic where clause which can't be escaped by using View. Thanks 1 error has occurred Context Men u SQL Query gives ORA-01461: can bind a LONG value only for insert into a LONG column04.05.2015 04:05
Hi, Is there any way to resolve this. I am also a big query for context menu and not able to save it. please suggest... Thanks in Advance, Lata 1 error has occurred Context Men u SQL Query gives ORA-01461: can bind a LONG value only for insert into a LONG column01.05.2015 03:05
In my environment, I have readonly grid and my grouping is "Standard Report Column". Still it is messing up. Grid grouping getting messed up in 2.0.024.03.2015 21:03
Can you let me know how many credits we need to get this fix.. Error while creating tree grid using function returning query21.03.2015 00:03
Thanks Matt for your prompt response.... I am able to achieve it for now. Auto Column Width based on content13.03.2015 18:03
Thanks Matt.. Group Header in grid13.03.2015 00:03
Thanks Matt for the prompt response and workaround. Surprisingly with the older version on the same browser, I am not able to see this issue. Hyperlink column09.03.2015 17:03
Please find the test case here:- http://demo.tryfoexnow.com/apex/f?p=371:41 Hyperlink column09.03.2015 05:03
Thanks Matt!! Issue got resolved with the height property as you explained. As in my case, flex was disable and I didn't wanted to hard code the height, so tried using flex property for both regions and that too resolved the issue and working perfectly fine now. How to stop Tree grid region dynamically increasing height in v2.013.02.2015 11:02
Please find the test case here:- http://demo.tryfoexnow.com/apex/f?p=416:40:457190724595 Change cell color dynamically based on other column value change22.01.2015 12:01
Thanks a lot Matt!! The workaround worked for me pretty well... Open Window in parent page12.09.2014 17:09
Can you suggest any workaround for my setup as my window is hardly visible if opened in below tab. Open Window in parent page12.09.2014 10:09
Thanks Matt!! Conditionally enabled checkbox not getting checked in first click10.09.2014 16:09
Hi Matt, I can see that in change log, this issue is fixed. (FXP-1142 Add beforeedit event result cancellation capability in the grid checkbox column) Just want to confirm that so with new verion of FOEX now can we remove "fxCheckboxSpecialEdit":false and expect these two things work fine? (1) The conditional disabling of checkbox (2) Getting it checked in single click if enabled Conditionally enabled checkbox not getting checked in first click10.09.2014 12:09
Thanks for response... Its working now for me. Close the content loader page dynamically10.09.2014 05:09
I have created a test case on http://demo.tryfoexnow.com/apex/f?p=172:111 Steps to see the issue:- (1) Right click on grid and click on "Open Another Tab". (2) In the new tab, I have a menu button, which should close the current Tab. Thanks Close the content loader page dynamically09.09.2014 16:09
Hi Matt, Sorry for reading the response in hurry as don't have much time to resolve the issues. Regarding spending time in debugging, only after trying different ways, we post any thread for help. Please accept my sincere apologize for assuming the "TABS" id as something FOEX standard id for tabs. Regarding the issue, I tried with static id as well, but it didn't work. In my case page structure is Viewport --> Then a FOEX pane(show regions as Tabs(tabPanel)) --> child regions. Close the content loader page dynamically09.09.2014 08:09
Thanks Matt for quick response.. I tried the code as suggested but it shows below error in console:- TypeError: tabPanel is undefined tabPanel.remove(tabPanel.child('#' + tabId)); The code I used is as below:- var tabPanel = Ext.getCmp('TABS'); var tabId = Ext.foex.utils.replacePlaceholders('tab-MyTab-#P26_RP_ID#'); tabPanel.remove(tabPanel.child('#' + tabId)); Close the content loader page dynamically09.09.2014 08:09
Any update on this? We are in September now so thought of checking when we can expect it to be fixed.. Thanks FOEX Grid - Freeze Column / Desynchronization of the line09.09.2014 06:09
Thanks Matt!! It worked for me.. Context menu not getting refreshed12.08.2014 09:08
Thanks Matt!! In the dynamic action "Grid Dynamic Context Menu", we need to specify column and page item to be populated with it, but the items which are used in our context menu are not based on any column values of grid. These items are populated on page load. After that, on the button click, I have some procedure which is returning the changed values to these items. So after the button process complete, it is not refreshing. Is there any way to refresh it. Context menu not getting refreshed12.08.2014 07:08
Thanks Matt!! I added these events as you suggested. but have a doubt. Once we will upgrade to v1.2.4, do we need to change anything to make it work fine. FOEX Form- Create Success dynamic action missing12.08.2014 04:08
Thanks Peter for response, but I am clear why it is happening. First time the file is getting uploaded, if I try second file to be uploaded, the error comes in. After success of upload , I am resetting the form using FOEX form rest action. Can you suggest something how to resolve this. Error while file upload11.08.2014 08:08
No I just tried Items. Now with jquery selector, it is working fine. Thanks a lot !! Parent page item refresh not working11.08.2014 07:08
Actually, we need to have separate actions as FORM - Save Success, Create Success, delete success. It was there before but now only CRUD Success is there. Because of which I am able to see this issue for all such actions which we created before. FOEX Form- Create Success dynamic action missing08.08.2014 19:08
Thanks Peter!! FOEX Form- Create Success dynamic action missing08.08.2014 18:08
Our current Foex version is v1.2.3 I am not sure about the version in which I created this dynamic action but hopefully it was v1.2.1. Then we upgraded it to v.1.2.2. and now on v1.2.3 I can see the same issue in the instance where we have v1.2.2 Apex version is 4.2.1.00.08 FOEX Form- Create Success dynamic action missing08.08.2014 08:08
Thanks Peter, what if my grid query is not static. In my case, grid query will be a function returning query. Will this solution work in that case as well. Multiple rows select on grid and context menu based on the selected rows04.08.2014 22:08
Thanks Matt, My requirement is as follows:- So whenever I click on some button or do some operation, the first thing I do in my code is I update "USER_STATE" column for the current user. My application process has pl/sql code to fetch this column value for current user in a application item. Whenever it change based on its value, we hide/show items/buttons throughout the application. There are almost 100+ pages which have items/ buttons affected by this value. Can u suggest some approach in FOEX to do this. Application Process behaviour24.07.2014 18:07
thanks Matt for response!! for test case please check here :- http://demo.tryfoexnow.com/apex/f?p=172:111 if you check my processing procedure, it is inserting a row in table just to confirm that the call is going upto the procedure or not. But as page gives error for COL01 (which is specified as primary key), the processing dont continue for next row. Same thing works if we have dynamic query and doing operations through context menu options. Please suggest if there is any way to fix it. Grid using Dynamic query and processing procedure override22.07.2014 19:07
Hi Matt, Just want to check on the above requirement. In which release we can expect it.. Can i select multiple rows on a grid ?21.07.2014 18:07
Thanks Matt for quick response, Is there any other way to disable the checkbox without the need of clicking twice for enable ones. We can't ask user to click twice as it will not work at first time :( Conditionally enabled checkbox not getting checked in first click18.07.2014 07:07
Thanks Matt for the workaround!! Toolbar Menu's Buttons and Item Sequencing17.06.2014 11:06
So there is no way to right align the button if we remove test button?? Toolbar Menu's Buttons and Item Sequencing17.06.2014 11:06
Hi Matt, Please find the test case here:- http://demo.tryfoexnow.com/apex/f?p=176:1 I want "Button Item Menu" to the right before "Cancel" button. If I make the sequence of "Cancel" button less than "Button Item Menu", then "Button Item Menu" comes to Right but "Cancel" button came before it. I want "Button Item Menu" then "Cancel" button both right aligned. Please suggest.. Toolbar Menu's Buttons and Item Sequencing17.06.2014 06:06
Hi Matt, I didn't get your solution to right align. I have a FOEX button of type Menu Button which I want to right align. Can you please explain how to use list entry to achieve this. Toolbar Menu's Buttons and Item Sequencing16.06.2014 11:06
Oh ok :( Thanks for confirmation Matt!! Is ther any limit to number of Grid Columns shown05.05.2014 10:05
Thanks Matt, But I am aware of this setting. For me I have its value as 250. My function query is returning 198 columns. Surprisingly the export is giving all columns returned by the query. Is ther any limit to number of Grid Columns shown04.05.2014 08:05
  • 1 - 50