|
| Ok this is slightly confusing since you have created this question using your account....
Can you advise if you used your Google account to authenticate with the "Ray" username i.e. via Open ID?
Can you advise your temporary login name and whether you (also) have the same problem with? | Forum cant change password | | 04.01.2016 10:01 |
| I have looked at your test case and can see that you have two different dynamic actions on the "Confirm" button click which both have the same notification message (confusing test case) e.g.
Remove the duplicate "Confirm Message Box_1" and it works as expected. In your test case I have set it to a condition of "Never" to show the correct behaviour. | Confirm mesage box doesn't wait | | 30.12.2015 13:12 |
| We are fixing the content loader issue in the next hot fix release reported in the following thread: http://forum.tryfoexnow.com/osqa/questions/6281/load-content-browser-window
As a workaround you can use Execute Javascript code:
window.location = 'http://mycompany.mydomain/somepage'; // replace current page
or
window.open('http://mycompany.mydomain/somepage'); // new window/tab depending upon browser implementation
For more info on window.open see: http://www.w3schools.com/jsref/met_win_open.asp | redirect to url as last step in dynamic action | | 30.12.2015 07:12 |
| We are planning to include this in v2.2.0, for earlier versions i.e. v2.1 and below you can look at the following thread to implement this: http://forum.tryfoexnow.com/osqa/questions/5664/cascading-lov-between-foex-grid-columns | Cascading Select Lists in FOEX Grid | | 27.12.2015 09:12 |
| Currently there is no setting to provide a number format on the chart value, the formatting is hard coded. We have filed an enhancement request.
For the label you can workaround this by overriding the series label config. First you need to put the page in debug mode and view the page source e.g.
You then need to copy the label config and paste it in your first series "Custom Config" attribute (only the first series) and adjust the format in the renderer e.g. 0,0.00
Please note : if you add/remove any series from the chart you will need remove the label config override and perform this step again, since the "field" attribute will change in the label config.
Unfortunately we cannot adjust the behaviour of the tooltip | Formatting value in Bar chart | | 22.12.2015 11:12 |
| I can confirm that this is a bug when using the content loader browser window in combination with setting a custom URL within the action.
We will provide a fix for this in the next hot fix release which is due out soon. | Load content browser window | | 22.12.2015 11:12 |
| Since you are getting a 502 response it sounds like a timeout issue, the default value in the application settings plugin is 45 seconds. I believe the issue may be due to the fact that our pagination scheme requires a count(*) to be performed which is causing the load to take longer than the default timeout. We only ever return the number of records specified in the "Number of Rows" attribute.
From v2.1.0 onwards you can exclude pagination altogether and improve performance, grids can have the count(*) removed from the SQL query by setting the pagination scheme to "- No Pagination Selected -" and also setting the maximum count rows equal to the page size page size. You can then find the records by using teh grid search functionality.
However since you are on an older version you will have to find a way to reduce the size of the dataset by using pre-defined filters. | Pagination scheme | | 21.12.2015 16:12 |
| If you want to provide a fixed height on a textarea with scrolling then set the attribute "Grow" to "No". There is no need to provide any additional config.
e.g.
As for scrolling on regions i.e. field containers/fieldsets, forms. It is controlled by the "autoScroll" property. This can be set specifically on each region or as a default setting for all the region's child regions. e.g.
If you do not want scrolling on a region then you should disable it "autoScroll":false. Scrolling will occur when the width/height of a region is greater than the displayable area. You have the ability to use the following config options to control width/height and scrolling on all regions:
"flex": 2,
"width": 400,
"minWidth": 200,
"height": 400,
"minHeight": 200,
"autoScroll": true
If you have problems designing a page then you should request a web meeting using your support time, where we can walk you through the design of the page and explain the use of these settings. | Scrollbar appearance at field container level or hbox/form level depending on form config | | 21.12.2015 10:12 |
| For the stretch layout (and this also applies to regions) you use the "flex" config attribute to control the width of items in combination with "minWidth" and "maxWidth" to set boundaries on the size.
"flex": 2,
"minWidth": 100,
"maxWidth": 400
Example Scenario
Say you have 3 page items in a "Stretch Items" Layout with (with start on new Row set to No) and you assign a flex value of 1 for a text field, a flex value of 2 for a date picker, and a flex value of 1 for a number field then the components will have the following width percentage. text field = 25%, date picker = 50%, number field = 25%. This is because the total flex value = 4, the text field's flex value = 1 therefore 1/4 = 25%. The date picker has a flex value of 2 therefore 2/4 = 50% etc. If you then add a minWidth or maxWidth setting on each of the items then this will set the minimum and maximum boundary on the width of the field, therefore the percentages might be different (depending upon the width of the region they are in) if these settings are in place.
Note: column span is ignored in FOEX since it does not make sense in our layout design. | FOEX form with image with multi-row height | | 18.12.2015 08:12 |
| Radio groups are not currently supported within the grid. Please use a select list instead. | Grid with Column Type Radio Group | | 17.12.2015 14:12 |
| Please see the following question/answer: http://forum.tryfoexnow.com/osqa/questions/5637/issue-with-accordeon-panels-fxp-2094 | Collapse/Expand Region Issue | | 17.12.2015 14:12 |
| Not all APEX features are currently supported in the FOEX grid, this is one of those features.
You can however design your own print functionality with the aid of 3rd party tools like BI Publisher, PLPDF, Doxxy, or APEX Office Print
Commercial
http://www.plpdf.com/
http://www.doxxy.eu/
http://www.apexofficeprint.com/ords/f?p=AOP_SITE_V12:HOME
Open Source Alternative
http://sourceforge.net/projects/pljrxml2pdf/ | What's about printing in a FOEX-classic report? | | 16.12.2015 13:12 |
| Please see the following answer: http://forum.tryfoexnow.com/osqa/questions/4745/grid-problem-primary-key-column | Primary Key Column of Grid Always Hidden | | 15.12.2015 19:12 |
| In the early version of FOEX i.e. v1.x we automatically added a Reset button to the form which did not require you defining one in the builder. We later introduced functionality in the FDA to automatically create this button so that you could add conditions/authorizations and translate the label. For backwards support we still add this button automatically if we can't find a button assigned to the form with the button name RESET (the default name used by the FDA).
If you have created a custom reset button manually on the form can you ensure the button name = RESET | Reset Button shown twice | | 15.12.2015 09:12 |
| You have not updated your glassfish webserver correctly if you cannot upload a file > 2MB. To in increase it on glassfish 3.x you should find maxPostSize under "Network Config"->"Network Listeners"->"http-listenerX".
In addition to increasing maxPostSize you may need to increase the Java memory heap size to avoid out of memory errors e.g.
MaxPermSize=4096m
In some other cases you may also run into maxParameterCount in Glassfish which has a 10000 parameter limit. Therefore our recommendation is to use Tomcat and an Apache Reverse Proxy as the ideal (low cost) webserver setup.
The plugin's multiple file upload capability is ideally designed for small files. We are introducing the ability in v2.2.0 for you to force the uploads via an iframe to avoid this size restriction. The downside is that you can only upload 1 file at a time, but the good news is that you do not need to submit the page (like regular APEX requires you to) so productivity is still maintained. | Showing up pictures that were not imported by Apex/Foex | | 15.12.2015 07:12 |
| To change the label for the export button please create a Text Message in your application e.g.
Note: using the %0 substitution will result in a blank label, the reason for adding this is because text messages cannot be NULL.
You can find the details here in the documentation under "Globalisation" e.g.
| Label of Export Button on Grid | | 15.12.2015 07:12 |
| There shouldn't be any problem cloning, if the clone is successful.
It sounds like you have a problem referencing the FOEX webserver directory, have you copied the required FOEX webserver files (and the right version) as per the location in "Shared Components" -> "Component Settings" -> "FOEX Application Settings"
Are you using ORDS v3 or the APEX listener? If using the APEX Listener please restart it. | Cloned our DB, APEX, FOEX Instance, Now FOEX Hangs with Load Spinner | | 11.12.2015 14:12 |
| The icon class you have chosen is for a small button 16x16, but the button you are using is a large button 32x32 pixel size ("Button Size") attribute setting). You need to either change the button size or the icon or use no icon.
The current available icons provided by the framework can be found here: http://www.tryfoexnow.com/apex/f?p=FICON:HOME
You can also include your own icons by including additional custom CSS and images/sprite maps into your application. | Icon is showing twice on button | | 11.12.2015 10:12 |
| The page designer does not provide an accurate representation of you page when using different FOEX layouts, for form items it gives you an indication of which items start on a new row or not, but the layout controls how they will be displayed i.e. fixed size or stretched. This is not reflected in the page designer view because these are custom components defined outside of apex.
As for achieving your layout requirement you can simply set the form plugin layout to "Horizontally stack regions" and have two field containers the left holding your page items, and the right feild container holding your image. The form plugin allows you to include nested regions and include components like layouts, grids etc.
Have a look at the documentation app on page 4006 for an example of using nested layouts within a form. | FOEX form with image with multi-row height | | 11.12.2015 07:12 |
| Please check your data. In your test case all the BLOBs are NULL for your images that have not been uploaded via the file upload plugin, hence why nothing is displayed.
e.g.
| Showing up pictures that were not imported by Apex/Foex | | 10.12.2015 16:12 |
| For the ORA-1403 error on window open after it's already been open previously, you need to add "fxDisablePageRefresh":true. This is to prevent the form refreshing which is not required in this case.
The issue with the "After Close" event not firing in destroy mode is because the actual DOM element you have bound your dynamic action to i.e. "#WINDOWS_IMPORT_CSV_ID" has been removed from the page.
As for the actions you need to perform, listening to the "Before Close" event should still satisfy your requirements. The "After Close" event was added to allow you to focus on a form item after closing the window since the window prevented item focus from occurring since it grabbed the focus as it was closing. We will see if we can support the "After Close" event on a Window that uses destroy mode. | windows destroy mode prevent detecting closing event | | 10.12.2015 15:12 |
| The them roller only styles the APEX theme, all FOEX plugins are Ext JS components and not APEX and are controlled by the Ext JS theme, therefore the theme roller cannot style these aspects. The theme roller falls under regular APEX development and is outside the scope of FOEX.
If you want to know more about using the theme roller please see the apex documentation .
As for the different appearance of the theme roller it appears there is a JS error on opening it: Uncaught TypeError: less.palette.availableModes[i].replace is not a function
We will investigate this error and see why it is occurring. | How to use Theme Roller in the Universal Theme in FOEX | | 09.12.2015 16:12 |
| I don't quite understand what you are trying to achieve. For the desktop you define the shortcuts and start menu items which can only open one window at a time for each one.
The only way you could open multiple windows of the same page would be using the Open New Desktop Window dynamic action. Using this action you should ensure that the ID's used for the window are shared so you don't open duplicate windows.
Please create a test case showing the actual problem and then we will investigate and advise on a way forwards. | FOEX Desktop - Share/Reuse Windows | | 09.12.2015 07:12 |
| AJAX calls timeout in FOEX by default after 45 seconds, you can change this in the FOEX application settings e.g.
"Shared Components" -> "Component Settings" -> "FOEX Application Settings"
APEX 4.2
APEX 5.0
Note : this increases the timeout for all FOEX plugin AJAX calls.
Alternatively to using the Message Box plugin you can also use AJAX callbacks within standard APEX and call them using "apex.server.process" calling them asynchronously (better) Vs the synchronous (worse) behaviour of an execute PLSQL Code dyanmic action.. explained more here by John Snyder
APEX 4.2
APEX 5.0
| FOEX Message Box timeout | | 09.12.2015 07:12 |
| After having the remote support call we were able to determine that the AJAX calls made by the FDA were failing due to an application level authorization with the following settings:
The fix in this case was to set "Run on Public Pages" to "No".
The FDA relies on a page in your application, page ID: 9906150524. This page is a public page with a condition on it that only allows it to be run in apex development mode (i.e. when logged on to the builder). This page must be excluded from application level authorization schemes. | FX_P_DEVELOPER_ADDON.Check_Preconditions | | 08.12.2015 14:12 |
| This could possibly be a browser security issue.
Can you open the browser developer tools and check the network tab when you have the APEX Page Builder/Page Designer open, and check and see if there are any HTTP request failures, and if so report the error messages and information. | FOEX Browser Addon Problem | | 08.12.2015 13:12 |
| Thanks for the test case much appreciated.
I can confirm your issue that setting a "Vertical Stacked Regions (VBOX)" layout on a window causes the reported behaviour.
The workaround is to create a nested "Vertical Stacked Regions (VBOX)" layout region and use the "Only 1 child region (Fit)" layout on the window e.g.
We have filed a bug report and will look to get this fixed ASAP. | Window region plugin does not open correctly when using a "Vertically Stacked Regions (VBOX)" layout | | 07.12.2015 11:12 |
| From what we have tested it is possible to select just the display field text and if you do select beyond the text boundary you just simply adjust your selection. The text selection is browser based and not do with the framework. You would have to consider altering the different markup for the display field and see whether this has any effect to achieve your requirement.
You could do this by including the "fieldSubTpl" in your custom config plugin attribute but this is not something we recommend or support you doing since this may break when we upgrade the underlying Ext JS framework in a future version.e.g.
"fieldSubTpl": /**/[
'<div id="{id}" role="{role}" {inputAttrTpl}',
'<tpl if="fieldStyle"> style="{fieldStyle}"</tpl>',
' class="{fieldCls}">{value}</div>', {
compiled: true,
disableFormats: true
}
]/**/
| Copy & Paste Support for Display Field | | 04.12.2015 16:12 |
| You should include some javascript in your login page template to set this to the top page e.g.
<script type="text/javascript">
// frame killer, this is needed if you're session has expired
if (top.location != document.location) top.location = document.location;
</script>
| Login page opens within content loader when session timeout | | 04.12.2015 16:12 |
| No this is not currently possible. We have filed an enhancement request for this requirement which we will consider at some point in the future.
If this is a business critical requirement you can use the paid support channel to prioritize this feature. | Grid Add/Create Row | | 03.12.2015 17:12 |
| Ok I can confirm that grid columns with type "Hidden Field" are not editable unless a default PLSQL expression is provided e.g.
APEX 5.0
APEX 4.2
Alternatively you can override the read only status of the column in your computation: p_crud_request.new_record(i).read_only := 'N'; e.g.
procedure compute_grid_row (p_crud_request IN OUT NOCOPY FX_CRUD_REQUEST_T)
IS
l_col_not_null1 NUMBER;
l_col_not_null2_idx NUMBER;
BEGIN
FOR i IN 1..p_crud_request.new_record.COUNT LOOP
CASE p_crud_request.new_record(i).NAME
WHEN 'COL_NOT_NULL1' THEN
l_col_not_null1 := p_crud_request.new_record(i).value_varchar2;
WHEN 'COL_NOT_NULL2' THEN
l_col_not_null2_idx := i;
p_crud_request.new_record(i).read_only := 'N';
ELSE
NULL;
END CASE;
END LOOP;
p_crud_request.new_record(l_col_not_null2_idx).value_varchar2 := l_col_not_null1;
end compute_grid_row;
We will update the documentation to make sure this is clear.
The reason for hidden fields not being editable unless a default was provided was to match the tabular forms functionality and for security reasons. Since hidden fields can't be directly modified by the user. | FOEX Grid's Computation and Validation Procedure issue when computing a value for a NOT NULL column | | 03.12.2015 08:12 |
| For grid columns based on an underlying data type of NUMBER we use a corresponding number data type in javascript. The issue you are running into is that in Javascript the maximum integer size is 16 digits, whereas in Oracle the numbers generated from a to_number on SYS_GUID() are 38 digits. These large numbers are being converted to scientific notation in Javascript.
The fix for your issue to is to put a to_char(ORDER_ID) in your order items grid SQL query e.g.
select i.ORDER_ITEM_ID
, to_char(i.ORDER_ID) ORDER_ID
, i.PRODUCT_ID
, i.UNIT_PRICE
, i.QUANTITY
from fx_t_doc_order_items i
where i.order_id = :P16_ORDER_ID_DRILL
We recommend that you put a to_char on any number column which has large numbers, as well as any column which is a primary, surrogate, or foreign key.
To see the current underlying issue you just need to look at the grid data
e.g.
You can see in the update HTTP Post (open your browser developer tools, network tab, and inspect the AJAX calls):
The documentation does mention this:
| constraint violations popup when saving | | 03.12.2015 07:12 |
| After investigating we can determine that the issue is caused by having number/float data types in use in the grid columns and implicit type conversions that are happening in both Javascript and PLSQL. Raw numbers in both Javascript and PLSQL use a regular decimal notation and the grid is expecting the returned value to be in this raw number format and not a VARCHAR. The PLSQL code we execute for your "set column value action" is returned in VARCHAR2 format which means an implicit type conversion is happening resulting in "100,99" for a 100.99 raw number value when the NLS decimal separator is a comma i.e. ','
To workaround this issue for the whilst we resolve this in a forth coming release please ensure that you use a 'NLS_NUMERIC_CHARACTERS=''.,''' for a regular (i.e. US) decimal within the TO_NUMBER, and do a replacement on the returning value to ensure that it is US decimal format. e.g.
DECLARE
v_return NUMBER;
v_rate NUMBER;
BEGIN
IF :P2001_CURR_CURRENCY = 1 THEN
v_rate := 1;
ELSE
v_rate := 1.5;
END IF;
v_return := TO_NUMBER(:P2001_CURR_AMT, '999999999D99','NLS_NUMERIC_CHARACTERS=''.,''') * v_rate;
RETURN replace(to_char(v_return),',','.');
END;
I have updated your test case with a working example. | FOEX Grid Set Column Value on Column Change - not working properly for decimal numbers in French | | 02.12.2015 10:12 |
| You need to perform a Form Load operation (after the form bind) for the buttons to managed and to fetch the checksum for change detection.
Currently the form bind is pretty much equivalent to the set items action on grid row select. It just does the automatic mapping of columns to page items. We will be changing the functionality of the form bind in the next release so that it performs 2 way data binding with the grid record.
Additionally you cannot use a grid column name of "ID" within the form bind if this is not set as the primary key, since the internal grid record identifier is also named "ID" and the internal record ID will be assigned to your corresponding form item. | Form primary key cannot be updated | | 01.12.2015 15:12 |
| It is not supported to have an editable primary key in your form. You will need to include an extra page item that holds the primary key value and write a custom processing procedure to perform the update/CRUD operations and update the primary key value. | Form primary key cannot be updated | | 01.12.2015 13:12 |
| The cascading LOV setup for FOEX page items is only currently supported for items contained within the FOEX Form, FOEX Toolbar, or Grid Toolbar.
We have filed a ticket to review the design and see whether we can extend the support for this to other scenarios similar to your test case. | treegrid combo cascade lov child not auto refresh | | 01.12.2015 08:12 |
| In your test case the underlying data type for the column ORDER_TIMESTAMP is a DATE data type and not a TIMESTAMP data type.
Please note: you need to set a format mask on all grid columns which have a date/timestamp data type. When using a default PLSQL expression you must also use a to_char on the default value using the exact same format mask. | plain-text field not filled by default systimestamp, but by default sysdate | | 01.12.2015 07:12 |
| It seems as if you are asking 2 questions in the 1 thread. Please makes sure you ask a single question at a time, even if it is the same plugin.
Please add a screenshot to show the button display issue you are describing, you are showing it only when it is working.
As for the javascript alert it says you have not provided a value for your ID column. You must create a before insert trigger to generate your primary key ID. The plugin does not do this for you. | FOEX Multiple File Upload plugin - button issue and error on upload | | 30.11.2015 17:11 |
| As of v2.1.1: this is still the only workaround to show a read only checkbox in an editable grid. For row editing make sure you also include the editor config to make it read only e.g.
"editor": {
"readOnly":true
},"processEvent": /**/function () { return false; } /**/
| Read only check box on grid | | 30.11.2015 14:11 |
| To workaround this issue (until a fix is provided) you will need to include some additional CSS to override the following class definitions.
x-tab-{ui}-active
x-tab-{ui}-over
The available UI's are: success, warning, danger, info, light, dark
e.g. to change the tab styling for the "light" UI
.x-tab-light-active {
border-color: #ccc !important;
background-color: #ccc !important;
}
.x-tab-light-over {
border-color: #dad9d9 !important;
background-color: #dad9d9 !important;
}
Note: you may want to choose better colours than what I have for an improved look. | Current tab on page load content with UI set to non-Default | | 27.11.2015 10:11 |
| By design hidden columns are not excluded from the grid search. This is because the columns are still in the grid an are available to the end user:
You will have to request an enhancement for the functionality you are looking for which is subject to additional support costs. | FOEX Grid - Refresh the Search Column's Title | | 27.11.2015 07:11 |
| The tree searching behaves differently to a regular grid since we return the tree hierarchy for found records. To achieve this we use a WITH statement and therefore do not support a WITH statement being defined directly in the query definition when the search functionality is enabled.
To workaround this issue please create a named view e.g.
CREATE OR REPLACE VIEW TREE_QUERY_VW
AS
WITH t AS
(SELECT *
FROM user_objects)
SELECT NULL pid,
object_id AS id,
t.object_name text,
NULL url,
NULL display_seq,
NULL info,
NULL css_class,
NULL custom
FROM t
/
Then update your report SQL definition to use
SELECT id,
pid,
text,
url,
display_seq,
info,
css_class,
custom
FROM TREE_QUERY_VW
| ORA-32034 using with-clause when searching in treegrid | | 26.11.2015 12:11 |
| Yes you are doing something wrong. You need to set the application item FOEX_MESSAGEBOX_RESPONSE with the value you want to return to the page item e.g.
I have updated your test case with a working example. | FOEX message box | | 26.11.2015 09:11 |
| Thanks for reporting this. I can confirm that the ORA-06502 is caused by the line chart series settings using decimal values with a "." when your application language uses a "," decimal separator e.g.
This is an issue was found and resolved in the latest hot fix for v2.1.1 - HFXP-2161. You will need to upgrade to resolve this issue. Please see the email that was sent yesterday which includes the download links for the hotfix or the full version containing the hotfix if you have not previously installed v2.1.1 | Chart problem | | 24.11.2015 10:11 |
| Can you please put the page in APEX debug mode, and have the browser console open when the page is loaded to show any javascript error messages and their associated information and report them to us.
If you have no javascript errors and the issue is isolated to your tree please refer to the following forum entry to disable the tree load mask: http://forum.tryfoexnow.com/osqa/questions/5421/210-tree | application do not start after installing last HotFix | | 23.11.2015 15:11 |
| In terms of grouping there was a change between apex 4.2 and apex 5.0. Grouping in 4.2 was controlled by include a class setting, but this was changed in 5.0 and should have been updated automatically during the installation of FOEX v2.1.0.
To manually resolve this and rely on the group setting in the modal dialog please remove the following class setting from the column:
In terms of grouping only a single column can be grouped but multiple columns can be enabled which you can change through the column menu if the following setting is not disabled in your grid attributes (not column attributes):
"enableGroupingMenu": false
| FOEX Grid Row Select Set Item Values not working well on grid with grouping enabled | | 19.11.2015 12:11 |
| I can confirm that this is an issue with Row Actions passing the wrong row record when a group is collapsed. A fix will be included in the next hotfix for v2.1.1 due out next week. | FOEX Grid Row Select Set Item Values not working well on grid with grouping enabled | | 19.11.2015 11:11 |
| We have not provided this capability declaratively but it is possible to provide a filter config object override on your grid column specifying the search value e.g.
"filter": {
"type": "string",
"value": "my search value"
}
e.g.
Please note: if you have enabled state saving then any change to the filter value by the user will override the default setting you provide in the column config. | FOEX Grid - Filter | | 19.11.2015 08:11 |
| Please prefix your URL's with either "http://" or "https://"
We do not support Non-prefixed URLs. | Hyperlink issue | | 18.11.2015 09:11 |
| Please see the following answer: http://forum.tryfoexnow.com/osqa/questions/3509/foex-form-no-changes-detected-message
Create a text message (for your application languages) named: FOEX.FORM.NO_UPDATE_CHANGES under globalisation in shared components with a value of %0 which will be translated to NULL and no message will be shown. | How to get rid of the message "No changes detected..."? | | 16.11.2015 15:11 |