Is there some simple solution how to send email to user with link ('I don't want to receive emails from you in the future') ?
The link should contain some key information for each user.
If user click the link - update of the table should be done. (some IDC updates from 'Y' to 'N').
Specs: APEX 4.1.1
Listener 1.1.3
DB 11G
Apache Tomcat 6.0
As all of you know, In the Apex, when you create a form with report in the page, you are able to insert and edit data. But when you edit the data, the data will be modified in the same row. In other word, you loose the old data.
What I need to do is: I have revised_num field and production_date field. I want to create a form with report and insert and edit data as is in the apex and insert 0 to the revised num until production date is null. But when production date is not null, then from that point, I want to insert data to another row and modify revised num to 1. and I want the revised num be incremented by 1 each time the user modifies the data after the production date is not null.I don't know where I should start.
I got a bug related to update information in APEX.
the situation occurs when I go to update a record the button Apply changes disappeared, it shows me only the button create, so when the user click on it, it creates a duplicate.. so how can i have the button "apply changes" back?
1 - i want to ask few things as i m new to apex, i am using apex 4.1, and created 3 select list and a button in selecting of parameter,
1 select list : select area
2 select list: select product
3- select list - size of the product
i want to generate Ids for the following. for that i created query for INSERTING RECORD FROM ONE TABLE TO ANOTHER , generation the ids when button pressed "Generate" after selecting parameters,
Now where i call that QUERY on button ? because when i create button its gives me option to submit, defined dynamic action, etc, where i call the function name id_generation when button pressed?
2- second thing i created tabular " select user_id, product_name, product_type from product".
By default check box list are create delete submit button are created, first when i insert record it saves that was fine, e.g i entered 50 records and afterward i want to update only one record, e.g there is a record product name = box, if i change it to box small and click submit then it saves all the page means all 50 records,
I want to submit only that record that i changed, for that i use the logic that only those records should be updated which are checked but the user. how will i do this ?
Can't send an email using Application Express 3.0.1.00.07 on oracle 10g.
my code is:
DECLARE
l_body CLOB;
v_email varchar(30);
BEGIN
SELECT CONTACT_EMAIL
INTO v_email
FROM persal_info
WHERE TRIM(PERSAL)= TRIM(:P48_PERSAL);
l_body := 'Your access code for the Transport system is:'|| :P48_CODE ;
l_body := l_body || '
This access code is needed in order for you to complete the claim form. It is important to change this access code for the confidentiality of your information.';
apex_mail.send( p_to => v_email,
p_from => 'PietC@google.com',
p_body => l_body,
p_subj =>'Access Code'
);
I am using oracle apex 4.2 version.i am trying to send mail using APEX_MAIL.send.My process like
begin
APEX_MAIL.send(
p_to => 'xxx@xxx.com',
p_from => 'xxx@xxx.com',
p_body => l_body,
p_subj => 'APEX_MAIL Package - Plain Text message');
end;
When i check mail queue from administrator part HomeManage > InstanceMail > Queue
It show no error and after the send all mail still i am not getting the mail..i also check my email setting in administrator part.
I am able to send mail to Gmail from APEX. How an attachment can be send along with it.
View 6 Replies View RelatedI am beginner . I found this tutorial how to save and access report.Storing and Accessing Reports in the Database In that tutorial report is saved onclick.Is there a way to automatically email report everytime report is generate or I should first save it (PDF, CSV,..) with SQL script and then email it? I also found that in Interactive report there is page process that can send e-mails. Is it possible that page process send e-mail with report or report should be also saved before sending? The reason for this is that we want to have a history of created reports.
View 6 Replies View Relatedi want to disable my EDIT link in report if it satisfy my case condition.
i am using some code but using this i can unable and disable text link not a image link how can i disable image link like edit link in report.
select * from (
SELECT AP.*, CASE WHEN AP.INVOICE_STATUS='C' THEN
'<font color ="Red"></b>Modify Invoice</b></font>'ELSE
'<a href="f?p=&APP_ID.:58:&SESSION.:INV_ID:&DEBUG.:58:P58_INV_ID:'
||INV_ID||':">
[code]........
I 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].......
Apex 4.1
I have IR wit one column link target to URL, and it uses javascript:my_function(#COLUMN_VALUE#)as URL, that is, calls some function and passes the value of that column to the function; everything works fine; but when I place a cursor over the link, bottom line of IE9 browser (is it called a 'status bar'?) clearly shows:
'javascript:my_function(<actual value>)' Is there any way to prevent it from showing function name and parameter value? I tried onmouseover="window.status='';"but it does not work
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 RelatedAll I want to do is call a DA from an HTML link, is it possible? Do I call the DA function like I do with JS?
View 2 Replies View RelatedI have a report linked to a form. The link column is currently ROWID and I want to change it to the Primary Key of the DB table, which is called ID.
I have done this before on a previous report/form where that ID was a display column and it works fine. Now I'm trying to copy what I did, which is this:
On the report page, go to Interactive Report attributes, scroll down to Link Column, and for Item 1, change the Name and Value.
The problem is that Name does not list P52_ID. If I type it in, it throws an error when I run the page.
I think I added ID, which is also a Display column, later on, so I wonder whether Apex has a refresh issue and can't "see" P52_ID.
I am using theme 4, topaz. Region_Position_06 is a home link.
I have placed a company graphic at this position on page zero, and when a user clicks it on any page, she exits that page and goes to the home page, a main menu page. So no matter how deep a user may be into the application's pages, she may always click this logo image and return directly to the main menu page.
This is convenient, but there is one problem. Clicking this logo does not clear the cache on the page the user is exiting or, for that matter, on any page in the trail of pages the user took to get to the current page. I navigate primarily with buttons and always clear the cache on a page when I exit it. I need to find a way to do this when a user clicks the logo image.
I want to add button on report region Named as "Send E-mail" that should be on each row
so how can i do?
Version 4.0.2.00.07
I have an Interactive Report with a column that I need to create a link on but I need to pass the value of another column.
This report shows the Features of a particular Release. There is a select list for the Release that is selected and executes the report. There is a column that indicates whether the Feature has a Commitment attached to it. If there is have that a link to another report that shows all the Commitments for that Feature by passing the FEATURE_ID which is also a column on the Feature report.
Query:
SELECT
....
,CASE WHEN ft.feature_id IN (SELECT cc.feature_id
FROM customer_commitments cc
WHERE ft.feature_id = cc.feature_id
) THEN 'Yes' ELSE 'No'
END "Commitment Exists"
,ft.feature_id
....
FROM ....If "Commitment Exists" has a 'Yes', the 'Yes' is a link that will pass the FEATURE_ID to another report that will show the Commitments for that Feature. If the "Commitment Exists" has a 'No' then no link. I was also wondering if the Commitment report could open in a seperate window and make it modal?
I have a question regarding db link. I have a query that uses a database link, i speed it up by adding the DRIVING_SITE hint and it worked when executed from
sql*plus or pl/sql developer.
It returns results in 3 seconds or even less. However, when i put this query back into the APEX application, specifically into an interactive report page -- it runs for 3 mins!
I have an apex page with a link on one column for each row. My requirement is as below
When i click on the first time on any of that link, it opens up in a new window and any subsequent clicks should override the previously opened window. So at a time, there should be only 2 windows open..
1) the APEX page
2) The browser window after clicking on an link in apex page
I have a requirement where users will select an instance (db link) from an apex LOV and the data in an interactive report will query based on the db link selected. I can use a db link in an interactive report query but only if I provide the exact name of the link. If I do something link select * from foo@:P12_ DBLINK it doesn't work. It seems my only option is to use something like apex_collection.create_collection_from_query and then I can build my query with dynamic sql and use a variable for the dblink name. Then I just create an IRR based on my collection. Does that sound like that correct approach and/or am I missing anything?
View 8 Replies View RelatedApex 4.2.0.00.27 I have a page with a Form region and a Classic Report region. How can I automatically save changes made in the Form when a user clicks the Edit link column in the Report? At the moment, when the user returns to the Form, any changes made there are lost.
View 2 Replies View RelatedI want to place change password link at the upper right of the page where logout link is..
i m using apex 4.1
I Have an apex page that display a modal window utilizing jquery. In the modal window I have a classic report with a link column that I want to capture its click event.
I was thinking I could create a dynamic action with selection type=jquery selector. Not for sure if I need to do anything on link column and do not know the syntax jquery selector.
Oracle 11g r2, APEX 4.1.1.00.23.
I have some classic reports.
I go to Report Attributes, then I click Add Column Link in the "Tasks" right menu, it adds me a column link, I just add some text for the link and a page to go to. Then I run the report and I get :
report error: ORA-01403: no data foundTested with several classic reports on multiple pages.
Debug mode shows me :
0.43816 0.00240 ...Execute Statement: select distinct [...] order by 3,11 ,4
0.44056 0.00162 print column headings
0.44218 0.04816 rows loop: 25 row(s)
0.49037 0.00141 report error: ORA-01403: aucune donnée trouvée
0.49175 0.00078 Computation point: After Box BodyWhen I run the query in my favorite tool, I get expected results.
Did I missed something ?
We have several prod instances and many applications on each of these... and interactive reports saved by many users.Each prod application have its own ID, distinct from the dev application ID.
Until today I used the apex_application_install inside the first wokspace only, and it works fine, but I need to update applications on every instances. It seems the only way to keep a saved report during an update is to use the same application Id (use the app n°200 to overwrite the n°200).So it means the only available method is : release the dev app on the dev workspace ; export 50 apps from it and import those 50 times, maybe more in the future.
My configuration :Oracle Standard or XEApex 4.1.1OHS
On my APEX page i have region which has sql query as source and it displays as HTML table the query result to the user.
I want to display addinonal column with a hyperlink inside, and that hyperlink would have CGI/URL-parameters which contains the other values of the HTML row.
So, let's say my APEX region queryes columns as "select c1, c2, c3, c4 ..." and displays out values "V1, V2, V3, V4" then i want to have addional output column with such hyperlink:
a href="f?p=100:7:13467554876288::NO::c1,c2,c3,c4:v1,v2,v3,v4">My link column with CGI-parameters</aHow can i create such hyperlink?
The overall idea is that the link would forward to a page which loads those values "v1,v2,v3,v4" into form fields and user can proceed from there.
---
"Application Express 4.2.1.00.08"
I have a query that selects multiple series for a bar chart (I have defined only one chart series, and have 3 columns selected to represent 3 series). The series display on Bar Chart is fine. Now I want to create a separate link target depending on which series is clicked on the chart. I am not able to do this.
View 1 Replies View RelatedI'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.
I'm using APEX 4.1 and have implemented a "Copy Record" button that copies selected fields from the record back to the same page to create a new record. This is done using branching and setting the items (e.g., P2_NAME,P2_ADDRESS1,P2_ADDRESS2, etc...) with these values (e.g.,&P2_NAME.,&P2_ADDRESS1.,&P2_ADDRESS2., etc...)
It has worked perfectly in other APEX applications -- up until now. The issue is that the new database contains several fields that contain the "#" character. When the "#" character is encountered during the copying process, any data after the # are not copied (but all of the data before the # are copied OK).
Removing the "#" characters is not an option, as it is part of numerous manufacturer part numbers that we track.
We are using Oracle 11g with Apex 3.2 on AIX. We are reporting data from customer satisfaction surveys. I'm using the following sql to create my report
<code>select * from(
select month,'Overall Satisfaction' as q_group, 1 as srt,Overall Satisfaction,site,
case when count(*) < 31 then '*' else
round((sum(ttos)/count(*))*100,0)||'/'|round((sum(bfos)/count(*))*100,0)||'/'||count(*) end ospct
from v_XXX_report a,(select distinct month_dt month from v_XXX_report) b
where Overall_Satisfaction is not null and year_dt = 2012
[Code]....
The problem is that site is not allways present and sometimes I have other variables in addition to site. This creates a situation where the month columns will not allways appear at the same column number. For example, When I run this query as is then the "JAN" column is Col3 (first column is a break, col2 is not shown). When I run this query without site then "JAN" is the second column. I would like to create column links for the "JAN" - "DEC" columns but not for any other columns.
Another issue - in the column link creation screen I can create up to 3 variables that I can pass to the next page. Since my query is a pivot I'm uncertain how to pass the column heading or the row value (for col2)
ie
Overall Satisfaction JAN FEB MAR APR MAY ...
Overall Satisfaction 12/12/200 12/12/210 12/12/220 12/12/230 12/12/240...
Recommend 12/12/200 12/12/210 12/12/220 12/12/230 12/12/240...
etc.
So if I clicked on the values at Recommend:FEB how can I get "Recommend" and "FEB" into variables that I can use on the next page? I've tried #column_name#, #month#, #q_name# and #APEX_APPLICATION.G_F10# but no luck.