Application Express :: IR Report Page With Download (specific) Column Security?

Apr 24, 2013

i 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.

View 5 Replies


ADVERTISEMENT

Application Express :: Put A Download Button In Report Page

Jun 26, 2013

I 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 Related

Application Express :: 4.1 - How To Add A Report Column To Existing Page

Oct 12, 2012

On a "Form on a table with report" page created with the wizard, I want to add a new report column from the underlying table (this is the multi-row page). If I try to add the column name to the query, Apex tells me:

"You have requested to change the Interactive Report query. If you added columns to the query, they will not be displayed when the report is run. You will need to use the actions menu and either select the columns or click Reset. If you removed any columns from the query, it will disable existing filters, highlight rules, and other report settings referencing those columns. Please confirm your request."

I sure don't want to start over and re-build the page, so where the heck is this "actions menu"?

I'm running Apex 4.1.

View 2 Replies View Related

Application Express :: Dynamic Alignment Of Report Column And Page Item Value?

May 7, 2013

I have an interactive report which contains the columns like

<li>empno
<li>Name

In the above i have "empno" with a column alignment of left and a "Name" with a column alignment of left.

Whether it is possible to override the data alignment that we set in the report according to the value of the application item like

If my application item value is US, then i need the column alignment of both the column"empno" and "Name" to be left and if my application item value is AR, then i need the column alignment of both the column "empno" and "Name" to be right. Whether is it possible to achieve the dynamic alignment to the report data of both the columns "empno" and "Name" according to the application page item value.And also in the case of page item i have a page item with a name P1_NAME in which it has a Element Horizontal/Vertical alignment to left.

I need that element alignment of the page item to behave dynamically according to the application page item, like if the application page item is US then the element alignment of the page item has to be left and if the application page item is AR then the element alignment of the page item has to be right.

View 14 Replies View Related

Application Express :: Go To A Specific Page

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

Application Express :: Scroll To A Specific Position Within A Page?

Jan 30, 2013

To branch & scroll to a specific position within a page (upon initial page load), is using a named anchor still the recommended/modern way to do this or is there some jQuery plugin goodness that does a better job?

View 2 Replies View Related

Application Express :: How To Build Access Control Page Download Spreadsheet Data

Jul 2, 2013

why 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!

View 1 Replies View Related

Application Express :: Clear Page Cache - All Except Specific Items?

Feb 21, 2013

APEX 4.2.1 On a page with dozens of editable page items, when branching back to the same page on-submit, is there a way to clear cache for all items except a few (key) items? The branch attributes (via the f?p= syntax) support clearing cache for the entire page and setting specific item/value pairs but no support for exclusions.

View 2 Replies View Related

Application Express :: Configure In Order To Download A Report With Excel

Apr 9, 2013

In my xe installation, what should i have to configure in order to download a report with excel. not with csv.

View 2 Replies View Related

Application Express :: Remove HTML From Interactive Report Download?

Sep 27, 2012

I 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.

View 4 Replies View Related

Application Express :: Re-execute Single SQL Report On Multi-Report Page

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

Application Express :: Download Link On Column From Another Table?

Apr 1, 2013

I'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 Related

Application Express :: Hide / Show Column In Download To CSV?

Nov 27, 2012

I 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

View 1 Replies View Related

Application Express :: How To Print Page With Report And Some Items

Oct 28, 2013

db11gxe , apex 4.0 , firefox 24 , I have a page with a report and two items , and i want to print the whole page (the report with the items) , can apex do so ?

View 1 Replies View Related

Application Express :: Pass Value From Report On Skillbuilder Modal Page

Nov 29, 2012

I am using the skillbuilder modal dialog. I have a report that displays in the modal. I want to pass a value from the report back to the page that called the modal and then close the modal. I have tried several different things, but I have not been successful.

View 2 Replies View Related

Application Express :: On Button Click To Fill Out Form On Same Page As Report

Jun 27, 2012

I have a report that contains a name that I want to pass in to a field in a form on a different region on the same page. My button located on the report is has its own column called ADD_LINK. Here is the button.

<button id="apexir_btn_ADD" class="apexir-button" type="button" value="Add" onclick=""><span>Add</span></button>

Once that button is clicked, I have the form region fade in. The region is called Add Tag to Employee, which has P4_ROWID, P4_EMPLOYEE_ID, and P4_TAG_ID. Once the region is displayed, I want the #NAME# to show in the P4_EMPLOYEE_ID.

I did copy this form from another page, where I had it working before. It made more sense to move it to this page for interface purposes, so maybe that tidbit will work as well.

View 15 Replies View Related

Application Express :: Force Report To Return To Top Of Page / Screen When Previous / Next Clicked?

Jan 10, 2013

We have several interactive reports setup and some of them can display more than one screen of data at a time, depending on the results returned.

All of the reports have prev/next pagination links at the top and bottom of the reports. For the longer reports, if you click prev/next at the bottom of the reprot, the prev/next page will display. But, you will still be at the bottom of the page/screen. Is there a way to force the report to return to the top of the page/screen when prev/next is clicked?

View 1 Replies View Related

Application Express :: Duplicate Column IDs In Reports On Same Page

Mar 27, 2013

I have 4 reports on the same page. I have added a checkbox column to each one. On clicking I want to populate a collection with the value of the id of the corresponding row and then have a button acting on the whole list.

My code to get the id of the item that contains the value I want is this

id = 'f02_' + $(this.triggeringElement ).attr('id').substr(4,4);

But there is an f02_0001 for each report, and the code just finds the first one, rather than the one in the context of the report being clicked.

<input name="f02" id="f02_0001" type="hidden" value="2072"/>
....
<input name="f02" id="f02_0001" type="hidden" value="2052"/>
...
etc etc.

All that is ever picked up is 2072

They have different table ids but I don't know how to reference the correct ones in my code.

View 3 Replies View Related

Application Express :: Print Column Heading On Each Page In PDF

Nov 13, 2013

Version 4.1.1.00.23 

I'm having a really hard time finding a solution to print the column headings on each page after the page break when printing.  We're using a tool called PDF Creator to create the PDF's and they're opened in Adobe.The server is GlassFish Server 3.1.2. What other information can I provide?

View 7 Replies View Related

Application Express :: Prevent Interactive Report From Running Query On Initial Page Load?

Oct 1, 2012

I am on APEX 4.1.1, db 11g and I have a report which is quite slow to retrieve results from its query. The page has some filter fields (e.g. store code, dept code) in addition to the generic search field.

When the user lands on this page (from a menu page), the query runs before the page displays and this typically takes 1-2 mins without any filters yet set. The usual browser loading indicators are not obvious to the user and they might not be aware that it is working on the request.

I want it so that it will only run the query AFTER allowing the user to get to the page, let the user fill in some filter criteria and then click on the GO button. Therefore the query will run after the page is submitted. When you hit the GO button on the interactive report, a nice rotating apex_loader.gif appears, making it obvious to the user that it is working on the request.

I would prefer NOT to create 2 pages, one for user filter, and a second for the actual report as I have many reports/inquiries which fit this category and I would prefer NOT to have to create pairs of pages for each.

View 5 Replies View Related

Security :: Audit Specific Statement On Specific Table By Specific User?

May 29, 2012

I'd like to know if it is possible to track DML actions issued on a specific table by a specific user, for example , i tried :

AUDIT SELECT on SCOTT.DEPT by HR by ACCESS;

I get an error, where is my syntax error ?

i want to know if it's possible to do it without trigger ?

View 7 Replies View Related

Application Express :: How To Fetch Tabular Form Column Value Into Page Items

Sep 7, 2012

I have created tabular form. I have set LOV for one column. Here my requirement is when i select the value from lov then it will fetch that value into page item.

I am using apex 4.1

View 12 Replies View Related

Application Express :: Grab Row ID From Report Column?

Jun 3, 2013

I'm having an issue pulling an ID from a report column.

I have a report based on the query:

select Inspection_Name, Activation_Status, Activate, Deactivate, Activation_Date, Inspection_Sector_Id from Inspections

where Event_Id = :P0_Event_IdThis report is based on a select list at the top of the page. The user selects an event from the select list and the report is populated.

The query for the select list is: select event_name, event_id

from Water_EventsSimple enough so far. Each row is identified by the Inspection_Sector_Id. I want to be able to turn each row under the 'Activate' and the 'Deactivate' columns into links. I have accomplished this by turning this field into a link. The link needs to navigate to a page that has that rows Inspection_Sector_Id, but am not sure how to grab that Id. I am navigating via URL on the link, i.e. f?p=application_id:page_id:session......

View 1 Replies View Related

Application Express :: Column In Interactive Report?

Nov 12, 2012

Since I'd rather not do it directly in the SQL used to populate the report, any clean way to style all cells of a given column from an interactive report? Perhaps all cells of interest can be addressed through jquey using the "headers" attribute they share?

View 5 Replies View Related

Application Express :: How To Make Form With Report And Insert Form In Same Page

Dec 14, 2012

how to make a form with report and an insert form in the same page, these two forms are related to the same table. Our customer wants a user can add new row to the table in a form and see all of rows created by this user in a report, this report should provide edit link as well. the problem is: whenever I inserted a new row or edit a row or delete a row, and submitted, and return to this page, all of hidden items lost their values, so report is blank, and some display only items also lost their values.

View 6 Replies View Related

Application Express :: Report String Column To Date?

Apr 22, 2013

v: Apex 4.2

I have Dynamic report and column say some_date column and data can be in the columun (01-JAN-13) OR (01-JAN-13,04-JAN-13), (01-JAN-13,04-JAN-13,10-JAN-13) so on.

in actual table column some_date is date field but in report as above (string) because using RTRIM(some_date, ',') some_date within the select MODEL clause.

my problem is when run the report and select filter from action menu then it doesn't give option such as < , > or so on because of string but I want it should give <, <=, >, >= operators too as date column.

View 5 Replies View Related

Application Express :: IR Report Date Column Popup

Apr 30, 2013

I have an IR report and want to add another column such as complete_date. I want to add as a link so when user click it then should display the popup window or javascript popup for date selection. i don't want to use apex_item.date_popup or apex_item.date_popup2. On date selection popup user can choose only two dates such as yesterday or today all other date should be disabled?

View 2 Replies View Related

Application Express :: Hide Column In Interactive Report In 3.2?

Feb 15, 2013

In Apex version 4.2 in interactive reports, you can stop users from hiding columns by unchecking a check box under column definition.Is there a way to stop users from hiding a specific column in version 3.2.

View 1 Replies View Related

Application Express :: To Fix The Width Of A Column In Interactive Report

Jul 16, 2013

I have a column named 'Comment'. Its have a huge data due to which the length of that column in interactive report get increased.

I need to fix the length to a desired value.I used following code in Region Footer:

<style> table.apexir_WORKSHEET_DATA td[headers=COMMENTS] {  _width: 300px;  min-width: 50px;   max-width: 300px }</style>

Its solved the problem by fixing the width of the column but the column is not showing the full data now. It is hiding most of its part to fit it in that column.

View 1 Replies View Related

Application Express :: Starting Report Column On New Line

Jul 30, 2013

Recently I remember reading what I think was a blog post on placing the last column of a report underneath the penultimate column - I think it was for classic reports.

I can't find it... Col1  Col2  Col3----  ----  ---- abc   def   xyz123   456   987  Col1  Col2  ----  ----  abc   def         xyz123   456         987

 I think it was done with some magic in the column definition, or maybe some jQuery?Agnostic to version. It was a more robust solution than using a HTML expression of#COL2#<BR>#COL3#

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved