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".
When a format mask is applied to numeric field in an Interactive Report, e.g. 999G999G999G999G999G990, search operations from the Search Bar do not match any entries if the mask characters are included. For example, the data value from the database is: 2251343000. When the above, example format mask is applied, this is displayed as 2,251,343,000. However, if the user enters 2,251,343,000 in the search bar (which would be the natural thing to do), nothing matches. On the other hand, if the user enters 2251343000, a match is found.
This seems like counter intuitive behavior to me since the whole point of the tool bar is to allow "self-service" for the user. Training them to remove commas, dollars signs or whatever is not very popular.
We have apex application with one record report that shows image.We use database procedure to show image.And call it in apex like:
'<img src="show_image?p_id=' || NVL(dp.id, 0) || '" height="200" width="200" />' as image
But the image is not shown. We only see broken image icon.With right click on broken icon, we can save it and it's actual image we want to display.
If we call procedure like: URL.....
If we use the same procedure on another table with images which are smaller, then the image is shown.Minimum image length in table A is (DBMS_ LOB.getlength (file)): 105243..Maximum image length in table B is: 1702. URL....
I have just created the basic employee information form in which i upload the photograph of the employee. The photograph gets uploaded but it does not display properly. I have already referred the sample database application to display the image. Moreover, i have followed the same steps as it is used to display the product image in that application. Still i am unable to get result. I am getting following output:
<img src="apex_util.get_blob_file?a=35682&s=101496289174102&p=15&d=10639237623242912156&i=10639236703270912154&p_pk1=21&p_pk2=&p_ck=FCA12832591A1C706D76FDD589E551A2" />
I am new in apex i create form with report when i create record it submit page to its report its ok but can i change page on condition base.
View 8 Replies View RelatedAfter SSO Login to APEX Application it directs to Homepage by default,but i need it to direct to particular tab.
View 4 Replies View RelatedI have created a form based on a table and I want to override the processing which inserts/updates the data in the database. I have figured out how to create a new process but I am having trouble referencing the form field data.
If I have a filed call P40_USERNAME how do I reference this in the insert/update statement in the custom process.
I am having an interactive report with an email subscription.
My question is, how can I make the default attachment as a .csv file instead of the .htm file?
I'm using apex 4.1 and create a page with Interactive report with one default primary report and several default alternative report. when i selected one alternative report, how do i know which one is i picked up? it looks obvious to the user but my point is when the user switches to another page, or there are something should change based on the selected report, i want the user see the new page with-in the context of what have selected for that IR report. for example, i have a "summary" report based on year, so the alternative report will be year-2011, year-2012, etc, when user selected this year, 2012, on the same IR page, there is another report based on year 2012, when user selected 2011, that report should show 2011 report.
View 0 Replies View RelatedI am working on an existing application updating it to use custom authentication. When I changed the active authentication scheme APEX created a new login page (121). Why? How do I set it back to the login page I was using previously which I ahve customized somewhat?
View 4 Replies View RelatedIn a detail tabular form I am referencing a date picker field from the master form as default value.This is the situation in the detail form:
TABULAR FORM
Column Name: FECHAREGISTRO -- the field's name in the detail tabular form
Default Type: Item (application or page item name)
Default: P68_FECHAREGISTRO -- It's a field in the master form and also is Date Picker format
Reference Table Owner: SAMPEDRORIVEROS
Reference Table Name: BITACORAABOGADO
Reference Column Name: FECHAREGISTRO -- It's a date field in the database
At execution time I have the error:
report error:ORA-01790: expression must have same datatype as corresponding expression
I think it is because i must use to_date and to_char in order to change the datatype and i have tried using:
Default: to_date(to_char(:P68_FECHAREGISTRO,'DD-MON-YYYY'),'DD-MON-YYYY')
and in Default Type: PL/SQL Expression or Function but I get a different message at execution time:
report error: ORA-01722: invalid number.
i have used radio button under dynamic conditions for an interactive report.eg: radio button values are like a) front end b)middlware c)back end.so based on the selected value of the radio button, interactive report appears. and each fields in radio button have separate set of users. now my issue is,based on the user logging in, the default value should set up while the page is loaded...[i.e... if a front end user logs in, the default value of tat radio button shd be front end...]
View 5 Replies View Related1.-) i got a page that contains 2 regions, lets say :master (HTML text) and a detail (tabular form updateable report) in my tabular form i got a hidden item that should take the value from the master form. how do i do this ?
2.-) i am calling a form from another form, sending a couple of fields as a link parameters. the second form is called as expected, but i need that records on the second form that match the parameters get displayed. how do i achieve that ?
Basically I have a report that as part of it's source sql takes in an element from a select list.
E.G. SELECT * FROM table_name WHERE table_column = : P1_SELECTLIST
This works fine when the user selects an option from the select list however the first time the page runs it always returns data not found. The options correctly appear in the select list as they should without any nulls although it seems the select list is still initializing as null. I have been told to try and add a computation before the header on the select list item, although I'm not sure if this would work/how to do this.?
I'm using one of the new Date/Time picker items in Apex 4.0.2. When the user clicks the Calendar image the Calendar is displayed with the current date and time. However I would like it to display by default the current date and a time of 1000hrs.
View 1 Replies View RelatedI am developing a Catalog style application and displaying pictures in an Interactive Report; I can get the Interactive Report to display the Icon view when users visit the report the first time, the report works pretty simply. It has a series of buttons for the Sections of the Catalog and when the user presses the button it fills a hidden item which is in the where criteria of the Catalog, all of this works great with one exception:
When the user clicks the Catalog button and the data in the Interactive Report Changes; the Report changes to "Report View" I would like to maintain the report in "Icon View" only is there a way how I could have the interactive report only show "Icon View".
Application Express ver. 4.1
I have created a form. Some of the elements are hidden such as updated_by and update_date. I have provided the default values for these attributes as pl/sql expression in the "default section" (Application->page->edit page item). I am using the Process Row process that is automatically created when a form is created.
The problem is when I click the update button, the updated_by and update_date is passed as null values which throws an error from the database.
I 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.
I have created a IR report and I set the default search column using the suggestion found in the thread URL....but how can I keep this default even after the research was done?Now it is resetted !
View 1 Replies View RelatedI 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.
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');
I wanted to know the consequences of adding a DEFAULT value to an existing column in a table.I understand that when you add a DEFAULT value to a column which is Nullable, Oracle updates all the null values for the column to the DEFAULT value, generating a lot of undo/redo data.
Is adding a DEFAULT value to a NOT NULL column a problem? As the column is NOT NULL, an update would not be done, so no undo/redo data will be generated.But will this cause a whole table scan? Is this advisable?
I am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.
View 16 Replies View RelatedVersion : 4.1.1, I have a tabular form on a DB table. One of the columns is a date field. When the user hits the "add Row" button on the tabular form, I want the Date field to be defaulted to sysdate. Here is what I have tried so far,
1. Created a "hidden" item P1_SYSDATE and populated the default value with sysdate. After this, under the DB tabular report date field, I used default type - Item/application on this page and entered P1_sYSDATE
2. Instead of populating the default value of the P1_SYSDATE hidden item, I created a before regions process and added
:P1_SYSDATE := sysdate
and added P1_SYSDATE to default type of the tabular date field with default type as "ITem/application on this page.
I get the error
ORA-01790: expression must have same datatype as corresponding expression
I tried to_Char(sysdate,'dd-mon-yyyy') and then converting it back to to_date. still no luck.
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?
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.
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?
I have the following procedure...
CREATE OR REPLACE Procedure Updatetdef_normal_ranges (
i_tdef_range_id in number,
i_user_change_id in number default -1,
i_norm_range_low in number default NULL,
[Code]....
EXCEPTION
WHEN OTHERS THEN raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM); END Updatetdef_normal_ranges;
I am trying to execute it using the command
Execute Updatetdef_normal_ranges (i_tdef_range_id => 1, i_norn_range_high => 100.34, i_high_reflex_tdef_id => 100, i_low_reflex_tdef_id => 17, i_range_low_sched => -1)
and I am getting the following error...
SQL> Execute Updatetdef_normal_ranges (i_tdef_range_id => 1, i_norn_range_high => 100.34, i_high_reflex_tdef_id => 100, i_low_reflex_tdef_id => 17, i_range_low_sched => -1);
BEGIN Updatetdef_normal_ranges (i_tdef_range_id => 1, i_norn_range_high => 100.34, i_high_reflex_tdef_id => 100, i_low_reflex_tdef_id => 17, i_range_low_sched => -1); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'UPDATETDEF_NORMAL_RANGES'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
If I replace the update statement with dbms_output statement this procedure works fine.
I M USING APEX 4.1 AND CREATED SELECT LIST ON PAGE, I WANT TO SHOW MIN VALUE OF THE SELECT LIST FOR THAT I WROTE IN THAT SELECT LIST PROPERTIES UNDER DEFAULT TAG MIN; AND CHOOSE PL/SQL EXPRESSION BUT ITS GIVING ERROR "Error computing item default value for page item P1_PRODUCT."
BUT IF I HARDCORE THE VALUE CONTAINING IN MY DATA LIKE PRODUCT ID = 1, I HARDCODED IN DEFAULT VALUE 1 AND SELECT PL/SQL EXPRESSION IT WORKS.
BUT ITS NOT DONE LIKE THIS I WANT TO SELECT BY DEFAULT MIN VALUE OF THE SELECT LIST, SO THAT THE DATA SHOULD BE DISPLAYED ACCORDING TO THAT.
THE EXACT REQUIREMENT IS TO ENTER THE SELECT LIST DEFAULT VALUE IN SESSION SO THAT DATA IS TO BE DISPLAYED.
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!