Application Express :: How To Create Tabs With Drop Down Submenu Items
Dec 20, 2012how to create tabs with drop down submenu items like the ones we have under products tab in the link below.
[URL]
ADVERTISEMENT
Application Express :: Convert Tabs In The 2nd Level To Drop-Down Menu As App Builder Theme
Nov 17, 2012Given:
- Apex 4.2
- Application Theme: Bluejay-22
- Page Template Class: Two Level Tabs
Required:
- Convert 2nd Level Tabs of (Bluejay-22 Theme) to be Drop-Down Menus as in (Application Builder Theme)
- Where can I find documentation for app_AppMenuMultiOpenBottom3
Current Situation
- Only the first level tabs are converted to match the (Application Builder Theme).
- The Drop-Down menus of the second level tabs are not working
Steps tried
1) link the following CSS's into the Header section of the Page Template of (Bluejay-22)
<link rel="stylesheet" href="/i/css/apex_builder.min.css?v=4.2.0.00.27" type="text/css" />
<link rel="stylesheet" href="/i/css/apex_ui.min.css?v=4.2.0.00.27" type="text/css" />
<link rel="stylesheet" href="/i/css/apex_ui_builder_home.css" type="text/css" />2) link the following Scripts into the Header section of the Page Template
<script type="text/javascript">
[code].....
Application Express :: Create Items Context Help Editable Report Or Report And Form App
May 9, 2013How do I create Items context help editable report or report & form app?
what is its table?
Application Express :: Hide / Display Tabs?
Jun 13, 2012In my application, I have SSO authentication. However, I also want to restrict access to certain pages (tabs). What would be the best approach for this? Secondly, How can we hide/display tabs in the application?
I am on 4.1/11g
Application Express :: Submitting A Page Via Tabs
Aug 13, 2012Isn't it the case that clicking on a tab submits the current page, using the tab name as the request? I'm getting it to work some of the time but not always. In particular, it seems to work if the execution point is "On submission before computation" but not when the execution point is "After submission".
Here is what I did: I created a new application with two pages, each of which has a tab. Page 2 has nothing in it. Page 1 has an item, a button and two PL/SQL processes. Process 1 is unconditional, and sets the item to 10. Process 2 is conditional on the tab named "T_PAGE2", and increments the item by 5.
If both processes execute "on submission before computation" then everything works correctly:
-- If I click on the button, then the item is 10, indicating that only process 1 fired.
-- If I click on the tab to page 2, then the item is 15, indicating that both processes fired.
Now suppose I change them so that the processes execute "after submit". Then the button still works, but the tab doesn't:
-- If I click on the button, then the item is 10, as it should be.
-- If I reset the item value to 0 and click on the tab to page 2, then the item doesn't change, indicating that neither process fired.
Note that I have no computations or validations in my application. My only conclusion is that when you submit via a tab, there is some sort of internal validation occurring that keeps the processes from firing.
Application Express :: 4.0 - IR Saved Reports As Tabs?
May 7, 2013I am using APEX 4.0 and have a task of implementing the old tabs (older versions of APEX) for the IRR when they are saved. My users are not a fan of the select list when the IRRs are saved. I have located a site [URL] .....
that has this implemented but the tabs are not displaying within my application on apex.oracle.com, only the saved report names with no spacing. getting the tabs to display and/or possibly adding a dash (-) between each saved report name?
I added a Report Region as a 'PL/SQL Dynamic Content' and added code below in the Source. Am I missing anything to get the tabs to display like the example?
DECLARE
CURSOR cur_saved_ir (p_app_id IN NUMBER, p_page_id IN NUMBER, p_user IN VARCHAR2)
IS
SELECT '<span id="'||REPORT_ID||'" onclick="gReport.pull('''||REPORT_ID||''')">'||
[code]...
Application Express :: Open Lists In New Tabs / Pages?
Jun 5, 2013We have created a lists (shared objects) with a couple of links which is displayed on all application pages. It is easy to maintain. My question is that the links open in the same page. I was hoping we could use something like a "Target=_New"..I guess the only other way would be to manually code this as a HTML region in each page using <a href> as the last resort!
View 3 Replies View RelatedApplication Express :: Getting Application Items To Work With Login
Jun 20, 2012I've been creating numerous sample applications. In my latest one, I've been working on custom security schema and it's been working great for the most part. The one issue I'm having is passing login values into my application items. Though I don't receive any error messages or anything, upon checking the value of the application items via the session button, they never contain anything. The code I have in place on my login page is as follows:
begin
select username, user_id
into :F56_USER_NAME, :F56_USER_ID
from GS_USERS
where username = lower( rtrim( ltrim( :P101_USERNAME ) ) );
[code].........
Application Express :: Bug While Copying Items On A Page?
Oct 4, 2012When I create a new page item via copying from existing page item it fails with the below error code, if there is > or < character in the source of the existing item.Error Source contains <, > or " which are invalid characters. It works fine if I create new item using wizard and then have the same source. I use div tags in the source of my display only items.
View 3 Replies View RelatedApplication Express :: Items Align In Region?
Dec 18, 2012I have 2 regions in my application one is html form region and another is tabular form .I created 6 items in html region and created DA for the items to hide according to the value of items and then created tabular form
find below the sample link
[URL]...
user name: aneesmohamed.m@gmail.com
psswd: symphony
once i select the first item(declaration letter) it will show the second item (applicacable) perfectly,but when i select applicable as yes and discrepancy then all the items become misplaced,
Application Express :: 4.2 - 200 Page Items Limit
Jan 8, 2013I have a master-detail form which was getting close to the 100 items per page limit in Apex 4.0 which I then scaled back and got to work properly. I had thought that I could start adding more columns to the detail part of the form since 4.2 was supposed to have increased that limit. I am finding that this does not seem to be true at least in the case of this particular form. I tried increasing and started getting 404 errors when trying to save data--same symptom I had had with 4.0. I am back nearly to the same # of columns I started with--and nowhere near the 200 limit. Columns are month by month projection data that I had hoped to extend with the increased page item limit.
I missing something required to take advantage of larger page items limit? Do I need to use one of the new templates?
Application Express :: How To Print Page With Report And Some Items
Oct 28, 2013db11gxe , apex 4.0 , firefox 24 , I have a page with a report and two items , and i want to print the whole page (the report with the items) , can apex do so ?
View 1 Replies View RelatedApplication Express :: Clear Page Cache - All Except Specific Items?
Feb 21, 2013APEX 4.2.1 On a page with dozens of editable page items, when branching back to the same page on-submit, is there a way to clear cache for all items except a few (key) items? The branch attributes (via the f?p= syntax) support clearing cache for the entire page and setting specific item/value pairs but no support for exclusions.
View 2 Replies View RelatedApplication Express :: Dynamically Hide Show Page Items
Dec 14, 2012Im tring to dynamically hide/show page item. I searched and found something but it not working for me. Im using apex 4.1 and below described are work I did.
In my page (form) I have 5 fileds iitems.
- Customer No
- Edit
- First Name
- Last Name
- Address
I want to hide First Name, Last Name, Address based on the value in Edit. Let say if user selects "Edit First Name" then First Name must get visible while Last Name & Address hidden.
So I placed this line onChange="$f_Hide_On_Value_Item(this,'LASTNAME,'LN')" in page item EDIT> Label > HTML Table Cell Attributes
But it not working for me? Where am I go wrong?
Application Express :: Shuttle / How To Reference Selected Items On The Right Side
Sep 13, 2012I have a simple shuttle:
1 Adam
2 Baker
3 Charlie
4 Delta
5 Echo
6 Foxtrot
Select Name D, UserID R from UserTable
The values are stored in a VARCHAR2 field MULTI_USER (for example 1:2:4:6) When I want to get the names back from the selected item, how do I reference the colon-separated items?
For example:
Select Name from UserTable
where UserID in (select MULTI_USER from MULTI_USER where MULTI_USER_ID = 1)
should return:
Adam
Baker
Delta
Foxtrot
Application Express :: How To Fetch Tabular Form Column Value Into Page Items
Sep 7, 2012I have created tabular form. I have set LOV for one column. Here my requirement is when i select the value from lov then it will fetch that value into page item.
I am using apex 4.1
Application Express :: Page Items Values Don't Get Submitted In Add_member Collection 4.2
Jun 10, 2013The values in the page item dont get submitted hence generate errors in my application , in apex 4.2 using collectionEg.
apex_collection.add_member(p_collection_name => 'ORDER', p_c001 => :P56_product_id, p_c002 => :P56_product_name, p_c003 => :P56_list_price, p_c004 => 1);
Can there be a reason why ?
Application Express :: How To Align Items In A Form Page With Respect To Regions
Oct 16, 2013I have 20 item fields in same form. i need to align them in sequential manner. For example x y z abcl m o p q r s xyzabclmopqrs are the items to achieve this what i have to do...
View 2 Replies View RelatedApplication Express :: Default Value For Page Items Doesn't Get Set When Session Is Cleared?
Nov 15, 2012I am facing this problem, not sure how to solve this. Basically, the default value of the "items" on the page don't get set when the session is cleared and I visit the page for the first time.
So when I check the session for the first time, all page items are null. But when I revisit the page, the page items gets set sometimes.
Application Express :: Dynamic Actions Call A Javascript Function On All Text Items
Feb 21, 2013On a tabular form I have 50 columns each an input box , (basically 50 weeks of the year)
in these boxes I want to make them numbers only and max length 2
currently I have in the ELEMENT ATTRIBUTES for each column
OnFocus="javascript:this.maxLength=2"; onKeyPress="return numbersonly(this,event)";
( I have a function called numbers only in page 0 )
what I would like to do , to make it more maintainable is to remove all the calls in the element attributes of each column
and put it in 2 dynamic actions how would I go about this ?
I have tried using jquery selector of input:text to call javascript code on both events , Get focus and Key Press for every text box but its not working .
Application Express :: Navigation Through Drop Down Menu Via Tab Key
Jul 3, 2013I'm looking for a solution to navigate through the drop down menu (APEX-Region-Plugin two level menu) by using the tab key and short-cut keys. How it could work?
View 0 Replies View RelatedApplication Express :: Slideshow Is Covering Over Drop-down Menu?
Nov 11, 2012I am use this slideshow within my application [URL]... and this the slide source [URL]...
and use this CSS menu [URL]... and this the css menu source code [URL]...after working the Slideshow is covering over drop-down menu .
if you want to see in action [URL]...
Application Express :: Drag And Drop Interactive Report
Oct 8, 2013i would like to implement drag and drop for ordering the rows.It is a quit complex query behind the report (joins, ect.) I need a hidden item like this
apex_item.hidden(1, rowid)
AS Sort The problem is, that rowid is not allowed here (ORA-00918: column ambiguously defined).Because of that article I am sure the joins in my query are the problems ORA-00918: column ambiguously defined But I need this rowid for the sorting process.How to implement Drag and Drop I have learned from here:Read Article - Drag & Drop tabular form rows.
Application Express :: Drag N Drop Graph In Gantt Chart?
Aug 26, 2013I'm gonna create a Gantt chart on Oracle APEX and want to re-size, move the graph into other line..how to control the graph itself (just like javascript, ajax and anychart API...) URL.....
View 0 Replies View RelatedApplication Express :: Unable To See Items Of Detail Form In Master Detail Form In Page Details?
Oct 31, 2013I created a master-detail form using wizard in oracle apex 4.2 Now I want to attach an LOV to one of the items of detail form, which is visible on the same window as of master form. To do so, I need to first find the item in detail page, details of which are not available in page definitions. I can see all the items of master form but none for detail form in "Page Rendering" section.
View 0 Replies View RelatedForms :: Frm-31640 (Submenu Name Not Specified)
Oct 18, 2011I am getting an error frm-31640(Submenu name not specified) while running the form.
View 1 Replies View RelatedApplication Express :: Create Charts With 4.1?
Jan 29, 2013I need to create a Radar Chart, this kind of chart isn't avaible on APEX then, I should buid it, I have found some models of this chart, but I'm not getting sucefull when I try to use the data from my database.
I'm using APEX 4.1.
Application Express :: How To Create Customize Report
May 10, 2013I am having the table columns called
level1_name, level2_repemail, level2_name, level2_repemail, level3_name, level3_repemail,
using this columns i would like to create a report region as mentioned below.
------------------------------------------------------------------------------------------------------------------------------------------------------|
TITLE |
-----------------------------------------|---------------------------------------------------|--------------------------------------------------------|
Lvl 6 | Lvl 7 | Lvl 8 |
-------------|---------------------------|---------------------------------------------------|--------------------------------------------------------|
Name | Rep | Name Rep | Terr Name Rep |
-------------|---------------------------|-------------------|-------------------------------|--------------------------------------------------------|
AP | aaa@gmail.com | AAA | bbb@gmail.com | AAA bbb@gmail.com |
AP | aaa@gmail.com | BBB | bbb@gmail.com | BBB bbb@gmail.com |
AP | aaa@gmail.com | CCC | bbb@gmail.com | CCC bbb@gmail.com |
AP | aaa@gmail.com | DDD | bbb@gmail.com | DDD bbb@gmail.com |
-------------------------------------------------------------|-----------------------------------------------------------------------------------------|
how can i create this type of report.
I am using ORACLE 11G, and APEX 3.2 .
Application Express :: How To Create 3D Column Chart
Sep 6, 2013MONTHSTAT_NAMEPERCENTAGE_OF_TOTALApr-08USER_TIME35.43Apr-08SYS_TIME3.74Apr-08BUSY_TIME38.33Sep-13USER_TIME42.92Sep-13BUSY_TIME45.54Apr-08IOWAIT_TIME20.12Aug-13SYS_TIME2.43Aug-13IOWAIT_TIME0.04Aug-13BUSY_TIME45.05Aug-13USER_TIME42.59Sep-13SYS_TIME2.52Sep-13IOWAIT_TIME0.04select null, month, stat_name, Percentage_of_Total from oshistory
I want to create 3d column chart for above chart.
Application Express :: How To Create Sentry-Function
Jul 18, 2013I want to build a custom authentication scheme which combines the funcionality of of SSO and a custom authentication function.
1. If the HTTP Header Variable REMOTE_USER is set, this user should be a valid logged on user. (Single Sign On functionality)
2. If the HTTP Header Variable is not set, the LOGIN-Page should appear. (local user Administration)
3. The user/password combination from the login page should be validated by my own authentication function I think I have to create a sentry-Function, which is a combination of the sentry-functions which are used in the schemes "custom" and "HTTP Header Variable". I tried to find an implementation of these functions in the APEX_040200 database scheme, but without success.
