Application Express :: Can't Get Current Value Of Item
Aug 14, 2012
i user javascript to set a item value by a Partial Page Refresh .then i want to turn to another page by a button and Transfer the item's new value to the second page's item,but the value of the item is always teh old value but not de new value,how can i get the new value of the item first.
I have an application that I'd like to prevent activity in after a certain time of day, say 3pm. Is there any way I can force logout of all current users and then prevent re-login until 9am the next day (short of deleting all of their login credentials and then recreating them the next morning)?
I would like to hide/show tabs according to users' page privileges list. So I need get current tab ID or tab Name in runtime environment to know if show/hide it for current user.
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
I have an application item that receives a web service result. This result is like 'MARIA','JOSE','JESUS'. I'm using this string into the parameters of the interactive report, but this is not recognized. I'm showing the content of the application item into a pl sql region and the content is 'MARIA','JOSE','JESUS', when I include this application item into the query, the IR shows me 'MARIA','JOSE','JESUS'
I try the solution and it works fine but I lost tree functionality that saves tree state (Selected Nod Page Item), value of this item is correct but async operation reset tree state.
I am experimenting with the 4.2 version of Apex at URL.....
I have created a tabular form (based on a view with an instead of trigger) and have restricted this form to "Update only" mode. Whenever I modify a field value and submit the change I get the error "Current version of data in database has changed since user initiated update process".
it is possible to have two Validations one Page Item. Also I need to execute them one by one. If one is passed then go to the other and validate that one.
Example:P20_FORM_ACTIONP20_REOPENP20_REASON Validation 1: P20_REASON != 0 with condition P20_FORM_ACTION = CLOSEIf Validation 1 is passed then go to Validation 2Validation 2: P20_REASON != 0 with condition P20_REOPEN = YES
If Validation 2 is passed, then submit the form otherwise get error. is possible in Application Express 4.2.2.00.11. I tried to put the validations as described above into my application, but it did not work. Only one Validation was executed.
in my application I have several pages with the item of date. How to ensure that all items had the same date for all pages and can be set on each page ?.
Application Express: 4.1.0.00.32 DB: Version 10.2.0.4.0
I have a from with some fields (VELD01, VELD02...VELD11) and a page process that fills that field. I want to make that more dynamic using a loop. Is it possible to use some 'dynamic SQL' like:
l_cnt := 1; for r in c loop P1210_VELD0||l_cnt; l_cnt := l_cnt + 1; end loop;
Im my application, after login, I have a hidden & protected item whose value I am setting based on a logic. Also I would like to access this item's value in a application process, so session will have this value. Now I do not want anybody to be able to change the value of this item. For Eg, if my item was P1_RESP, I was able to change its value in the following way, I have an edit link on somr IR, where I redirect to another page passing some values and the URL looks like : [URL] After the browser loads, I can edit the above URL to below and click enter, [URL]
I am using its value in a query by using sql collection array. My requirement is that I need to hide that shuttle. But when I hide the shuttle, its value is not retrived by the query.
I have a situation where I need to reference a hidden item in a List of Values (for a pull-down list) SQL statement. It doesn't seem to be working properly. Here is what I have:
1) Using a dynamic action, set the value of a hidden item based on the change of Select List 1.
2) Select List 2 has a parent LOV item of Select List 1, and the Select statement for Select List 2 uses the hidden item that was set from the dynamic action above.
I can see that the dynamic action is working correctly. But when I change Select List 1, the Select List 2 does not show any values from its LOV.
I'm wondering if the LOV for Select List 2 is not working because the item used in the SQL statement was set by a dynamic action?
I have created a workflow which is going through 12 pages. At each page the user needs to choose his variables.
This could be the y-axes, x-axes, amount, surname ... etc. The variables are given to the next page via branch to next page process. Everything works well until I need to create an interactive report out of the chosen variables.
Lets say I have a variable called :P7_XAXIS with static LOV :
Amount,Amount;Date,Date;quantity,quantity
Page 8 is my IR. If I try :
Select :P7_XAXIS from mytable This will not work.
But if I try
Select Date from mytable This will work. Why? In my workflow there are several variables that can be used in a where condition. This also works. But I need to access the values before the condition and I also need to get a chart out of it.
<script language="JavaScript" type="text/javascript"> function f_setglp(pThis,p_app_item,p_other_record_level_item) { var curr_id = $x(pThis).id; // OK ! var curr_glp = $x(p_app_item).id; // returns undefined var curr_orli = $x(p_other_record_level_item).id; // returns undefined
[Code]...
The Javasxcript function fires OK on click in the "Product" attribute but: PMO_GLP_PK is an Application Item that Javascript can´t reference as I called YES_NO is another tabular form attribute and the reference returns also "undefined"
2. Data entry form created using page items. - This page is used to create new users This page contains many items but issue with only two items. P10_LOGINNAME - Textfield P10_PASSWORD - Password
These items are used for creating loginname and password for new user. When i am logging with admin user ,Chrome browser prompts for save password or not save password
1. When i am logging with save password option then LOGINNAME and PASSWORD of Login page is reflecting on the LOGINNAME and PASSWORD of Data entry page.
so how can i clear the LOGINNAME and PASSWORD item on Data entry page after login.I have tried to set blank to these fields after login
I have some troubles with a "Set Value" Dynamic Action. What I want to do is set a Page Item with a specific variable derived from javascript. So basically I have a javascript variable 'test' that is being changed in javascript code. I am using a dynamic Action "Set Value" to set this value into a page item. As source, Im using "Javascript Expression". It is working, however, the Set Value Dynamic Action with JAvascript expression does not reflect this change in the session, so the page item is not updated.
I tried:
$s -> does not work apex.submit -> does work, however submits the page. I need to submit only the Page item.
I would like to let the customer edit the item help text. Is it possible to retrieve item help text from my own custom database table based via a PLSQL function call or something similar?
I would like to ask if is possible to translate the "Browse..." button of File Browse item.
For me it seems that the button cannot be translated to a different language. I have tried to export the XLIFF and there is no string like "Browse...", also I have tried to edit it manually in translation repository, but the string is not present here.
I have a table which contain 3 columns, see below:
id primary key pic1 blob pic2 blog
there is 1 row in it(id=1), just for display 2 images.
Uploaded 2 images into above Blob fields by file browse function. Now, I want to show the 2 pictures in a Region by using display image item P1_AR, but it didn't work.
Based on: BLOB Columns specified in item source Alternative Text Column: null Filename Column: null BLOB last update Column: nullSource used: Only when current value in session state is null Source type: SQL Query(return single value) Source value or express: select dbms_lob.getlength(PIC) from cp_pic where id=1
I got the error below after runing: ORA-20999: P1_AR has to have a valid BLOB column as source
I have a shuttle control (P8_SHUTTLE) that lists then names from scott.emp.
Now I want to create a dynamic action that fires when I click on one of the names on the left side of the shuttle control.
I want the dynamic action to recognize the name of the employee that was clicked, and then set the value of a text item (P8_LAST_VALUE) to that ename. (Eventually I want to display the department of that employee in the other text item).
Here are screen shots of my DA:
[URL].....
Currently, when I click an item in the shuttle control, the text item P8_LAST_VALUE remains blank.
I had a complex drill-down dashboard where I was setting page items through $s(Page Item, value) from the Chart Links. But when I did the same thing in APEX 4.2 EA on [URL]...it is simply opening a blank page. whether in 4.2 that Java API has been removed?
I have created two regions in one page. I created some items but would like to share the items for both regions. When you create the item, you have to select which region it belongs to. Those items are supposed to be used by both regions, so I wonder if it is possible to share the items instead of creating the same items for region 2. I know I can create application item, but how to share items among different regions in the same page.