|
| The FOEX Plugin Framework does use iframes when content can't be loaded in SPA mode i.e. loading into the current page.
This is a risk that you need to accept when building an application with the FOEX Plugin Framework. You can make a change to APEX to prevent pages opening in iframes to identify problem areas in your app i.e. pages that won't load, and re-design them. Alternatively you can argue that "Allow from same origin" is an acceptable compromise.
You should consider the threat level based on whether you are building an internal application or a public facing one.
| Clickjacking - Framable Page | | 17.02.2023 11:02 |
| This is your responsibility as the developer of the application to provide this functionality. We do not offer any advice on this subject, since the applications built with the FOEX Plugin Framework are primarily back office internal applications and do not require cookie consent.
| Ask consent for cookies | | 17.02.2023 10:02 |
| jQuery UI is shipped with Oracle APEX, and is not part of the FOEX Plugin Framework.
| Question on jQuery version 1.12 | | 17.02.2023 10:02 |
| The problem you are facing is most likely caused by CATEGORY not being part of the form. I don't think you should be doing a fetch after every server request.
You should base your form on a view and make the CATEGORY field read only. You may also need to refresh your grid combo after load, since you have a filter in it.
| Trouble with Grid Combo in Navigable Form | | 14.02.2023 11:02 |
| We have filed a bug for this issue and will resolve it in a forth coming hot fix release.
| Number field on form doesn't show PT format mask correctly (see FXP-4529) | | 07.02.2023 11:02 |
| You should be using the number field not a text field. Whatever value in the text field is used in session state, whereas with the number field it has a display value and a return value.
Is there a reason why you are not using the number field?
| Do math with 2 number fields that have format mask set | | 07.02.2023 11:02 |
| Have you enabled zooming? Please be aware that by default Sencha Ext JS does not support browser zooming.
| FOEX form scollbar displayed | | 31.01.2023 11:01 |
| Unfortunately there is no event that is fired when either button is clicked as it is a generic action that occurs on tab close, window close etc.
| I want to do something after "You have unsaved changes, Yes/No" | | 23.01.2023 08:01 |
| Thanks for pointing this out so quickly, a fix has already been sent to the Chrome Webstore using version 22.2.0.5
| FDA stop working on Chrome | | 14.01.2023 07:01 |
| We can confirm that we have upgraded trial to APEX 22.2 and installed a beta version of FOEX 22.2. There are some problems with our browser extension in Page Designer which we are working on resolving. This is why FOEX 22.2 has not been officially released.
You will be able to download the file from the support portal once we officially release this version. You can access all previous releases and hot fixes from the support portal: https://www.oracle.com/corporate/acquisitions/foex/support/
| FOEX Plugins Version 22.2 | | 09.01.2023 10:01 |
| Could you please send and email to support@foex.at stating your availability for a call to investigate this. Thanks
| Upgrade from 20.2.0.4498.00 to 20.2.0.4539.00 buttons do not lay out correctly | | 11.12.2022 09:12 |
| Please use the "FOEX FOrm Item Actions" plugin to add the class. Your class definition needs to ensure that you include the "important" flag on styling overrides since the important flag is also used by the theme roller e.g.
.yellowInputs input, .yellowInputs textarea {
background: yellow !important;
}
| Conditional class on FOEX page item when non-null? | | 11.12.2022 09:12 |
| The fastest way to get an answer is to provide a test case. You have our documentation app in your trial workspace, so you should just copy this app and modify an existing demo that is already setup.
You should add some debugging to your custom processing routine e.g.
apex_debug.message('p_crud_request.new_record(i).name=%s', p_crud_request.new_record(i).name);
apex_debug.message('p_crud_request.new_record(i).value_varchar2=%s', p_crud_request.new_record(i).value_varchar2);
You can also check the payload for the AJAX request that performs the form save to see the submitted items e.g.
| Does a Form submit all items including hidden, text fields shown as readonly? | | 02.12.2022 14:12 |
| The problem is that you are trying to do a form load on an item container i.e. there is no data to load. Instead you should be using the "FOEX Execute PLSQL Code" if you are wanting to set values in a form of this type.
| Form isn't refreshable if there is a Foex PopUp with static values | | 30.11.2022 02:11 |
| We are investigating this issue.....
| FORM creation error | | 23.11.2022 07:11 |
| You most likely need to set a fixed height on the region. Please create a test case reproducing the issue if you would like further help on this.
| How to use APEX Calendar Region in FOEX Page along with FOEX Grid | | 23.11.2022 07:11 |
| Can you please check your page/region templates in your theme and delete any duplicate entries e.g.
FOEX Page
FOEX Region
| Error when enable FDA | | 22.11.2022 15:11 |
| You can access the top (or parent) window using Javascript e.g.
| FOEX page connected to Apex page with Interactive Grid? | | 18.11.2022 14:11 |
| You need to change the page template, the default is a "FOEX Page" template which should NOT be used for regular APEX pages. This is because it adds a load mask by default that is only removed when a FOEX viewport region is defined.
| Creating a APEX only page in a app which has FOEX pages hangs | | 11.11.2022 13:11 |
| What Stew posted below is the official email we sent out which included your email address, we're not sure why you didn't see it, perhaps it ended up in your spam folder. To reassure you:
The FOEX plugin Framework will continue to be supported for bug fixes and future versions of APEX. In time there will be improved APEX functionality that you should consider using instead of FOEX components. The only significant change is that the FOEX products are no longer available for purchase.
| Future of FOEX | | 03.11.2022 15:11 |
| We would like to see your tree AJAX response, as this should include the information for the icons e.g.
Could you also please provide the tree query you are using, and also the HTML page source for the page when run in debug mode.
Thanks
| Strange behavior in FOEX Tree Grid application? | | 08.10.2022 07:10 |
| This is outside of our support as you have indicated you have not made any changes apart from ORDS. We suggest you review what your ORDS changes have been.
It's the theme files that determine the tree icons i.e. theme-foex-triton-compact-all_2.css
Perhaps they are pointing to an old version of the file, perhaps there's some caching issue. You should inspect the icon to see what the rules are e.g.
| Strange behavior in FOEX Tree Grid application? | | 07.10.2022 13:10 |
| It seems that there is a behaviour issue caused by the "checkChangeBuffer" being set to a non zero value when there is only a "checkChangeEvents" set to "change" only. We are fixing this and will provide it a hot fix.
Can you please confirm the version of FOEX that you are using?
| Date-Picker is handled not null even though it is null | | 07.10.2022 07:10 |
| We don't really follow your explanation, but this is more your design that is the problem and not a problem with the framework.
We suggest that you put a delay at the start of your sequence of actions to ensure that the date picker loses focus and events complete before the button click sequence occurs.
e.g.
| Date-Picker is handled not null even though it is null | | 05.10.2022 08:10 |
| We suggest that you will have to change the alias and use the column header label to control the column display. Please ensure that you do not use special characters for ID's in the future.
| Treegrid with unicode column alias raise error, FOEX 22.1 | | 04.10.2022 13:10 |
| It's impossible to say what the problem is without a test case.
Perhaps as a workaround to the issue you should consider disabling the ability to collapse groups. You can refer to the following 2 threads for how to do it:
https://forum.foex.at/question/how-to-disable-grid-column-group-from-coallapse
https://forum.foex.at/question/grid-grouping-collapsed
| Grouping in Grid raises javascript error | | 04.10.2022 13:10 |
| Do you have any shared LOV's i.e. defined at the application level that are of the type DYNAMIC based on a table (not SQL Query) e.g.
| Translation - error on windows containing Combo/Select list in translated applications | | 03.10.2022 13:10 |
| We can confirm that the issue affects the refreshing of a content loader region. This issue was introduced by the new file download action.
We are providing a fix for this shortly.
| Screen flickering when save form, foex 22.1 | | 03.10.2022 12:10 |
| Thanks for reporting that. We could find a bug in the FDA and fixed it with FDA version 22.1.0.2 which is available for Firefox right now and will be soon available on the Chrome store, too.
| Unable to Create Foex Page | | 16.09.2022 07:09 |
| A test case (or more details) would help us see what you are doing dynamic action wise (which event you are listening to) so we can see if there is a setup issue or a bug.
| Check if grid has rows | | 15.09.2022 06:09 |
| If you put the page in debug LEVEL6 or LEVEL9 you will see the query in the debug output.
It sounds like you should switch off pagination to avoid the "SELECT COUNT(*) OVER() AS totalrows"
If you check the demo on page 1030 in the documentation app: https://www.foex.at:443/ords/f?p=615052403:30:7819041688539::NO::P30_TAB_ID,P30_NAVIGATE_TO_PAGE_ID,P30_NAVIGATE_TO_PAGE_TITLE:GRID.PAGINATION,1030,Pagination
| Final Query Rewrite SQL for FOEX Grid? | | 15.09.2022 06:09 |
| The buttons should be auto managed. Are you dynamically changing the read only status? if so they require a grid operation e.g. load/refresh to activate/change the management status.
Buttons are only auto managed if they have the "Database Action" defined e.g.
If you are still having issues can you please create a test case.
| GRID allowed operations and buttons | | 13.09.2022 04:09 |
| It is always best to provide a test case showing the behaviour you are talking about. That way we can easily identify if it is a bug or mis-configuration or simply a setting change is needed.
In your case the after load event most likely does not fire until the grid is rendered (lazy loading). You can try changing the loading behaviour to load on page load e.g.
If you are still having problems, please create a simple test case so we can see your exact setup. Thanks
| Grid after load DA | | 13.09.2022 04:09 |
| Thanks for reporting this, we are fixing this issue.
| Upgrade to 21.2 FOEX reports errors | | 08.09.2022 14:09 |
| The grid combo is for showing multiple columns. A popup LOV is just using a display/return value i.e. 2 columns. This is because there was a restriction in older versions of APEX limiting the LOV to 2 columns only.
You could also consider using a list view region as an LOV, since you can select records and store the selections in a hidden page item. It would need a little extra setup with performing the selection on form load. This then means you can have your list of items always on display.
| Multiple column values in POPUP LOV | | 05.09.2022 07:09 |
| Please download HFXP-4564.zip from the support portal to address this issue.
Note : your date format should match your app level date format defined in the globalization settings for your application.
| FOEX calendar how to move to another year on a DA | | 31.08.2022 20:08 |
| You can do this by listening to the "FOEX Calendar - Day Click" event.
You can access the actual date using "this.data.dayDate". For example you could use a setValue action with the following Javascript expression
e.g.
Ext.Date.format(this.data.dayDate, 'd-M-Y')
| FOEX Calendar | | 31.08.2022 13:08 |
| Officially browser Zooming is not supported in Sencha Ext JS. This is because it calculates everything on pixel values and zooming results in factional pixel values on some resolutions therefore producing display issues.
Please keep this in mind for the future to always first check if Zooming has been enabled by the user and get them to reset it to actual size.
Good job finding the issue and answering your own question.
| Date field calendar not displaying years | | 31.08.2022 09:08 |
| You will be most likely hitting an ORA-600 or ORA-7445 error in your alert log. Please check the log. If this is the case it is a database bug which you will need to resolve with Oracle support.
| FOEX region cause connection disconnected on oracle DB 19.15 | | 31.08.2022 09:08 |
| As you have the ability to customize the template you have the ability to define your own CSS and rules to make it appear how you would like. You can also override some CSS classes to change the behaviour e.g.
ul.fx-listview
li.fx-listview-item
In your particular case, you would need to know the width of your items (plus padding/margins) that display 4 in a single row and set a fixed width on the list container e.g.
#MY_REGION_STATIC_ID ul.fx-listview {
width: 900px;
}
Our advice is that you should inspect the elements with developer tools and make changes on the fly to test what works e.g.
| How do you set the nr of cards from list view and control how many cards you want to display per line | | 22.08.2022 08:08 |
| We can confirm that this is a bug due to the internal calendar date format when parsing the date you provide.
We will provide a fix for this issue.
| FOEX calendar how to move to another year on a DA | | 19.08.2022 08:08 |
| You must install the FDA (FOEX Developer Addon / Browser Extension) e.g.
https://www.foex.at/i/foex/docs/FOEX%20FDA%20Installation.pdf
We also suggest that you look at the "First Steps" guide.
| Create FOEX Page button is missing | | 15.08.2022 10:08 |
| You might be able to do this using the "Javascript Initialization Code" by manipulating the "columns" array to change the order e.g.
Use a PLSQL region type to output your ordering Javascript function e.g.
sys.htp.p('<script>');
sys.htp.p('function myCustomColumnOrdering() {');
case
when :P1_ITEM = condition1 then
sys.htp.p('return ["COL3","COL2","COL1"];');
when :P1_ITEM = condition2 then
sys.htp.p('return ["COL2","COL3","COL1"];');
else
sys.htp.p('return ["COL1","COL2","COL3"];');
end case;
sys.htp.p('}');
sys.htp.p('</script>');
Then add your "Javascript Initialization Code" to your grid in question
function(options) {
var columns = [], columnOrder = myCustomColumnOrdering();
Ext.Array.each(columnOrder, function(columnId, index) {
Ext.Array.each(options.columns, function(column, index) {
if (column.dataIndex === columnId) columns.push(column);
});
});
options.columns = columns;
return options;
}
Note : we are just giving you an idea of what might work, we have not tested this code. You might also need to reorder options.fields in the same order as well. It is your responsibility to build on this approach and make it work the way you need it to.
| Can we change the grid columns order dynamically | | 10.08.2022 20:08 |
| The event you need to listen to in order to setup this plugin is "FOEX Grid - Before Edit" e.g.
Please setup a test case with what you are trying to achieve and we will assist you.
| how to use the set column value on column change | | 10.08.2022 20:08 |
| Your image is missing from your question, but to answer your questions:
1) No
2) No
If you would like to have these included they would require paid enhancements i.e. you can use your development support hours to request these changes.
| Autosize Group Header | | 08.08.2022 11:08 |
| You have incorrectly used the "FOEX Grid Alert on Pending Changes" when you should be using the "FOEX Form Alert on Pending Changes" as you are ignoring particular form items for changes. The grid does not support fine grained capability to ignore particular column changes.
To determine which page items in your form are dirty you should use the following code:
Ext.getCmp('FORM_STATIC_ID').getForm().getFields().each(function(field, index) {
if (field.isDirty()) console.log(field.getId());
});
In this particular case there is a problem with you grid combo setting other items, in this case the offending item was the "Hidden" item "P22_ID_SST" which needed it's "Warn on Unsaved Changes" set to "Ignore"
We also add a "Clear Dirty Status" on the Form to ensure that the form items are reset every time a row selection occurs e.g.
| "Warn on unsaved changes" set to "ignore" doesn't ignore changes | | 08.08.2022 11:08 |
| We will be releasing 22.1 of FOEX in about two weeks time. We are currently finalizing the release.
| Compatibility with 22.1 | | 03.08.2022 07:08 |
| Quick picks do not get updated on Form plugin refresh.
Your only solution is to use a content loader region and load your form then reload it when you want the quick picks updated.
| FOEX Page item Quick Picks update on Form refresh? | | 28.07.2022 18:07 |
| We are not able to support format masks on display fields. It has been this way since the 1st version of FOEX. This is due to the issue that it requires an actual Javascript typed value to be used, however the field only takes a static value it does not have a typed value like a Date or a Number.
We suggest that for display fields that you consider adding in your own custom renderer to control the way you want the field to be displayed e.g.
https://docs.sencha.com/extjs/6.5.3/classic/Ext.form.field.Display.html#cfg-renderer
You would add in your renderer in the custom config e.g.
| FOEX Display field does not honour format mask | | 28.07.2022 14:07 |
| We have to advise that faceted search is not supported with the FOEX Grid. We suggest that you use regular APEX reports to take advantage of this feature.
| Possible to use Apex Faceted Searches with FOEX Grid | | 26.07.2022 20:07 |