Application Express :: Single Value As Checkbox Or RadioButton That Submits Page?
Jul 18, 2012
I need a page item with a single value that submits back to the page, so that I can conditionally display other page items.I know a traditional 'Button' would work, but the a checkbox or Radiobutton would be my preference.
Here is where I am stuck.
CHECKBOX - I have used Dynamic Events to hide/show page items, but in this case I need a SUBMIT.
RADIO BUTTON - This works great with either the Redirect or Submit option, but I only have 1 value, so I what it act like a on/off button, where if it is currently selected, and the user clicks it again, it changes to unselected..
View 1 Replies
ADVERTISEMENT
Oct 17, 2012
I have no authentication required for my application, but want to secure a few pages.
On the page I wish to secure I have specified that user should not be a public user.
When I click a link to the page I do get a login box, but I seem to be able to enter any old rubbish and still proceed to the page.
How do I secure an individual page without a general authentication scheme at application level, so an Apex user account is needed.
View 5 Replies
View Related
Sep 29, 2012
My development instance's APEx version is 4.1. I have two checkbox items works on cascading LOV. The cascading works very well as long as if I do not come back and check anything from the first checkbox item after I checked the second checkbox.
If I do, the cascade LOV refresh uncheck all checked values from the second box. My question is, how can I preserve the second check boxes checked values before refresh?
View 0 Replies
View Related
Sep 12, 2012
I have stacked into something: if there is a way to define a single row form page based on table in which I could query and update without using a tabular page (to call the single row form). I want only to use only one page. Does APEX has this functionality?
View 5 Replies
View Related
Jan 27, 2013
running a jquery code after submit button has successfully completed, how do i integrate these 2 events ? clicking the submit button and if submits successfully execute the small jquery code based on the same submit button
View 33 Replies
View Related
Aug 27, 2010
After setting up a data entry page,The logic in my page requires that all the records in my tabular form should be displayed .The tabular form is based on a collection, and the user selects rows through a checkbox.Any reload of the page due to pagination will break the logic, as some calculation and display events occur during page load, based on the previous page.
I need to display about 25 rows.I have changed the report attribute to display 50 rows, but it displays rows only up to the bottom of the screen, i.e. 11 rows.
Unfortunately I only just added some new rows and saw this behaviour else I would not have gone that way, as I expected APEX to display all rows if required.
View 19 Replies
View Related
Oct 25, 2013
I have a Page containing 3 reports and I was wondering if it is possible to re-execute only one of the these reports using a button or preferably a Select List which allows me to choose which of the 3 reports I wish to 'refresh/re-execute'. I may be totally wrong here but I assumed that choosing the option to submit a Page will cause all regions to refresh i.e. re-execute the SQL queries they are 'based on'.
View 6 Replies
View Related
Sep 4, 2012
I have problem with getting values of checkbox. I have search page where are some numbers field, date pickers, radio buttons and checkbox (P40_ OE) when I click search button I want to get report with filters like
select t1.id, t1.name, t1.company
from table1 t1, table2 t2
where t2.id = t1.id
and t2.oe in list of values from P40_OEIn checkbox I have 11 options to choose. I work in Apex 4.1.
How can I make this search or filter report working?
View 2 Replies
View Related
Jan 15, 2013
I am working in apex 4.2.1.
I'm having an odd problem with a checkbox on a tabular form. I created the checkbox by setting hte display as to "Simple Checkbox". The value of the underlying column sets to "Y" wehn checked and "N" when unchecked. This is what I want. The next thing I was trying to accomplish is to call a javascript function when the checkbox is clicked. So I put onclick="calculateTotal(this);" in the element attributes field. The code that it is calling is listed below. When I run the app and check the box I can seee I am entering the calculate Total function. Each of the alert functions is displaying what I would expect until I get to alerts 'IAH5' and 'IAH6'. For each of those I get an "undefined" in the alert.
So to see if this had something to do with the checkbox and added an onchange="calculateTotal(this);" to another field in my tabular form and ran it. This time I did not click on the checkbox but went into the field that I put the onchange on. When I changed this field and navigated away from it the function worked as I would expect. It displayed the appropriate values for each of the alerts and updated the fields on the screen as designed.
<script type="text/javascript">
function calculateTotal(pThis)
{
alert('IAH1');
var vRow = pThis.id.substr(pThis.id.indexOf('_')+1);
alert('IAH2');
[code].......
View 6 Replies
View Related
Oct 24, 2012
I am running blank with this one.
I have a checkbox item called P46_PAGE2 with static LOV STATIC:;1
How do I check if it is check using Javascript.
View 2 Replies
View Related
May 27, 2013
m learning how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:
<input type="checkbox" name="*f10*" value="3" />
And this one stands for array name "g_*f10*".
However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly :(
My generated HTML snippet:
<input type="checkbox" id="P6_ANSWER_0" name="*p_v04*" value="3"/>
View 4 Replies
View Related
Jul 16, 2012
I have question about checkbox in classic report. I need to choose only one checkbox in every row, hot to ensure that only one checkbox can be checked at same time?
Checkboxes are defined in SQL query as:
apex_item.checkbox(1,msisdn,'UNCHECKED') as clear,
apex_item.checkbox(2,msisdn,'UNCHECKED') as to_analysis,
apex_item.checkbox(3,msisdn,'UNCHECKED') as to_barring
here is the picture:
[URL]........
View 9 Replies
View Related
Nov 18, 2013
How to check off checkbox with JavaScript. I tried
1) $("#checkboxID").prop('checked' , false) (jQuery)
2) $("#checkboxID").attr('checked' , false) (jQuery)2) document.getElementById("checkboxID").checked = false;Checkbox's list of values: STATIC:;1
Checkbox always states checked. When I append 'checked="checked" ' attribute (or simply checked) to this unchecked checkbox in Firebug nothing happens. Why ? I execute JavaScript code in Dynamic Action on button click. All other controls (textareas and textfields) are cleaned successfully except this checkbox. "Effected elements" property includes all needed items.
View 3 Replies
View Related
Oct 18, 2013
i have created form with table page to enter hotel details there is on 6 check box which are not database column .i have create these check box to keep days details when hotel give service .so i have use
LOV FORP1_MON STATIC2:;1 MONDAYP1_TUE STATIC2:;2 TUESDAYP1_WED STATIC2:;3 WEDNESDAYP1_THR STATIC2:;4 THURSDAYP1_FRI STATIC2:;5 FRIDAYP1_SAT STATIC2:;6 SATURDAYP1_SUN STATIC2:;7 SUNDAY
i have one more column operating days where i have use computaation to keep operating days.
:P1_MON||:P1_TUS||:P1_WED||:P1_THR||:P1_FRI||:P1_SAT||:P1_SUN
these 6 check box are used Source used :Only when curren value in session state is nullSource Type : Static Assignment (Value equals source attibute) Problem are when i create new record then these 6 check box are not clear cache and when i update any record value are not clear cache . i need when i create or update recor then all 6 check box should be null after keep recor.
View 1 Replies
View Related
Jul 11, 2012
How do you retrieve all data from one multiple checkbox to another? The method I'm using returns one choice even though multiple have been chosen.
View 2 Replies
View Related
Nov 14, 2013
I have a check box in which if i select more than one check box, based on that multi-select values, i wanted the next item values to get displayed. I have set up an example at
[URL]........
In this page, if i multi-select "place" check box i wanted the "departments" to get displayed according to the above multi-select.If i do a single select in check box, i am getting the corresponding departments but i am not getting it while i select multiple check boxes.
View 11 Replies
View Related
Nov 13, 2012
i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
View 3 Replies
View Related
Jun 4, 2013
We are using Application Express 4.1.0.00.32 on Wondows XP and Oracle version is 10g. I've created a report in APEX and the user is insisting on putting a header on each page in PRINT of the report which should contain the "from date" and "to date", which are present on the select criteria on top.
Can I somehow add from_date and to_date items in Title so that when they print the report, they'll see the from and to dates in the title?Or is there someother way to do this. The report is an interactive report with a control break and user prints the report with file->print.
View 1 Replies
View Related
May 21, 2013
In the login page, I want to add a text "Register" that when clicked will send the user to another page to register.
With a button, its simple because its inbuilt there,but I do not want a button,just this: Register
I want also to have the text in color not black.
View 6 Replies
View Related
Jul 16, 2013
I am new to APEX and I am developing an application to manage Oracle database user accounts. I have a page (8) that has text items for the username and the database name. I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account. I have another button that should:
get the value of the username - P8_USERNAMEassign it to an application item - FIND_USER_IN_DBredirect to page in application - to page 11
The issue is that FIND_USER_IN_DB does not get populated and page 11
which is a simple report with the following query:
SELECT *FROM valid_dbWHERE username = :FIND_USER_IN_DB;
How do I accomplish this?
View 8 Replies
View Related
Aug 17, 2012
I have different public page (page1) and different page for authorized user(page5).Upon successful login after process validation ,computation it should navigate to authorized user page 5 but the branching does work it keeps on going to page 1 .
View 8 Replies
View Related
Dec 26, 2012
I worked with apex 4.2 and i create normal classic report with one checkbox column and one column change it to select list(named loved) now i want when user change list take value of checkbox item and show it in message .
SQL for report
{
SELECT
'<INPUT TYPE="checkbox" NAME="f01" VALUE="'
||SEQ
||'">' SEQ,
ID,
DEPT_NO,
EMP_NAME}
i change the column attributes of Dept_NO to Display as Select list of department name (named lov). Now i want when user change name of department the value of SEQ SHOW IN ALERT MESSAGE
i create JavaScript on the page
function test(pThis) {
var f01_value = $('select[name="f01"]').value;
alert('#SEQ : '+ f01_value);
}
</script>
I call this javascript function when list change but the value undefined..
My Question :
How can get this value Or any value of item in reports ?
View 6 Replies
View Related
Aug 23, 2012
Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.
Issue here is unable to find a way to set the page range item values based on the quarter field selection
how to reset the page item fields.
View 0 Replies
View Related
Mar 23, 2013
i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?
View 1 Replies
View Related
Jul 23, 2013
I'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button. The dynamic action sets two values in a table and then I would like to redirect to another page. Setting the values works fine. The code is below:
declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information, CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data"
how to redirect to a page from within PL/SQL . None of them result in success.
View 2 Replies
View Related
Mar 6, 2013
How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?
View 3 Replies
View Related
Nov 13, 2013
I have "After header" process (with PL/SQL code) in "Page Rendering" section and want to navigate to some page after this process has been completed. I created a branch (On Submit: After Processing) with Target Type: URL. But this branch is executed only after "Page Processing", not after "Page Rendering". Maybe , there is any APEX API functions for pages navigating..
View 2 Replies
View Related
Feb 6, 2013
I'm using Apex Version: 4.2.1.00.08
I created a page with 2 tree regions. Both trees use different items and different queries. The first tree is displayed correctly. But the second one just contains the first item, if I don't display the first on via customizing the page or if I change the order of the trees the previoulsy invalid tree is shown correctly, but I didn't find a way to display both correct at the same time.
View 1 Replies
View Related
Sep 5, 2012
Trying to create a "page zero". Usually in previous releases this is done executing the following:
1. On the Workspace home page, click Application Builder.
2. Select an application.
3. The Application home page appears.
4. Click the Create Page button.
5. For Select a page type, select Page Zero.
Note that the Page Zero option only appears if the application does not have a page zero.
6. Click Finish.
Since the upgrade to 4.2 this option is not available or has move. (I do not have a page zero already created.)
View 2 Replies
View Related
Mar 20, 2013
I wanted to apply some CSS throughout my application by adding it in Global Page in APex 4.2
And I used
<style>
#t18InlineError {
color: rgb(243, 12, 12);
}
</style>
It doesn't work.
View 4 Replies
View Related
