Application Express :: Oracle APEX_ITEM For Non Database Table Columns - User Entered
Aug 21, 2012
how to use APEX_ITEM.text for where the source for this comes from user input values and not for an underlying table.I have a report where three columns are coming from an actual table (one being a checkbox for selection) but then also have two additional fields on the screen that are not from a table but placeholder fields for user's to enter data.
For example, my query looks like this:
select apex_item.checkbox2(10,id),
name,
telephone,
apex_item.text(20,NULL) as "Date Contacted",
apex_item.textarea(30,NULL,5,80) as "Comment"
from my_table
I am not seeing any values for the two user fields when entering values and doing a view source?
View 2 Replies
ADVERTISEMENT
Jul 28, 2012
I created one collection report and in the report when i click on the next >> then the report will show the next columns to enter data in some columns but the data which i entered before going to next will not get retain (data is getting lost) when i come back by clicking << previous but i want the data to get retained even when i click on next >> or previous << in report so that i can enter large amount of data at a time in the report columns by clicking >> & << and click on submit button to save all the data.
View 3 Replies
View Related
Dec 6, 2012
I was making some page validation to APEX_ITEM manual tabular form. When every a validation executes it will clear all the data what user enters. What is the best method to hold the session values in APEX_ITEM.
View 4 Replies
View Related
Apr 30, 2013
I created a javascript to change background color upon double click on particular cell, and it works for normal tabular form.However I created another tabular form using APEX_ITEM and unable to replicate the same behaviour.. how to do that if I'm using APEX_ITEM?
View 2 Replies
View Related
Aug 6, 2012
I have been requested to create a tabular form, but end user should have ability to hide/show columns, also they should rename the column headers. So I have created a table with column name called "attribute1", attribute2", etc. Based on that table, create a tabular form, which has column header as "attrbute1", "attrbute2", etc.
Now end user wants to rename attrbute1 as he wants. And he/she also wants to have a link called "hide/show" next to the column header, so end user can control which column they want to hide/show. It is so easy to do that control from developer side, however, shift that function to end user from front end seems very difficult to me
View 0 Replies
View Related
Jul 6, 2012
How to use process to display the date parameters selected by the user to generate the report in Page title ?
View 2 Replies
View Related
Mar 29, 2013
I'm using Application Express 4.2.1.00.08
In the application, the authentication method used is the DB one, so the user (schema) must exist on the DB. This works fine.
For instance, I'm login as SCOTT
Creating the following query select upper(user) from dualshows that the real logged user is APEX_PUBLIC_USER and npot SCOTT.
How to create a connection with another "real" username ?
View 1 Replies
View Related
Oct 8, 2013
I have a report with single row having large number of columns . I have to use a scroll bar to see all the columns. Is it possible to design report in below format(half columns on one side of page, half on other side ofpage :
Column1DataColumn11DataColumn2DataColumn12DataColumn3DataColumn13DataColumn4DataColumn14DataColumn5DataColumn15DataColumn6DataColumn16DataColumn7DataColumn17DataColumn8DataColumn18DataColumn9DataColumn19DataColumn10DataColumn20Data I am using Apex 4.2.3 version on oracle 11g xe.
View 2 Replies
View Related
May 15, 2013
For auditing, I need to insert the user, among other data, into different tables. The thing is, I have an application with DB account authentication, so a real database user is connected, when auditing, the user field inserted is "ANONYMOUS".
Apex 4.2
EPG
Oracle Enterprise Linux 5.5
Database 11.2 EE
View 7 Replies
View Related
Sep 25, 2012
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".
View 6 Replies
View Related
Sep 12, 2012
Have got basic form on a table and have a textarea which holds Notes added by user.
So Notes database field is updated on Save / Apply changes button being pressed.But would really like any text added / appended to the Notes field to be prefixed by userid and date / timestamp.
Is it possible via dynamic actions or Javascript to have any new text added / typed to be auto prefixed as per above.
Would only want the first key press in the filed to trigger the auto-prefix and if added text was deleted then the auto prefix to be deleted as well ?? If user doesn't press Save / Apply changes obviously want to leave existing Notes as is.
View 5 Replies
View Related
Apr 23, 2008
how to retrieve values if user entered in Mixed case means (case insesitive)?
We don't have control when user enters values and it might be SMITH or Smith or smith or SmIth.
How can write the query to get this kind of mixed case data?
View -1 Replies
View Related
Jun 12, 2013
We are exporting our apex application inside the database in the Export Repository. what owner and table name are those export located exactly?
View 1 Replies
View Related
Aug 28, 2012
O/S: Windows 7 64-bit
DB: Oracle XE 11g2 32-bit
APEX: 4.0.2
=============
Trying to upgrade APEX within an Oracle XE database installation on Windows 7. The version of APEX that came with Oracle XE is 4.0.2. Trying to upgrade to 4.1.1 and, from the SQL*Plus command-line (ie. the 'Run SQL Command' tool which comes with Oracle XE), I try to run @apexins.sql.
It starts to run momentarily, then the MS-DOS windows just closes. Can not find any install log to determine the cause.
View 2 Replies
View Related
Jun 12, 2012
Env: APEX 4.1
For example, initially I created the reprot source as select c1, c2, c3 from t; later I added c4. But i was unable to figure out how to make c1, c2, c3, c4 become default displayed columns. I always have to click Action -> Select Columns, then move C4 from "Do not Display" to "Display in Report".
View 8 Replies
View Related
Apr 27, 2013
I am trying to branch a report in one page with a report in another page, the branching should occur when a field say version is clicked.
Now when version is clicked then i will pass the id of the column to another report which should use that id to show only that row with that id.
View 1 Replies
View Related
Apr 23, 2013
is it possible to create two head columns sql-pivot.
something like that...
SELECT * from ( Select position,cat_id, att_name as ATTRIBUTE, pro_name, value,competitor
FROM cat_attributes)
PIVOT (
max (value)
FOR (pro_name) IN ('MS 3','MS 4'))
for (competitor) in ('1','1');
View 0 Replies
View Related
Apr 4, 2013
I downloaded Oracle Database 11g Express Edition R2 to test Apex (I've never used). I want to know how to change the language of the version of Apex (integrated with Oracle Database 11g XE)? I would apex in French.
View 7 Replies
View Related
Mar 11, 2013
I have a table with 5 columns: Region, Country, total number of visitors, language, popularity.
The table is populated with various regions, countries and values. I want to display this information in the form of report in the following format:
#Visitors Language Popularity
Region +Country Region will be Europe, when the plus sign (+) against the country, France is clicked, the list should be expanded and display the country names such as Switzerland, Dublin, France, Germany etc. At the same time, before the list is not expanded the #Visitors , Language and Popularity should display the total sum for Region, Europe, whereas when the country (+) is clicked the values should be split across.
Ex:
#Visitors Language Popularity
Europe 100 100 100
+France
#Visitors Language Popularity
Europe
- Swiss 30 30 30
- France 30 30 30
- Germany 40 40 40
How this can be done in APEX?
View 3 Replies
View Related
Jan 30, 2013
I am trying to find a way to set the selected columns, like what the action menu -> select columns does. I am planning to build a AJAX Tree with check boxes, but I don't know where to pass that data to to update the selected columns. I'm sure their is a magic apex function that is passing the values of the current shuffle box, but as that is dynamically created, I have not be able to find that process / function.
Reason for this: Too many columns on the IR report. Want them divided by categories in a tree view. And no, I cant break the report up into multiple reports. Currently this report has 548 columns.
View 1 Replies
View Related
Feb 14, 2013
i had an issue last week with enabling and disabling a column in a tabular view. and i have it working now.... when the page loads i disable the column in the 25 rows being displayed.
the problem i now have is when i use the pagination to move through the rows the columns are all now enabled.
so what i am trying to do is this:
i have a tabular view showing 25 rows at a time. there is one column with a code and one with a description. when the code is changed, via a popup LOV, the description is changed based on the valus in a lookup table in the database.
i need the description column disabled, so the user cannot simply just type in the column. but when the page is submitted, the column needs to be enabled so i have modified the sumbit button to respond to a dynamic action which runs some enabling code then submits the page.
SO....
this all seems to be working except for when you use the pagination, the description column is all enabled.
is there a way of running some javascript when the pagination is refreshed? some better way of doing it?
View 3 Replies
View Related
Aug 23, 2012
Using Apex 4.1 and custom authentication based on Oracle Database users.
I want to be able to show a warning immediately after a user logs in if their password is due to expire in xx days. Oracle raises a warning (ORA-28002) but I don't know how to handle that from the standard Apex login page.
View 1 Replies
View Related
May 2, 2013
What would cause Oracle to insert duplicate rows into a table? Could a join of two tables in the initial query assigned to an application page cause ORacle to insert an extra row into a table when an update to data value occurs? I have no insert triggers and no foreign keys assigned to the table. I am not sure what would cause Oracle to assume that an insert of a row must occur. I want to prevent that insert.
View 9 Replies
View Related
May 15, 2013
Re: Report Columns duplicated when region is copied.
When I copy a region which I have created via master-detail form, the report columns are duplicated. I'm actually copying the whole page but I have had other cases where I just copying the desired region and the columns were duplicated there as well. And, of course, there is no way that I know to delete columns from the form. But I doubt because -- in at least some cases I've tried -- the columns seems to be "linked" in that a change to one copy of the column was duplicated in the other when changes were applied.
In the example (below), there are three regions on the page and the problem occurs in region 2. (I think I will likely delete the first region.) It's been agonizing trying to get the report of region 2 and the tabular formish edits of region 3 on the same page. I made this in Oracle 11.2 in our APEX 4.1 and imported it to 4.2. You can see it here:
WS apex_examples_01
demo
demo
Appl. 991204
Page 57 is the original page created in 4.1 and imported
Page 58 is the page copied from 57 under 4.1 and imported
Page 59 is the page copied from 57 under 4.2 (Same result as in 4.1.)
If you want to try the page, select DSD01 from the DSD LOV, click "Query Process" and then click the edit icon. Ignore the region 1 errors -- I'll probably delete this region. The data is region 3 is for Run Date 12-May-13.
Is there some setting that allows this region to be copied without duplicating columns?
P.S. I think I know why it happens: APEX hates me!
View 3 Replies
View Related
Jul 25, 2013
I've got a report with two lov's, where the user is able to change the lov value and submit it. After submit the status of the item P100_status will be changed in Disable. Based on this value the lov's must be disables with apex_disabled. How can I disable these columns based on the value of P100_status?
View 11 Replies
View Related
Nov 6, 2013
Apex Version: 4.2.0.00.27Theme: 25 I have a page that I need to divide by 8 segments, rather than 12 ( I will need to place items and buttons in one of the 8 columns). To begin, I have made a copy of the One Level Tabs - No Sidebar page template. I have tried to edit this template, and played with multiple combinations changing the Grid Layout and Display Points settings, but instead of creating a page that has 8 columns, that span the width of the page, I am just left with blank space. See attached:.[URL] And these are the Page Template Settings:[URL] Is it possible to change the body section of the page template to have 8 columns span the entire width, without the dead space?
View 2 Replies
View Related
Jun 25, 2012
I have few reports that I want to have totals at the bottom of the report.
Is there any way I could apply totals to all columns without doing it one by one?
View 2 Replies
View Related
Jan 4, 2013
I needed to create a page on my existing APEX application that would allow the user to upload a file, I followed an online tutorial where the user had created a dummy table and inserted CSV File inserted through APEX into the table. Following that simple example I am able to load the simple CSV file (from tutorial) into a dummy table (from tutorial) but when I attempt to insert actual/dummy data into my actual database (which has a lot more fields of different types), using the exact same process, I am unable to do so.
Ironically, I am unable to insert even dummy values despite the fact that I have been able to insert the same dummy values using SQL Developer. Icing on the cake is that APEX does not produce any error, this lack of debugging feature (especially line by line debugging) is such a pain. Just to add, I can load the values into an Array and can successfully print the delimited values off the array but am still unable to insert the same values into my table. Here is the table that I am attempting to insert into (actual names replaced by Dummyxx):
CREATE TABLE "TABLE"."STG" (
"DUMMY01" NUMBER,
"DUMMY02" NUMBER,
"DUMMY03" NUMBER,
"DUMMY04" DATE,
"DUMMY05" CHAR(3 BYTE),
[code].........
And here's the insertion process:
DECLARE
v_blob_data BLOB;
v_blob_len NUMBER;
v_position NUMBER;
v_raw_chunk RAW(10000);
v_char CHAR(1);
[code]..........
If I run a process to produce the output of the data array onto the screen, the values displayed are in the pattern desired.
Inserting Dummy values instead of values from the Array (v_data_array) to test
EXECUTE IMMEDIATE 'insert into TABLE.STG (DUMMY01, DUMMY02 ..... DUMMY65)
VALUES (
60040,
5,
TO_DATE("14-Dec-12","DD-MON-RRRR HH:MI:SS"),
"ABC",
"ABC",
60,
"11DEC1201",
"331",
"SCOTT TIGER",
"MARKETING",
[code].......
Note that all the the CSV does not contain all the fields, the CSV files that are expected to be entered into the system contain 65 Fields whereas the Table has 73 Fields. Also note that the process runs fine through SQL loader that is invoked through a different server which I need to release and hence the attempt to load the table this way. Also, the procedure on the SQL Loader server is quite complex and involved JAVA+Unix Shell Scripts etc. which I would prefer to avoid.
View 1 Replies
View Related
Dec 26, 2012
i want to hide/Show tab according to application user.i want to display tab abc if application user exist in group 006 .
My Column Name in user table name :user_master
{
user_id varchar2(15),
grp_id varchar2(10)
}
what sql statement i apply to hide and show Tab.
View 1 Replies
View Related
Mar 5, 2013
I have created a table A say columns a,b,c,d,E. I have created a application to insert and update and delete rows in to this table.I want to capture when some user inserts , update, delete the rows.
How do I set this variable..
View 2 Replies
View Related
