Application Express :: Search Application And Replace Text Within It
Sep 24, 2012
In Application Builder, is there a way to searching the application and replacing text within it?
I have an application item named "FORMAT_TYPE1". I would like to perform a find and replace action (just like a word processor) where any part of the application that has name or text "FORMAT_TYPE1" in whole or in part is replaced by the text "FORMAT_CATEGORY1". For example:
FORMAT_TYPE1 becomes FORMAT_CATEGORY1
&FORMAT_TYPE1. becomes &FORMAT_CATEGORY1.
The find/search would do it in any attribute, source code in the application. There is only a Search Application feature, which is useful in identifying places, but lacks any replace function. Is there something else that will do this, besides exporting, editing the source code in a text editor, and then importing the application again?
View 0 Replies
ADVERTISEMENT
Jul 15, 2012
I am using apex 4.1. I must hide phone number columns in my IR report, but at the same time the values of that columns should be available to search for using IR Search Field. is there a way to do this ?
if not, that means I have to :
1- Add a text filed P1_PHONE
2- edit my report query to something similar to
> Select * from Table where :P1_phone in (mobile1,mobile2) or :p1_phone is null
3- add button to refresh the report.
but the item P1_PHONE should be on the header of the Report region. is there a way to do this.
I am using theme 23
page template without sidebars
Report template : Reports Region.
how to put the item P1_PHONE on the tab of the page. Just similar to the Search item of in the Application Builder.
View 7 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 15, 2013
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.
View 2 Replies
View Related
May 14, 2013
I have a text field page item "Emp No" with a button "Find" in a page 10.
Soon after i enter any "Emp No" in the field and if i press "Find" button means, it will redirect to the another page 7, carrying the Empno that i have entered in the field in page 10 through URL and it will set that value to one hidden item P7_X which is in the page 7 and im using that hidden item to query data's in the page 7.
I need that search action to be done, not only by pressing the "Find" button but also pressing enter(soon after i entered a value in the "Emp No" field). Whether is it possible to perform that action once i press the enter button in keyboard.
View 14 Replies
View Related
Oct 31, 2013
How can I search the tree with a given string?I don't find any function like "search(...)".I want to find the tree nodes which include the given string.
View 5 Replies
View Related
Feb 15, 2013
My Interactive Report will run for a minute or for a long time like 5 to to 10 minutes depending upon given parameters to the report. Now I would like to cancel the report search when I made a mistake like searching on a value which willtake more time. how to achieve the same.
View 1 Replies
View Related
Dec 4, 2012
I have an interactive report which needs a horizontal scroll bar as it holds too much information for the screen, the problem is when a user scrolls the search bar is lost
i wanted to know if this could be changed by moving the interactive search (the whole action bar) to another form which would sit above the report.
View 2 Replies
View Related
Apr 16, 2013
I am using Oracle Apex 4.2 and theme 25. I want to add select list in IR search bar. I am able to add buttons but i am unable to add items.
View 4 Replies
View Related
Jun 12, 2013
I am using Apex 4.2, The Interactive report Search is not working properly, when i am entering complete date or time it is not showing any results...how to increase performance of the search...
View 5 Replies
View Related
Apr 25, 2013
I have a region where I have 3 textfields and a Submit button. Then, another report region where I have a query with the where condition that makes reference to the 3 texfields. This is:
Select * from ANYTABLE
where column1 = :P1_TEXTFIELD1
and column2 = :P1_TEXTFIELD2
and column3 = :P1_TEXTFIELD3
When I click the submit button, the report is reloaded (in fact, all the page) with all the conditions (in textfields) correctly. Now, what I need is that when I click the submit button, the filter appears in the screen; I mean, show the funnel with the filter conditions as if I made it since the search bar.
View 1 Replies
View Related
Oct 11, 2012
when receiving the output of a report subscription in Apex 4.1.1, the search Box is missing, only the Text string 'Suche:' is displayed.If i download the report as Email or html, the search box is there and usable.
Maybe i'm wrong, but this was not under Apex 4.0.2.
View 0 Replies
View Related
Jul 19, 2013
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 Related
Aug 17, 2012
I have created a JQuery mobile template for APEX which at the moment is just returning data from my database in a reports region. Is it possible to include a search bar before the user sees any data so they can search for records in the database and return them to the results page I have already created?
If so what is the best approach with the mobile template?
View 0 Replies
View Related
Nov 13, 2013
Apex 4.2 I have an interactive report.I use the sum attribute on the column and break formatting option to create a report total on one columnReport Sum Label Total:Break Columns No BreaksHow to I format the total text and value in to red
View 16 Replies
View Related
Jul 9, 2013
I am developing an apex application using the apex cloud (apex.oraclecorp.com). I am using the DB link to show the data on APEX UI. I have a blob data which is stored in the remote DB, and I want to display the BLOB data as text on a popup or a new page or a download link. I tried using display only item but APEX throws an error saying that remote DB is not supported. Also, It would be great if I can just show a download link on the UI for the BLOB data, again when I try to select the format as BLOB in the column attributes, When I give the table@dblink as BLOB table I get an error saying that "table@DBLINK not found". Is there any way to display the BLOB data as text or download it which is present in my local DB?
View 10 Replies
View Related
Oct 5, 2012
In my apex application needs to import data files, through end users. The fields in this file are not separated by any character (structure is not classic CSV), but have a fixed width.
How to do?
Scenario 1:
import file to a temporary table with a blob column, create a trigger for this table via a PL / SQL code meet end table
Scenario 2:
using DBMS_LOB libraries to read directly file
Scenario 3:
?
Milos.
(Apex 4.1.0.00.32, db:10.2.0.4 )
View 9 Replies
View Related
Dec 18, 2012
I have an image that shows flags of 2 countries... I want to show revenues that they generate every day. is there a way to add text to the image (on it) using values from a table.
View 10 Replies
View Related
Apr 29, 2011
Is full text search possible in oracle 10g express edition. If so, how is it possible. I browsed many places but couldn't find that.
View 1 Replies
View Related
Apr 22, 2013
I would like to add Dictionary in Rich Text Editor of APEX.
I am using Oracle APEX 4.2 on Oracle 11g.
View 1 Replies
View Related
Aug 8, 2013
Just installed 4.2.2.00.09 and imported a workspace and an application. Worked fine.I noted a page display difference when compared to the exported application (4.1.0.00.32). I have (so far) found this:If I have a button with Pre Element Text set to <div class="dummy"> and Post Element Text set to </div>, Apex generates an extra div around it all.If my button was named P1_SUBMIT I end up with
<div id="P1_SUBMIT_CONTAINER">
<div class="dummy"> <input type="button" value="Search" id="P1_SUBMIT" /></div>
</div>
Is it possible for me to turn this extra div off?
View 0 Replies
View Related
May 23, 2013
I would like to let the customer edit the item help text. Is it possible to retrieve item help text from my own custom database table based via a PLSQL function call or something similar?
View 4 Replies
View Related
Mar 12, 2013
We have recently upgraded to apex 4.2.1 from 4.1. After this, we get a strange stopping issue that the rich text editors clear all their values once the page is submitted. This happens only in Firefox and Chrome, but works just fine in IE. Have you ever noticed and had a solution for this?
View 1 Replies
View Related
Jan 17, 2013
how to dynamically populate text fields.For eg, i have a lov with employee no, as soon as a no is selected next text field with employee name will be populated.
View 5 Replies
View Related
Sep 3, 2013
i encountered a big problem after upgrading Apex from 4.1 to 4.2.2. On an application page there is a Text Area which will be read and processed after clicking a button. I didn't want a refresh of the page and did it with a dynamic action.All this worked like a charm with 4.1. Since the upgrade, the value of the Text Area is always returned as null while processing the dynamic action, but the value is filled by the user!When i change the type of the Element to Rich Text Area everything works fine, but i don't want this because i don't want HTML in the corresponding table. Is this a bug? How can i workaround it?
View 10 Replies
View Related
Jul 27, 2012
Oracle 11.2; application express 4.1...I have a table with a unicode clob column into which I insert descriptive text. Within these text entries I have inserted CR/LF (00D00A). However when I display the text entries in a report, the text streams instead of appearing with separate lines.
My report statement:
select text_entry_dt, entry_authy_nm, entry_text
from obj_text
where obj_id = :P41_FIND_ID
and text_type_cd = 'DES'
hat to do to obtain line separation within the entry_text content?
View 3 Replies
View Related
Nov 30, 2012
I have a number of reports subregions in a page . Each of reports sub-region has a HTML text and a cell (report with a single column ) having a count sql . Now , the problem is that the HTML text in some below sub-regions are not getting displayed .. Is there a limit on the no. of sub regions???? Can there be any alternative way to display all the HTML text and the corresponding count sql in a page .
View 1 Replies
View Related
Jun 27, 2012
i'm using Apex 4.1
When user add an image to a rich text editor in apex is there any way to get the source path of that image within PL/SQL block when page submit happens ?
View 2 Replies
View Related
Oct 22, 2012
I have created a region Q_INFO and in the region i have added HTML text area. This text area is editable for only few users. If the user types in the text area and presses save button. The text is stored in the table INFO. And this text is displayed to all other users. But when i enter any data in the text area with multiple new lines and press SAVE button. The text is displayed in single line. I want to maintain new line and paragraph in the text area.
View 2 Replies
View Related
Nov 3, 2013
I am using textarea item to enter and save data into table but saved data doesn't retain all formatting eg line breaks so how can i format the text entered in the textarea so it retains line breaks when saved in the table or sent in the email via APEX_MAIL.SEND... in APEX 4.1.1,
View 0 Replies
View Related
