Application Express :: Open Download File In New Window?
Jun 5, 2013How to make an item as a mandatory field dynamically with the change of another item in different regions
View 8 Replies
ADVERTISEMENT
Application Express :: Can Open Page 306 As Modal Window But Page Closes Immediately
Nov 13, 2012i 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.
Application Express :: Download File In 4.0.2?
Jan 28, 2013I am migrating my application from Apex 3 version to Apex 4.0.2. In previous version , downloading a file was working fine.
But now, it is not working..Is there any changes to be done with the properties?
I was using wpg_docload.download_file to download the file.
Application Express :: BLOB Action - Implement File Upload And Download Function
Sep 11, 2013In my project, I implement file's upload and download function by "BLOB Support in Forms and Reports" of official development document Advanced Programming Techniques When user click the BLOB column to download file, I want to trigger an action to update one table for counting this file is downloaded one more times. But I can not find any "dynamic action" about this Blob column of Report.
View 1 Replies View RelatedApplication Express :: Authorization For CSV Download
Jun 12, 2012I need to limit the usage of the CSV download to some users : how can I do that ? Is it possible to connect CSV download to a custom button ?
View 4 Replies View RelatedApplication Express :: Tree Link On A New Window
Jan 31, 2013I have this Query in a tree page (apex 4.2), but i need open a .pdf file in a new window. It's possible?
select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
else -1
end as status,
level,
[code].......
Application Express :: Upload And Download BFILE
Sep 12, 2012Is there any way to upload a file to APEX as BFILE instead of BLOB? I need it to be BFILE since I will be only using XE which means I have limited data storage and unfortunately the system will allow users to upload and download files of different formats (.exe,.bat ) etc. which can be as big as 10MB. Also, how to download these files considering the authentication of the application.
View 3 Replies View RelatedApplication Express :: CSV Download Russian Characters
Aug 5, 2013Apex 3.2 I have russian data in my database.When I display it in a report, everything is ok.If I export the report to csv, then the russian characters display incorrectly. EgIn report БУЛКА 10:1 ЗАМОРОЖ.In export ¿¿¿¿¿ 10:1 ¿¿¿¿¿¿¿. My settings in shared components areApplication Primary Language: English (United Kingdom) en-gbApplication Language Derived From : Use Application Primary Language.
View 24 Replies View RelatedApplication Express :: Adding Checksum To URL For Popup Window
Oct 18, 2012Using Apex 4.1.1
I have button which opens up a pop-up showing a report passing some parameter in URL. The button calls the javascript function defined below:
<script language="JavaScript" type="text/javascript">
function newReport()
{
url = 'f?
[Code]...
It all works well but for security I would like to add checksum to arguments in URL. I had a look at the Javascrpt API for Apex and couldn't find any for creating a checksum I can append to the URL.
Is there one that I missed or is it possible to do it by other means?.
Application Express :: Modal Popup Window Hides?
Aug 20, 2012today I stepped upon an issue regarding popup windows.I have created an application with popup windows for editing and inserting new records.I left the item label templates to "Optional with Help".When I now click upon an item label the help - popup window appears but it is hidden behind the popup window I am working in.
Is there a workaround for that.Is there a possibility to modify the z-order either of the help popup or of the modal window ?
Application Express :: Custom Download Procedure Not Working?
Oct 16, 2013I have created a custom download procedure to download uploaded files from custom table records which are displayed via links and i call my procedure as #OWNER#.my_file?p_file=#ID#. Now the problem this procedure call works in my development system not any other system.
is there any grant i need to provide but i don't want to grant to public also apex 4.1.1 create or replace PROCEDURE
my_file(p_file in number) AS v_mime VARCHAR2(500); v_length NUMBER; v_file_name VARCHAR2(400); Lob_loc BLOB;BEGIN SELECT trim(MIME_TYPE), BLOB_CONTENT, trim(filename),DBMS_LOB.GETLENGTH(blob_content) INTO v_mime,lob_loc,v_file_name,v_length FROM EMP.FILE_attachments WHERE id = p_file; owa_util.mime_header( nvl(v_mime,'application/octet'), FALSE ); htp.p('Content-length: ' || v_length); htp.p('Content-Disposition: attachment; filename="'||replace(replace(substr(v_file_name,instr(v_file_name,'/')+1),chr(10),null),chr(13),null)|| '"'); owa_util.http_header_close; wpg_docload.download_file( Lob_loc ); ---------------------------------
Application Express :: Download Link On Column From Another Table?
Apr 1, 2013I'm a APEX newbie using APEX 4.1. I have a table with engineering drawing information (drawing number, title, revision, etc.) and another table with the corresponding drawing files (pdfs stored as blobs where the filename is the drawing number with a pdf extension). The user wants to search for a particular drawing by drawing number from the drawing info table and if the drawing number exists in the drawing files table the drawing number will also be a download link for the file, if the drawing number doesn't exist in the drawing files table than the drawing number will display as plain text (not as a download link).
View 1 Replies View RelatedApplication Express :: Put A Download Button In Report Page
Jun 26, 2013I have requirement like I have to put a download button in report page and clicking it will download only few of the columns only (specified one). I am using Apex 4.2.
View 7 Replies View RelatedApplication Express :: Hide / Show Column In Download To CSV?
Nov 27, 2012I have an IR where I have to show a column in report, but hide it while downloading to CSV.
I get this by having a condition on this column - NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF') I also have a column where I have to hide it in the report, but show it while downloading to CSV.
I am able to hide it, but this column doesn't show up while downloading.I am using this condition on this column NVL(:REQUEST,'EMPTY') IN('CSV','XLS','PDF','XML','RTF') APEX - 4.0.2
Application Express :: Resizing Region Height When Window Is Resized
Jul 25, 2013I have a tree region, surrounded by <div>, the height of which is set on page load by a dynamic action so that it is 200px smaller than the window.innerHeight. I have set overflow:auto in the style so that the full free can still be viewed. I now want a dynamic action which fires when the window is resized, which automatically adjusts the size of the region accordingly, so that the region always remains 200px smaller than the innerHeight of the window. I can get the dynamic action to fire by setting the event to resize, however it does not change the size of the region.
View 1 Replies View RelatedApplication Express :: Configure In Order To Download A Report With Excel
Apr 9, 2013In my xe installation, what should i have to configure in order to download a report with excel. not with csv.
View 2 Replies View RelatedApplication Express :: Remove HTML From Interactive Report Download?
Sep 27, 2012I have interactive reports where the column link on a specific column has to be dynamic, that means, it cannot be hard coded in the column link attributes. The following is an example of one such report query:
case when d.object_type_description ='Business Service' then
'< href="f?p='||:app_id||':183:'||:app_session||'::::P183_OBJECT_ID:'||d.id||'">'||d.object_name||'</>'
when d.object_type_description = 'Real Time Event' then
'< href="f?p='||:app_id||':162:'||:app_session||'::::P162_OBJECT_ID:'||d.id||'">'||d.object_name||'</>'
else
null
end
as "OBJECT NAME"As you see in the above example, the link on the "Object Name" column could either redirect to page 183 or to page 162 based on the "Object Type Description" column.
The column attribute of the "Object Name" column has "Display Type" set to "Standard Report Column". That works perfectly fine in the UI of the report. However, if I download the IR data (in any format) from the Actions -> Download menu, the object name column values are downloaded with the HTML characters as:
< href="f?p=15548:183:6072319179284::::P183_OBJECT_ID:255245470513999672860510787772603748464">JP010000</>where JP010000 is the object name.
Is there a way I can strip the HTML from the column values in the downloaded files?I am using Apex 4.1.
Application Express :: Does CTAS Evaluate Order By In APEX SQL Command Window
Oct 22, 2013I need to recreate my table in order to change the column order. When I use the SQL Commands window and run the SQL, it runs successfully, creates the new table, but doesn't reorder the columns. Is this expected behavior?
View 2 Replies View RelatedApplication Express :: Unable To Size Pop Window That Redirects To Regular URL Using Dynamic
Nov 8, 2013I have an instruction like this in a pluggin: begin ...
htp.p('<font size="3" color="FireBrick">
Cannot find? Search on </font>' || '<
[URL]....
<font size="4" color="FireBrick"><b>Google</b></a>'); ...
end;
It displys the Google page in another window. How can size the wiindow? For example adding width=200, height=100 to the href tag doesn't work.... Do I need to use JavaSvript?If yes, any example?.
Application Express :: IR Report Page With Download (specific) Column Security?
Apr 24, 2013i have IR report page and download column as blob,how can security applied in specific column wise?e.g. Report page have more rows, and applied query in condition.
Select ID,dbms_lob.getlength(Blob_file) Download from Document_master
where Created_by=UPPER(:APP_USER)
OR
(exists (select '' from apex_workspace_group_users awgu
where awgu.user_name =:app_user AND awgu.GROUP_NAME='EMPLOYEE_GROUP'
)
)
Now all the rows with Download column to see EMPLOYEE_GROUP users,but i need control the download column only except Created_by=UPPER(:APP_USER) ,this case how can do the security.
Forms :: Open Dialog Window Using Oracle 10g
Jul 7, 2012i want to open dialog window using oracle forms 10g on button click event.
View 3 Replies View RelatedApplication Express :: How To Build Access Control Page Download Spreadsheet Data
Jul 2, 2013why the link provided under the How to Build an Access Control Page Download Spreadsheet Data Download the following *.csv file to your local system: In your Web browser go to:
[URL]............
returns nothing for me!
Client Tools :: How To Open PL/SQL Developer With SQL WINDOW From Command Line
Sep 11, 2013I am trying to run PL/SQL Developer from command line, So it can open with an opened SQL WINDOW by default, with a script (which I specify in the command ) already in it:
I've tried:
"C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb
but it just opens the application with a connection, no file.
*CORRECTION* While I was writing this post, I tried something , which is not so sophisticated, and it appeared to work...
C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb "C:Program Files (x86)PLSQL Developerandrey.sql"
Application Express :: Open RTP Report By Pressing Button
Aug 27, 2012Is this possible to open rtp report(oracle report), by pressing button in apex.
View 2 Replies View RelatedApplication 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 RelatedClient Tools :: Unable To Open Oracle 9 ISQL Window In Internet Explorer 6?
Oct 12, 2010I am unable to open Oracle 9 iSQL window in internet explorer 6. And i have two oracle version installed in my system are 9i and 10g.Now i am able to open the iSQL windows of 10g but not the 9i. It's happen after installing the Oracle 10g in system.
how i open both the iSQL windows in my system the Oracle 9i and 10g
Application Express :: Skillbuilders Modal Page - End Open Event?
Apr 24, 2013I'm using Skillbuilders Modal Page 2.0.0. plugin on Apex 4.2, and I can't seem to get the event End Open to work. stumbled upon this thread Skillbuilder Modal Page - Dynamic Title; nothing happens even if I set an alert to pop up on End Open
View 7 Replies View RelatedApplication Express :: Cannot Open Login Page - Not Able To Get Parameters Values
Nov 20, 2012Not able to open login page 101 in my internal application. I am getting below error
ORA-12170: TNS:Connect timeout occurred
Error Not able to get parameters values
OK
Application Express :: Link Local File With Browse File Dialog
Aug 15, 2012I'm looking for a solution to hyperlink to a local file (i.e. C:/test.txt). I want that the user clicks on a "browse file" button like the file browse item. after the user selected a file or just a folder the path should be shown in a display only item. this item should be clickable...
Is it possible to create a "Browse file" dialog? I know that to link to a file is possible with some HTML tags in the "pre element text" and "post element text" fields. something like "<a href="... but I don't know how this works.
Application Express :: How To Change File Character When Export Application (4.2.1.00.08)
Feb 5, 2013I need to change "File Character" when I export application with Apex 4.2.1.00.08 version, but this option, is not possible. The ComboBox already select with
"Unicode UTF-8]', but I need "ISO-8859-1 - Europa Ocidental",
how can I do change it?