User Info

Adhi

Name:

Website:

Location:

Last Seen:

Feb 10th, 2016

Description:

 

Avatar

AD

79 Questions

ThreadPostedQuestion
How to allow decimal values in Number column in GRID11.02.2016 07:02 Hi, We are using FOEX2.0.1. We want to save the decimal values like 1.15, 1.25 in SEQUENCE column (datatype of this column is NUMBER). But currently it is not allowing decimals. I tried to use the below code in column's additional config, "editor": { "forcePrecision":true, "decimalPrecision": 2 } It is showing 1.00, 2.00. Now If i change the decimal and save it is not saving and again it is showing 1.00. Can you please check and let me know how to resolve this. Thanks, Adhi
FOEX Grid - Default Filter10.02.2016 12:02 Hi Matt, We are using FOEX2.0.1. I am trying to give default filter as you mentioned in the below thread, http://forum.tryfoexnow.com/osqa/questions/6045/foex-grid-filter but It is not working, also when i go and check the code in additional config, the code is not there. I tried it in latest version running on demo instance also, it is not working. Can you please check and let me know how to give the default filter in Grid. Thanks, Adhi
Formatting value in Bar chart22.12.2015 11:12 Hi Matt, I have referred the page#13009 in FOEX documentation application for bar chart. I can able to see some decimal values in backend but I can see the value without decimals in front end. we want to show the decimals(in tooltip value and label) in bar chart. How to give format for that? Can you please suggest how we can give format? Thanks in Advance, Adhi
Tooltip on column in Grid05.11.2015 08:11 Hi Matt, How to add tooltip on a column in Grid. I tried to use "tooltip":"right click to set" but tool tip is coming on header. I have also tried "items", "data" but no luck. Is it possible to give tool tip on that column data instead of header? Do we have any additional config for that? Here is my example page, I am trying to give tooltip for 'mgr' column. http://demo.tryfoexnow.com/apex/f?p=416:40:2688945921357::::: Thanks, Adhi
sort issue on grid using query with join22.10.2015 09:10 Hi, FOEX v2.0.1 We have a editable grid (cell editing) and the query is joining 3 tables and also having , one of the table's primary key is grid's primary key (for eg. ID) and trying to sort the rows descending order using another column(for eg. BATCH_ID), sort is not working when the grid is in cell editing mode. The sort is working fine if we sort BATCH_ID desc when the Grid's Allowed Operation is Read Only and also it is working fine when I remove the join in query. How to fix this sorting issue? I am not able to replicate this issue in demo instance. Can you please tell me what could be the reason and solution for this issue? Thanks, Adhi
checkbox on grid (cell edit mode) when freeze enabled13.10.2015 09:10 Hi Matt, We are using FOEXv.2.0.1 We have grid with checkbox, but it requires double click to check when we enabled freeze for a column in that grid. If we disable freeze means checkbox is working as expected else it requires 2 clicks. I am able to replicate this issue in demo instance, Please find the test case link as below, http://demo.tryfoexnow.com/apex/f?p=416:29 workspace: FX_WS_470 Can you please suggest some solution to fix this issue. Thanks, Adhi
Grid checkbox editing issue when freeze columns is enabled12.10.2015 06:10 Hi Matt, We are using FOEX2.0.1. We are not using the below attribute in grid config, "fxCheckboxSpecialEdit": true, It's working fine in this version but when we enabled column freeze on the grid we are still facing this checkbox double click issue. This issue exists in latest version on demo instance. http://demo.tryfoexnow.com/apex/f?p=416:29:14084194731776::::: Thanks, Adhi
Gauge Chart value formatting07.10.2015 11:10 Hi Matt, I used min and max values in Y-Additional Config in Gauge chart. I used format also like below, "label": {"renderer": / /Ext.util.Format.numberRenderer('0,0.00')/ /} I have a value with decimal point for example, 1001.568, the above format is rounding up and showing 1002.00 but i want to round only the decimal point like this 1001.57 when i give 2 precision in format. What formatting function i have to use for this? Can you please suggest me on this. Thanks, Adhi
FOEX item on HTML region15.09.2015 12:09 Hi Matt, We are facing some issue in one of the page, We have HTML region only but not having viewport and pane in that page. I have created FOEX items on that HTML region. I can see the code in page source for a text item which is coming up while page loading and go off after rendering. Please find the page source as below (i.e. input type="text" id="SINGLE_INPUT_FIX") and hiding item in JS function, Can you please tell me the cause for this? Thanks, Adhi
Item Label Separator is Missing06.09.2015 08:09 Hi, I am using FOEXv2.0.1 Is there any way to get back the colon end of the item label in Form? We were able to see it in previous versions (upto V2.0.0). Can you please suggest is there any global setting to get the colon at end of the label. Thanks, Adhi
FOEX Content Loader - Set Item through URL20.08.2015 07:08 Hi, I am using FOEXv2.0.1 I am using FOEX Content Loader [Plug-in] in DA to open another page (page#21) as tab in parent page(ie. Page#20). URL on the content loader is as below, f?p=&APP_ID.:21:&SESSION.::YES::P21_USER_ID:#P20_USER_ID# Page#21 is having a Grid with query like as below, SELECT user_name,user_email FROM user WHERE USER_ID=:P21_USER_ID I tried to submit P21_USER_ID in "Page Items to Submit" under grid query. When I use the item to submit here, it's not working (i.e. no data). When I remove it from here, it's is working and I can see the data. It's was working in previous versions of FOEX. Why it's not working in FOEXv2.0.1. Can you check and suggest me what needs to be done. Thanks, Adhi
FOEX Content Loader [Plug-in] Closable Issue18.08.2015 09:08 Hi, Using FOEXv2.0.0 I have a layout region (Only 1 child region fit) in a page, I am trying to load a another region using FOEX Content Loader [Plug-in] in DA. I want to exclude close icon of that region so I changed the option Closable as 'No' but still i can see the close icon of content loader region. When i make the layout as Tab panel then it's working. It's not working when we have VBOX layout, Only 1 child region layout. Can you please check and let me know how can I exclude the close icon? Thanks, Adhi
FOEX Grid LOV column sorting12.06.2015 17:06 Hi, We are using FOEX v1.2.4 and v.2.0.0 We have pages that contains FOEX grid with select list (query based) LOV column. We are getting an Error when we try to sort the column "Error: ORA-20001: Region: #region_name# Column: #column_name# LOV could not be found please check your settings. Lov definition:" what could be the reason for this error? I tried to replicate in demo instance but i could not able to replicate. we are getting this error in most of the grid. Can you please help us on this? Please let me know if you need more details on this. Thanks in advance, Adhi
Grid Validation Default Error Notification10.06.2015 06:06 Hi, FOEX v2.0.0 I am using grid validation procedure for grid validation. When we have any validation error, we will get an alert to check the highlighted cell. The spelling is not correct in that alert message as below, Can you please tell me where we can correct this spelling for application level? Thanks in advance, Adhi
FOEX plugin update on application level09.06.2015 04:06 Hi, We have created an application in an instance with FOEX v1.2.4 and imported that application in newer instance with FOEX v2.0.0. Whenever we edit the regions we are getting below alert, Plugins are available in DB-level and how to update the plugins in application level? Can you please let me know the steps which will be helpful for us. Thanks in advance, Adhi
FOEX- Tree Grid scroll bar issue27.05.2015 13:05 Hi, In FOEX v2.0.0, I have tree grid in window, when I try to expand all the nodes, the scroll bar is not visible even though I have an option 'Auto Scroll:Yes'. I am not able to replicate this in demo instance and hope it's working in previous version. Can you tell me how to enable the scroll for tree grid in FOEX v2.0.0? Thanks, Adhi
Prevent header of content loader and hide close icon29.04.2015 12:04 Hi, I have a page(#7) with 2 VBOX layouts, 1 contains form and a button. When I click on that button, it will load page#2 on 2nd Layout. In DA, I have selected 'No' to the Closable option of content loader plug-in and also I have selected 'Yes' to the 'Prevent Header' of Child objects of the 2nd Layout. When I click on the button, the page is loaded in the content loader but I can still see the content loader header and close icon. It was working in FOEX v1.2.2, but not working here. Please look at the below test case, http://demo.tryfoexnow.com/apex/f?p=654:7:11033068906310::::: Thanks in advance, Adhi
to iterate all the items in a form using JS17.04.2015 11:04 Hi, I have a form on the page. I want to make all the fields readOnly based on a condition and also make that function as generic so that i can use it whereever needed. I just want to know how to iterate all the items in a form using JS? Currently I am using setReadOnly() function for each and every item in JS like below, Ext.getCmp("ITEM_NAME").setReadOnly(true); Is it possible to loop through all the items in form and make it generic? Thanks, Adhi
TreeGrid node refresh on Row Action12.03.2015 13:03 Hi, I have a tree grid with row action, I want to refresh a node after row action. I have referred the page#5005 and Page#5008 in documentation application. I used TreeGrid Reload node (plugin) in true action of TreeGrid RowAction. when I click on row action, it looks like node is refreshing but the status column is not changing until or unless I refresh the entire TreeGrid. is it possible to refresh the node and it's status as like it's child? Page#5008 is having some problem in my workspace (FX_WS_470). Thanks, Adhi
FOEX Tree Grid with Row Action03.03.2015 14:03 Hi, I am using FOEX tree grid with row action. When I click on Row Action column I want to know the type of that node is parent or leaf node. Because, I want to perform the action based on the row action and it's type (Parent/Child)? Is it possible to check? How to check which node is clicked when i click on Row Action? Can you please guide me? Thanks in advance, Adhi
set the NULL value to more than one column in Grid30.01.2015 08:01 Hi, We have grid with one LOV column, when we select a value in LOV, based on that value of other columns set to be null. so we have used FOEX Grid Set Column Value on Column Change [Plug-in] in DA and set type as SQL statement to set the comma delimited columns. LOV returns an id value, If i use that id value in SQL statement means its working. but we want to get the name based on that id and then use the name in where clause of SQL statement means it's not working as expected. Please find the test case as below, http://demo.tryfoexnow.com/apex/f?p=416:40:::: Can you please check and let me know any other ways to set null value to more than one column. Thanks, Adhi
checkbox on grid (cell edit mode) V2.0.009.01.2015 11:01 Hi, FOEXv2.0 We have facing the checkbox double click issue, as mentioned in the below link, http://forum.tryfoexnow.com/osqa/questions/2417/conditionally-enabled-checkbox-not-getting-checked-in-first-click It was working fine in previous version without using the workaround (i.e. "fxCheckboxSpecialEdit":false). Again it's not working in new version. can you please suggest what to do. Thanks, Adhi
Exception "Network communication failure"26.12.2014 13:12 Hi Matt, We have 2 instances, INSTANCE1:- Oracle Database Server Enterprise Edition 11.2.0.1 FOEXv1.2.4 INSTANCE2:- (copy of INSTANCE1) Oracle Database Server Enterprise Edition 11.2.0.1 FOEXv2.0 Recently we have created INSTANCE2 and upgraded to FOEXv2.0. we have a form with more than one validations. This page is working fine in INSTANCE1 but, it's not working in INSTANCE2. When we try to create, it's showing exception "Network communication Failure'. In console, we can able to see 'Internal Server Error' and in trace file we are seeing the below exception, Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x100000034] [PC:0x621EC93, qercbiQBCompare()+597] [flags: 0x0, count:1] Similar to the below issue, http://forum.tryfoexnow.com/osqa/questions/1468/ajax-communication-failed-when-using-multiple-validation Is it a oracle bug? Can you please confirm and help us to know what we can do for it? Thanks Adhi
To validate the sum of column value before saving14.12.2014 18:12 Hi, My requirement is to validate the sum of column value in grid. The sum of value should be 100. If the value is not 100 then i should get the validation message. I have given name in 'Report sum label' as 'Total'. but i am not able to see this label in grid before sum of value. How to can i validate the total in FOEX? In case of APEX, we can use the JS to validate like, var varr = document.getElementsByName('f02'); for (i=0; i < varr.length; i++) { //code for adding the column values and validate. } Thanks, Adhi
message box on Form before submit06.12.2014 02:12 Hi, I have a form in my page with start and end date fields. When I select the end date and click on save. the message box should pop up and say 'Do you want to copy' and copy it. I tried to give it in before submit process (FOEX Form Before Submit), created message box (confirm) with yes/no action and pl/sql block to copy in true action. When i click on save, i can see the message box meanwhile the form is submitted and i can see the update success notification irrespective of the message box click. Is there any way to stop the form submit and before completion of before submit processes? Thanks Adhi
Grid validation message03.12.2014 03:12 Hi, I am using FOEXv1.2.4. I have created a Grid Validation procedure and used it in grid. In grid, I have enabled freezing for 4 columns and grouping for 3 columns. When I try to create/update row, the validation is fired but not able to see the validation messages and notification. when I disabled the freezing and removed the column grouping, the validation messages are started showing as expected. Can't we get the validation message for freezing columns? Please suggest me on this. Thanks, Adhi
Adjustable form on the screen03.12.2014 03:12 Hi, When we create form or grid, the default buttons are created on toolbar. I can see that toolbar is adjustable on the screen when we use browser zoom in and zoom out. The same way, we want the form fields should be adjustable on the screen. How can we achieve this? Is it possible in case of form like toolbar? Thanks, Adhi
Different requirement on grid26.11.2014 12:11 Matt, My requirement is i have 5 columns in a table,for example lets take a table TEST_TABLE with id, name, desc, col1, col2, col3. for Col1, col2,col3 i want to create a grid with 3 rows with dummy columns(i.e. 3 rows always should be there in grid), i don't want add rows button. but i will use custom processing to store value like this '1:2:3:4' a1 a2 a3 a4 -> dummy cols 1 2 3 4 -> will be stored in col1 like (1:2:3:4) 3 4 5 6 -> will be stored in col2 like (3:4:5:6) 5 4 3 2 -> will be stored in col3 like (5:4:3:2) Is it possible to have a grid with dummy cols like this? When no data in table, i will be having 3 rows with empty text field and when data is there in table, then i will be having 3 rows and the values should be bind with dummy cols. Thanks Adhi
Latest version of chrome and Developer toolbar18.11.2014 12:11 Matt, Google chrome is updated recently in my system (Chrome Version is 38.0.2125.111 m), after that developer toolbar is not visible for child pages. It went down and visible behind the developer toolbar of parent page. In previous version, we can able to see the developer toolbar of child pages. For Example, check the below screenshot, Main thing is, It's not only for developer toolbar, We are not able to see the Grid toolbar which contains (Refresh, Pagination to next & Previous pages). Anything we can do it from FOEX end for this?? Thanks Adhi
LOV and Pop Up LOV query issue17.11.2014 16:11 Hi, We are facing the LOV query issue in both LOV and Pop up LOV, Please check the below test case, http://demo.tryfoexnow.com/apex/f?p=416:6:4664467925441::YES::: We used the same query in APEX page, there it was working even we hide the name in the list of Pop up LOV list. but in FOEX if we hide it in LOV then we cant able to see the value. If we download the report as CSV, we can able to see the values. We want the value to be display but not in the pop up LOV list or LOV list. Can you please check and let us know what needs to be done to fix this issue. Thanks, Adhi
Error on my application12.11.2014 10:11 Matt, I am getting the below error in my application#416 @ 'FX_WS_470' workspace after upgrade to FOEX v.2.0, Can you please check and tell me what is the cause of this issue? Thanks, Adhi
how to avoid space in between items after hiding items in between03.11.2014 12:11 Hi Matt, I have page with 5 Combo items, 5 Text fields,5 Number fields and 5 date fields sequentially. I want to hide the items based on some condition. Sometimes I want to hide text fields and number fields. In this case, space is coming in between combo items and date fields. I am not sure how to avoid that space in this case. Can you guide me on this? at first, after hiding text fields, after hiding number fields (text fields), date field at last with space, Thanks, Adhi
FOEX Combo - avoid NULL value to be display16.10.2014 12:10 Matt, How can I avoid null value to be displayed in FOEX combo item, I have LOV setting as below, but still showing null value as 'Please Select'. I tried to give default value also but no luck. Is it possible? Please have a look and give me your inputs. Thanks Adhi
Content Loader - Encoding Issue with "+" sign being replaced to space15.10.2014 11:10 Hi, I have 2 pages, page#31 and page#32. I have used the static LOV in FOEX combo item like below in page 31, STATIC:COGS;COGS,Rev Adjustment;EREVENUE,Adjusted Revenue;REVENUE+EREVENUE, Contractual Revenue;REVENUE,Deferred COGS;DCOGS,Deferred Rev Adjustment;EDREVENUE,Def Adjusted Revenue;DREVENUE+EDREVENUE,Deferred Contractual Revenue;DREVENUE When I select "Adjusted Revenue" and click on a button to run the report (function based report) based on this input which is on page#32, I can see REVENUE+EREVENUE in session in page#31.I have used content loaded in page#31. The URL as below, f?p=&APP_ID.:32:&APP_SESSION.:::32:P32_FILTER:#P31_FILTER# I have hidden item in page#32 which will store the value from URL but in session of page#32, the value stored as 'REVENUE EREVENUE'. '+' sign is omitted. Can you please suggest me on this. Thanks, Adhi
Grid related Error14.10.2014 15:10 Matt, Do you have any idea for the below error, Please help me on this. Thanks, Adhi
FOEX Grid with condition01.10.2014 06:10 Hi, Is it possible to give condition to grid which will work when we refresh the grid? My requirement is, I have FOEX grid region and I am hiding this Grid region on page load and showing this region after clicking on the button called 'Run'. But the report query executed on page load so I want to give condition to my grid. What can i do for it? Thanks in advance, Adhi
FOEX Form and page submit25.09.2014 07:09 Hi, I used FOEX form (item container) and created a button called 'Submit' and tried to create DA on click 'Submit' button to execute a PL/SQL block. But the PL/SQL block is having 6200 characters. So I am not able to include that block in DA. So I just created it under after submit process. But now the page is not submitting since I am using FOEX Form. I tried to concise that PL/SQL block but still it has 6200 characters also i tried to use FOEX HTML region instead of FOEX form but the items look and feel is different. Please suggest me what i can do for it. Is it possible to enable the page submit when we have FOEX form as item container? Thanks Adhi How can I give these setting to FOEX HTML region? I want the items should be a Fixed Width items in HTML region.
Form and Grid region adjustments in vbox layout24.09.2014 07:09 Hi, I have the region structure as below, Center Pane -> VBOX layout Report Main Layout -> VBOX layout Filters (Form) is child region of Report Main Layout and Report(Grid) is child region of Canter Pane. Filters form is a item container, there are 50 items which will show based on the condition. For Eg. If Emp id is 10 then it will show 2 or 3 items, If Emp id is 20 then it will show 10 items. Based on the items the size of the form region should be smaller and larger. I tried flex values but the size of form region is fixed. how to change the size dynamically? Thanks in advance, Adhi
Height of FOEX TreeGrid23.09.2014 08:09 Hi, The height of the row in a FOEX TreeGrid is smaller than the height of the row in a FOEX Grid how can we increase the height? Thanks, Adhi
scroll bar16.09.2014 17:09 Hi, I am having center page with VBOX layout in my page and it has two grid regions. First region will display always, second region will display only if we add any rows in that grid by clicking on the first grid to add the row into second grid. Second grid id not showing horizontal scroll when we added a long row in it. if i decrease the zoom in browser, then the scroll bar is showing. why its not showing after adding a row? It's showing when we add more rows or minimize the screen and then maximize.. Thanks, Adhi
Reg. Error while content loader menu action04.09.2014 04:09 Hi, I got the below Error after clicking on context menu. This menu will open another page in new tab. What would be the cause of this issue? Thanks Matt for your quick turnaround. I am not able to replicate that error, but please find the below screenshots for post and response of that action, Thanks in advance, Adhi
Tabular form validation on grid26.08.2014 09:08 Hi, I want to create a grid validation procedure as like the tabular form validation which we have in APEX. By using the loop, it will fetch the current values on the page but in case of grid validation procedure, I am not able to do the same. It fails for some cases like when we are doing both create and update at same time and works fine for some cases. please check my test case here, http://demo.tryfoexnow.com/apex/f?p=416:24:12410089983511::NO:RP:: You can see the old tabular form validation code in 2nd tab and check my grid validation procedure. Am I doing anything wrong? How to implement the same here because I feel very difficult to implement that simple tabular form validation here in FOEX.. :( Please guide me and let me know if you need any other info on this. Thanks in advance, Adhi
FOEX File Browse Item label alignment19.08.2014 08:08 Hi, I have a FOEX File Browse item in my page, I tried to align the label right but by default the alignment of file browse item is left. so I just used the below code in page header (added=> text-align: right), <style> .x-form-item-label-left { padding-left: 18px; text-align: right; } </style> I want to align the label right? Is it the correct way to do it? Thanks in Advance, Adhi
Error Tool Tip on fields14.08.2014 07:08 Hi, Is it possible to increase the width of tool tip (in form and also in grid) to show the message fully? Please check the below screenshots, Thanks in advance, Adhi
column width for dynamic report11.08.2014 06:08 Hi, How can we give Column Width for dynamic report? Is it possible to give dynamic column width based on the column returned by dynamic query? Please give me your input on this. Thanks in advance, Adhi
Delete Button on Grid28.07.2014 11:07 Hi, I have editable Grid with 'Save', 'Create' and 'Delete' buttons. I want to disable these buttons based on some condition. Disable functionality is working for 'Save' and 'Create' button. but, it's not working for Delete button, by default FOEX has enabled the 'Delete' button when we click on any row in the grid. It should not happen. Is there any way to avoid default disable functionality for 'Delete' button on the Grid or I should create another DA to disable 'Delete' button after Grid Edit? Please give me your suggestion. Thanks in advance, Adhi
Reg. FOEX File Browse10.07.2014 10:07 Hi I am using FOEX File Browse item in my page, It will show textbox and browse button. After browsing the file, the path is displayed in textbox like 'C:/fakepath/filename.csv'. Please check the screenshot as below, Is it possible to show the exact path of the file from our system? If it is not possible then, I want only the browse button and don't want the textbox. So, I have selected 'Yes' to "Show Button Only?" option in the item. Now I am able to see only the button, I don't know whether I selected the file or not until or unless I see the tooltip on the browse button. In case of APEX, it looks like the below, Is it possible to show the file name next to the browse button instead of showing it in tooltip? Thanks in Advance, Nandhu
Value Required label alignment with * sign08.07.2014 08:07 Hi, The value required sign for any label i.e. ( * ) shows in left corner whereas the label alignment is 'Right' by default and some times the space between label and this sign is too far. but if the label alignment is 'Left' then the sign shows near to label. It should be close to the field label and flexible. Is there any way to show it exactly before the label whether the label alignment is 'Right' or 'Left'. Because we want the labels to be right aligned. Also, what is the better way to change the color of star (*) sign to Red? I have checked the below CSS for this, .x-form-item-label-required { background: url("../icons/item-required.png") no-repeat scroll 0 50% transparent; padding-left: 18px; } Check the screenshots, Label Alignment -> Right: Label Alignment -> Left: Thanks in Advance, Nandhu
Simple Checkbox LOV value issue in v1.2.303.07.2014 04:07 Hi, We have installed latest version of FOEX v1.2.3. We are seeing some in grid simple checkbox. We have simple checkbox column with the values 'Y,N' in Grid. This is not supporting in latest version. If we change it like this 'STATIC2:;Y' then it works. But we want to save the value as 'N' when we are trying to uncheck. Can you please let us know what could be the solution for this? will it support 'Y,N'??? Thanks in advance, Nandhu
Dynamic Breadcrumbs on Home Page11.06.2014 12:06 Hi, I have breadcrumb region in the north pane on Home Page (page#1), I am loading the pages (e.g.Dashboard page (Page#2)) using content loader into the center pane. I want to update the breadcrumb in page#1 based on the page (page#2) which is loaded into the center page. (i.e) Home > Dashboard I have tried to update it but it's not working as expected. Can you please give me your input on this. Thanks in Advance, Nandhu
  • 1 - 50

25 Answers

AnswerThreadCorrect Posted
Matt, In gauge chart, How to give format(i.e. number format) for value in tooltip and how to show Y axis line? and how to show only minvalue and maxvalue? Can you please suggest me how to do that? Thanks, Adhi Gauge chart max value18.09.2015 11:09
Hi Matt, We have upgraded to FOEX v2.0.0 and moved the application which is developed in FOEX v1.2.4. In FOEX v1.2.4, we have used the below condition as DA condition as you suggested for a workaround, (this.triggeringElement && !Ext.getCmp( this.triggeringElement.id ).disabled) After upgrade, the pages are not working as expected If we are using this condition in DA. Can you suggest what we can do? Thanks, Adhi Disable button is not working on Firefox12.06.2015 17:06
Thanks lot Matt.. Its working as expected but I was facing the issue when I use FOEX Form Action (Update) on "FOEX Message Box - No/Cancel Clicked" event. When Submit, again it went and call the same DA (FOEX Form- Before Submit). To fix this issue, I have created a hidden item and used it in DA condition. Thanks Adhi message box on Form before submit06.12.2014 07:12
Matt, We are okay for developer toolbar but we are facing this with Grid toolbar, I checked documentation application (#100) in our environment, there we don't have this issue. what could be the reason? We have modified the theme slightly with our custom code? Thanks, Adhi Latest version of chrome and Developer toolbar19.11.2014 09:11
Thanks Matt.. It's working in my test case. Surprisingly I am not able to see comment section in our Environment..:( We are using FOEX v1.2.4, Where can i add it?? Thanks Adhi LOV and Pop Up LOV query issue18.11.2014 11:11
Thanks lot Matt for your support and guidance..:) I will be moving all 'Execute PL/SQL Code' into package. 1). Can you give me idea to remove padding for hidden items. 2). I have given it in Item Default section (I think it will work only on page render) 3). I tried to change the label '#P2_LABEL#' and tried 'FOEX Form Item Actions->Set Label. Now it's working. I want to give label for 15 items at time so is it possible to use JS code instead of using 'FOEX Form Item Actions->Set Label' for 15 times. For Disable, we have, do we have code for set label? Ext.getCmp("ITEM_NAME").disable(); Thanks, Adhi how to avoid space in between items after hiding items in between17.11.2014 09:11
Matt, I have created test case for this in my workspace 'FX_WS_470', http://demo.tryfoexnow.com/apex/f?p=428:1:2667434106005::::: My requirement is, I want to show or hide the items based on Layout dynamically without page submit. Already I have design with page submit, there its working as expected. But when I try to do it through DA, I am getting the below issues, 1). Space issue because of this re-size of layout is not working as expected. (Accounting Report-> Detail By Transaction and FV Update Report) 2). Default values not coming up. (Accounting Report-> Detail By Transaction) 3). Dynamic Labels are not showing without page submit. I tried to Set Label for a item but its not working. Because on page load label was null, so it's not setting it dynamically even we use Set Label action. (Accounting Report-> Detail By Transaction) Can you please check and let me know the possibilities to fix these issues. Thanks Adhi how to avoid space in between items after hiding items in between12.11.2014 09:11
Matt, Find the screenshot of item sequence, Thanks, Adhi how to avoid space in between items after hiding items in between06.11.2014 05:11
Matt, Uploaded screenshot in question and this is the setting in field container Thanks, Adhi how to avoid space in between items after hiding items in between03.11.2014 12:11
Thanks lot for your support.:) I found the issue due to the function query returned display value. Once i changed the function to return the return value, It started working fine. Thanks, Adhi FOEX Combo - avoid NULL value to be display31.10.2014 07:10
Matt, In found that it's only for particular LOV in that page. I can't reproduce it in demo instance. The settings are as below, FOEX Combo - avoid NULL value to be display30.10.2014 12:10
Thanks Matt, Loading Grid data on page load restricted when I use this option. I have header type as 'PL/SQL' which is having bind variables for inputs. If it runs without parameter then it's giving me the error. Is it possible to give condition to grid and show it without page submit? If Page submit will not happen then grid will not be visible if it's having condition..:( Note: Same report and same header PL/SQL block working without any error in normal APEX page. Thanks, Adhi FOEX Grid with condition01.10.2014 07:10
Hi Matt, Below is the screenshot of both TreeGrid and normal Grid, Please check and let me the possibility to increase the width of row. Thanks, Adhi Height of FOEX TreeGrid23.09.2014 15:09
Thanks lot Matt for detailed explanation. I forgot to mention about validation proc. I have created validation procedure (SEGEMENT_SETS_VAL) in my test case but it fails for some cases like when we are doing both create and update at same time. All other cases it works fine. As per the requirement, I want only one row which has segment name as 'SEGMENT1' and enabled as 'Y' and it exists in table now. Now I am trying to add new row as 'SEGMENT1' and 'Y' and update existing row (enabled as 'N'). My grid validation first checks for 'CREATE' operation and showing the error. 'UPDATION' not happened until the 'CREATE' operation successfully done. This is the issue i'm facing. Am I missing something to check? Please have a look on my validation procedure and let me know what can i do. please help me. Thanks Adhi Tabular form validation on grid26.08.2014 10:08
Fixed in FOEX v1.2.3 FOEX Notify - custom requirement30.07.2014 11:07
we have fixed this issue, but we have to give "STATIC2:Y,N" instead of "Y,N" in v1.2.3. When uncheck it will store as 'N' for the column in table. Why the 'STATIC2:' is needed before the values? Thanks, Nandhu Simple Checkbox LOV value issue in v1.2.303.07.2014 12:07
Hi Matt, It was working fine up to v1.2.2, now only we are seeing this issue in v1.2.3 only, below is the screenshot for the same, Please let us know if you need any information... Thanks Nandhu Simple Checkbox LOV value issue in v1.2.303.07.2014 11:07
Hi Matt, I have created test case here, http://demo.tryfoexnow.com/apex/f?p=416:2:13194923881105::::: Also find the std APEX report here, http://demo.tryfoexnow.com/apex/f?p=250:9:3466633078225::::: CSS Style is not applied in Grid Column, Please check the screenshot as below, How to add this CSS style in grid column?? Thanks, Nandhu Column CSS Style in Grid05.05.2014 11:05
Thanks Matt. We have increased the AJAX Call Timeout. We will let you know in case of any issues. Exception raised when the page takes some time to load data05.05.2014 10:05
Thanks Matt for your quick response. I am using APEX4.2 and FOEX v1.2.2. I tried that option (Include in Export-> No) but it doesn't resolve my issue. Still I am getting the error, I dont have rights to alter the table also I can't use FOEX Export button since we are having APEX Export as our standard. There is only option to go for adding primary key. Thanks Nandhu Error while downloading report using Export Button concept09.04.2014 10:04
Matt, It's working now in our instance. v1.2.2 is not upgraded properly in our instance. Thanks Nandhu Content Loader issue in v1.2.214.02.2014 10:02
Hi, Please give me your suggestion on this. Thanks in Advance, Nandhu Grid Validation Issue06.01.2014 04:01
I am not able to understand your point. Actually, I am getting all the records in cursor to check this with new value. This is my procedure, create or replace PROCEDURE TEST_TEMPLATE_GRID_VAL ( p_crud_request IN FX_CRUD_REQUEST_T ) AS BEGIN IF p_crud_request.crud_request IN ('CREATE','UPDATE') THEN FOR i IN 1.. p_crud_request.new_record.count LOOP IF p_crud_request.new_record(i).name = 'EMPNO' THEN FOR rec IN (SELECT EMPNO FROM EMP_TEST) LOOP IF to_number(p_crud_request.new_record(i).value_varchar2) = rec.EMPNO THEN fx_p_grid.add_grid_error ( p_column_name => p_crud_request.new_record(i).name , p_message => 'Empno should be unique.' ); END IF; END LOOP; END IF; IF p_crud_request.new_record(i).name = 'ENAME' THEN FOR rec1 IN (SELECT ENAME FROM EMP_TEST) LOOP IF p_crud_request.new_record(i).value_varchar2 = rec1.ENAME THEN fx_p_grid.add_grid_error ( p_column_name => p_crud_request.new_record(i).name , p_message => 'Emp name should be unique.' ); END IF; END LOOP; END IF; END LOOP; END IF; End; Please help me on this.. Thanks in advance Nandhu Grid Validation Issue02.01.2014 16:01
Hi Matt.. Sorry to bother you again, I am not sure this might also the flex value issue or some other issue. http://demo.tryfoexnow.com/apex/f?p=416:7:4323461994731::::: Please have a look into my example, I used content loader to load the page#8 here, the content loader region(layout2 region) is not getting flexible height. I hope it's because of the parent region. I don't have any idea to fix this, i tried something but not working as expected. Can please give me a solution for this?? how can i increase the height?? give me any idea please... Thanks in advance.. Nandhu Region Alignment when using FOEX HTML Region02.12.2013 07:12
Thanks Matt. Yes you are correct Matt. But, I can't use the grid sql query in insert statement since I have some what different requirement, almost like my example page, in example page i used the existing column (ename) as editable column but requirement is user will enter the value in editable column while run time and then click on button to save so i can't get the values from table as you said. Hope you got my requirement. Can I create the tabular form here and use the apex array to get values??? Can you please tell me any idea on this??? Thanks Nandhu Get Values from every row of Grid on a button Click29.11.2013 17:11
  • 1 - 25

118 Comments

AnswerThreadPosted
Thank You..It is working fine as expected. How to allow decimal values in Number column in GRID22.02.2016 07:02
Hi, We don't want to show the decimal precision in the value which is not having decimal value. For Eg, I have 1.35 in first row, 2 in 2nd row and 3 in 3rd row. Currently it is showing, 1.35 2.00 3.00 We want to show like below, 1.35 2 3 Is it possible to allow precision and formatting it conditionally. Thanks, Adhi How to allow decimal values in Number column in GRID12.02.2016 06:02
Hi, When I give format mask then it is working fine. Thanks, Adhi How to allow decimal values in Number column in GRID11.02.2016 12:02
Thanks you.. It's working now. FOEX Grid - Default Filter11.02.2016 11:02
Hi Please find the workspace details, Workspace: FX_WS_470 Application: 371 Page:3002 Tried to use the below code in CONTENT_TITLE column-> Additional Config as mentioned in that reference thread, "filter": { "type": "string", "value": "Grid" } In our instance, we tried to give default filter for simple checkbox column, I also tried to modify the display type of that column but no luck. Please check and let me know. Thanks, Adhi FOEX Grid - Default Filter10.02.2016 13:02
Matt, This makes sense if we have data on that column. When we don't have data, I just want to guide user to do right click to select a context menu option to populate the values. So wanted tooltip for this scenario. :( Tooltip on column in Grid05.11.2015 08:11
Thanks Matt. I will send you the trace file. sort issue on grid using query with join27.10.2015 07:10
Hi Matt, I sent you the debug output file of that page. Thanks, Adhi sort issue on grid using query with join26.10.2015 09:10
I sent mail to support@ tryfoexnow.com with the details. Can you check it once and let me know if you need any other detail. Thanks, Adhi sort issue on grid using query with join26.10.2015 06:10
Can you give us some workaround for this as we are running on FOEXv2.0.1? Thanks, Adhi Grid checkbox editing issue when freeze columns is enabled13.10.2015 10:10
Sorry Matt, I asked it in old thread. I am not aware that you made it as new question and replied on that.:( Please delete this thread. checkbox on grid (cell edit mode) when freeze enabled13.10.2015 10:10
Hi Matt, Please find the test case here, I have changed in documentation app in my workspace, http://demo.tryfoexnow.com/apex/f?p=397:13012:34486805610180::::: Thanks, Adhi Gauge Chart value formatting07.10.2015 11:10
Matt, In gauge chart, How to give format(i.e. number format) for value and how to show Y axis line? Gauge chart max value18.09.2015 10:09
Thanks Matt. FOEX item on HTML region16.09.2015 07:09
Thanks lot Matt. It's working now. You are correct, The primary key column sequence matters. Behaviour of checkbox field next to a Foex Combo14.09.2015 09:09
Matt, We are able to replicate this issue in demo instance. We have one extra checkbox column in Grid which is not pointing to database column for deleting multiple lines. Here is the test case link, http://demo.tryfoexnow.com/apex/f?p=700:7: Could you please check? Behaviour of checkbox field next to a Foex Combo14.09.2015 07:09
Thanks lot Matt. It's working now but how to make sure if it happens in fresh installation in client environment? Item Label Separator is Missing07.09.2015 07:09
Matt, I have clicked on 'Apply Changes' button in "Shared Components" -> "Component Settings" -> "FOEX Application Settings". Also I am not able to see any option to change the default ":" separator. I tried in FOEX demo instance as well but no luck. http://demo.tryfoexnow.com/apex/f?p=397:1 Can you please check. Thanks, Adhi Item Label Separator is Missing07.09.2015 06:09
Matt, I have scenario like this in Grid, I have checkbox as first column and Textfield column as 4th column in the Grid. When I try to enter the space in that textfield column the checkbox is affected. Either it will uncheck or check. What can be the cause for this? Thanks, Adhi Behaviour of checkbox field next to a Foex Combo06.09.2015 09:09
Thanks lot Matt.. If we go for hot fix, when we can get it? Can you please let us know the timeline for it? FOEX Content Loader - Set Item through URL20.08.2015 12:08
Can you check here, http://demo.tryfoexnow.com/apex/f?p=416:9:4636609945643::::: page#9 and Page#41 Thanks, Adhi FOEX Content Loader - Set Item through URL20.08.2015 09:08
Thanks Matt. FOEX Content Loader [Plug-in] Closable Issue18.08.2015 12:08
Thanks lot Matt..:) Disable button is not working on Firefox15.06.2015 05:06
Actually We have upgraded to FOEX v2.0.1 but after upgrade the main page was coming up blank so we have degraded it to FOEX v2.0.0. Is it a bug in FOEX v2.0.0?? Can you suggest what to do? Thanks lot Matt for your support. -Adhi FOEX Grid LOV column sorting15.06.2015 04:06
Thanks lot Matt. I have changed the spelling in all the grid. Also changed the spelling in Shared Component-> Plug-ins-> Edit FOEX Grid plugin-> Edit component for 'Error Message' setting. Grid Validation Default Error Notification10.06.2015 08:06
Thanks lot Matt..I have set the "Flexible Size Ratio" as 1 on tree grid plugin. I can see the scroll bar now. Thanks, Adhi FOEX- Tree Grid scroll bar issue28.05.2015 05:05
Thanks Matt. It helps. to iterate all the items in a form using JS20.04.2015 06:04
Thanks Matt. When we can expect the release date of FOEX v2.1.0? TreeGrid node refresh on Row Action18.03.2015 03:03
Thanks Matt. Its working..:) FOEX Tree Grid with Row Action04.03.2015 11:03
Thanks Matt, I will try to use the sub query. Is it the only way (set type: SQL Statement) to set values to multiple columns? Can you please confirm. set the NULL value to more than one column in Grid30.01.2015 15:01
Thanks lot Matt for your quick support..It's working as expected. Change cell color dynamically based on other column value change27.01.2015 09:01
Matt, We want to change the color of column based on other column change value. In the below example, http://demo.tryfoexnow.com/apex/f?p=416:40:::::: When I select the manager, the corresponding department id will be populated in 'DEPTNO' column. Once value populated i want to change the color of that column dynamically as like the value populated in that column. How is it possible? Can you please check and let us know the possible ways to do it. Thanks Adhi Change cell color dynamically based on other column value change27.01.2015 08:01
Thanks Matt. It's working now. checkbox on grid (cell edit mode) V2.0.009.01.2015 14:01
Matt, without workaround, http://demo.tryfoexnow.com/apex/f?p=416:29:14084194731776::::: with workaround, http://demo.tryfoexnow.com/apex/f?p=416:26:14084194731776::::: checkbox is checked only by second click. Thanks, Adhi checkbox on grid (cell edit mode) V2.0.009.01.2015 13:01
Thanks lot Matt..:) To validate the sum of column value before saving15.12.2014 13:12
Matt, Is the Menu button on each row functionality available in latest version V2.0.0? Thanks, Adhi Drop down menu on each row instead of context menu on right click09.12.2014 09:12
Thanks Uli...I too thought of using collection only. so just wanted to confirm. Different requirement on grid26.11.2014 18:11
Thanks lot Matt for your quick response.. We found the cause of this issue in our application for Grid Tool bar and fixed. Thanks, Adhi Latest version of chrome and Developer toolbar20.11.2014 07:11
Matt, Thanks lot Matt.. Problem with chrome to see the comment section, I used firefox. So, There is no other workaround for LOV list?? Can you please confirm? Can we expect the support for the setting "Display Extra Values" for the grid LOV's in next version?? Thanks, Adhi LOV and Pop Up LOV query issue20.11.2014 07:11
Thanks lot Matt..:) how to avoid space in between items after hiding items in between17.11.2014 15:11
Thanks lot Matt for your support and guidance..:) I will be moving all 'Execute PL/SQL Code' into package. 1). Can you give me idea to remove padding for hidden items. 2). I have given it in Item Default section (I think it will work only on page render) 3). I tried to change the label '#P2_LABEL#' and tried 'FOEX Form Item Actions->Set Label. Now it's working. I want to give label for 15 items at time so is it possible to use JS code instead of using 'FOEX Form Item Actions->Set Label' for 15 times. For Disable, we have, Ext.getCmp("ITEM_NAME").disable(); Thanks, Adhi how to avoid space in between items after hiding items in between13.11.2014 09:11
Thanks lot Matt..:) Error on my application12.11.2014 13:11
I will try to create test case and let you know. how to avoid space in between items after hiding items in between06.11.2014 10:11
Matt, I have all hidden items after date fields. I pressed F12 and clicked on that space, div containers are available for the items which i made to hide.:( how to avoid space in between items after hiding items in between03.11.2014 13:11
Matt, I have all hidden items after date fields. I pressed F12 and clicked on that space, div containers are available for the items which i made to hide.:( how to avoid space in between items after hiding items in between03.11.2014 13:11
No problem Matt. Thanks lot..Its working fine now. Content Loader - Encoding Issue with "+" sign being replaced to space31.10.2014 09:10
Matt, This workaround is not working. I have tested in demo also. Can you please check and let me know what needs to be done. Thanks, Adhi Content Loader - Encoding Issue with "+" sign being replaced to space31.10.2014 05:10
Matt, Sorry for late reply. I have created test case for this, please check the below link, http://demo.tryfoexnow.com/apex/f?p=416:31:24255394467505::::: please check and let me know what we can do for it. Thanks Adhi Content Loader - Encoding Issue with "+" sign being replaced to space30.10.2014 09:10
I will create test case and let you know on this. Content Loader - Encoding Issue with "+" sign being replaced to space16.10.2014 06:10
Thanks Matt. Is there any workaround we can do for it now? Please give me if you have any idea. Content Loader - Encoding Issue with "+" sign being replaced to space15.10.2014 11:10
  • 1 - 50