Application Express :: Enable IR Search Field To Search In Hidden Columns

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


ADVERTISEMENT

Application Express :: How To Search By Displayed Value

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

Application Express :: Search Through Enter

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

Application Express :: ReCAPCHA Plug-in Creating 3 Hidden Field

Sep 6, 2012

i m using Apex4.1 and data base oracle 11g, browser firefox

i m using recaptcha plugins i had tried it with both way by creating 3 hidden field and and also directly with taking a item based on plugin. URL.....

More specifically, the page has two items for user input (the captcha and a text item) and a Submit button. If the captcha is successful, then the text item will be submitted and redirect to another page. The problem I'm running into is that the text item is always submitted regardless of the captcha.

View 0 Replies View Related

Application Express :: How To Search Tree With A Given String

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

Application Express :: Cancel Search In Interactive Report

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

Application Express :: Move Interactive Search Bar To Another Region

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

Application Express :: How To Add Select List In Interactive Report Search Bar

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

Application Express :: Interactive Report Search Not Working Properly?

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

Application Express :: Interactive Report With Custom Search Criteria

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

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

Application Express :: Interactive Report Subscription - Missing Search Functionality?

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

Application Express :: Prevent Reset For Default Search Column In Interactive Report

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

Application Express :: Would Interactive Report Search Box Work In Apex Mobile Template

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

Search For A Field

Mar 19, 2010

I'm wanting a query that will look up a named field and return all of the tables that it is held in. I've tried looking through manually but the database has hundreds of tables

View 1 Replies View Related

Search All Columns In A Table

Jan 15, 2009

I have an application which deploys the data to Oracle database. It has more than 25 tables and many columns. It does not have any document explaining the deployment, so I am kind of doing reverse engineering here.

I need a script which will fetch the column name or at least table names which will match with either some string or number? I found few examples on net to find out number. But I am struggling to make it work for string.

I can not work on stored proc, as I do not have access to create that on server. So, any script will work.

View 3 Replies View Related

PL/SQL :: String Search Query In Any Columns / Table In Database?

Sep 4, 2012

I am trying to search a word which starts with 'FRA' in any columns and any tables.

I am unable to find what is generating a join datasets in the webservice from teh database as it is not apparent within the 100 tables.

I ahve looked into

Re: How to search in all rows and all columns?
Re: SQL Search Query?

but none of these queries is working out for me as I am a user with no tables on its own but rather a user quering other tables.I think its a tweak on which dat a dictionary I can view

select distinct substr (table_name, 1, 14) "Table",
substr (t.column_value.getstringval (), 1, 50) "Column/Value"
from all_cons_columns,
table
(xmlsequence
(dbms_xmlgen.getxmltype ('select ' || column_name
|| ' from ' || table_name
|| ' where upper('
|| column_name
|| ') like upper(''%' || 'fra'
|| '%'')'
).extract ('ROWSET/ROW/*')
)
) t
order by "Table";

running teh above query got me thsi error:

ORA-19202: Error occurred in XML processing
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_XMLGEN", line 288
ORA-06512: at line 1
19202. 00000 - "Error occurred in XML processing%s"
*Cause:    An error occurred when processing the XML function
*Action:   Check the given error message and fix the appropriate problem

View 4 Replies View Related

Application Express :: Assign Values In Many Rows Based On Search Values?

Jul 25, 2013

I used Region, Process by to search the report which appears as shown above. Then I use Choose Auditors column to select my Auditor and copy paste it into the report under To be Audited By col. Is there a way to automate the process. I am here using a tabular form in APEX. My main aim is to assign auditors based on Region, not equal to Processed by. 

View 4 Replies View Related

Is Full Text Search Possible In Oracle 10g Express Edition

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

SQL & PL/SQL :: Instr Versus DBMS_LOB.instr / Search A Pattern Backwards In A CLOB Field?

Mar 10, 2012

I need to search a pattern backwards in a CLOB field.Function DBMS_LOB.instr does not work with '-1' offset (where to start the search) as instr does.

Parameters: instr(text_to_be_searched, pattern, offset, nth)

Example: I want to search 'Hello world' for the first instance of the letter 'o' starting from the end, backwards.As you can see, result for DBMS_LOB.instr is null when entered -1 for offset.

select
DBMS_LOB.instr('Hello world','o',-1,1) lob_i,
instr('Hello world','o',-1,1) std_i
from dual;

View 6 Replies View Related

Application Express :: Default Value For Hidden Item And Populate Query?

May 8, 2013

1.-) 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 ?

View 6 Replies View Related

Application Express :: Set Hidden Or Expanded Mode Of (Hide And Show Region) In 4.2

Sep 12, 2013

I just created a "Hide and Show Region" from a template in APEX4.2, and would like to control the behaviour of this region, i.e. 

1. At the page load, this region should be in "Hidden" mode
2. Once the user Opens the region, it should stay as "Expanded" mode ( even the page gets submitted), until the user chooses the "Hidden" mode again. 

So I tried the following

1. Chose the Hide and Show Region(expanded) template for the APEX region
2. uses Dynamic action to force the "Hidden" mode by setting Style as style="display: none;"  at the page load event. 

But it still shows the region in  "Expanded" mode after the page gets loaded.

View 0 Replies View Related

Application Express :: 4.1.1.00.23 - How To Enable SSP

Feb 20, 2013

I have Apex 4.1.1.00.23 and I want enable Session State Protection (just for testing and for learning how this works).

When I go to Home --> Application Builder --> Application 121 --> Shared Components --> Session State Protection and I click Set protection button I get to the page where I have 3 options (Disable, enable and Configure SSP).

After clicking on enable option, I get to page [URL].......

There is no Finish or submit or complete or confirm button, only cancel and previous (print screen is on picture). I found out that SSP is already enabled so I can't enable it again. But other question is still open, how to get it now to work in real.

View 0 Replies View Related

How To Enable And Disable A Field Dependent On Another Field In Apex

May 9, 2013

I am New to Apex. Im using Apex Version 4.2.

I have a tab named APPROPRIATIONS it has 10 fields. Among which is PROJECT NUMBER, AUTHORIZAION DATE (CALENDER TYPE POPUP), And FUNDS CHECK FLAG.

The Scenario is depending upon PROJECT NUMBER the Fields are Populated including FUNDS CHECK FLAG .

But the AUTHORIZAION DATE is a MANDATORY field has to be filled by User

The Requirement is to make AUTHORIZAION DATE as MANDATORY only when the FUNDS CHECK FLAG is *"BLANK "* or *“Y”*

If the FUNDS CHECK FLAG is *“N”* then the AUTHORIZAION DATE to be made OPTIONAL.

View 2 Replies View Related

SQL & PL/SQL :: Unable To Remove Hidden Character From Field

Mar 9, 2011

I ran into the following issue as mention below.

select dump(column_name) from table where column_name2 = 'HP1';

dump(column_name)
--------------------------------------------------------------------------------
Typ=1 Len=5: 194,160,82,88,66

I am trying to get right of these hidden character 194 and 160. i tried different method as mention below,

1) translate(column_name, chr(194)|| chr(16),'')

View 7 Replies View Related

How To Search For A Particular Value In The View

Dec 27, 2009

Which is better to use of Views and Materialized views so as to have good performance ? Also I need to search for a particular value in the view. Any function in sql to implement this ?

View 3 Replies View Related

SQL & PL/SQL :: Search For Column Name?

Jul 5, 2010

Can we search for a column name if we have some value with us, and we are not sure which column it belongs to.

View 3 Replies View Related

Forms :: How To Set Lov Search Value

Jan 23, 2012

I am using oracle 10g 10.1.0.2.0 . I want to set lov search value means when we open lov then in search text box it show % but i want to set 1% .

View 5 Replies View Related

PL/SQL :: Search Items One By One

Oct 12, 2012

i have a text field search_part1 in which i put the item for search another text field i send_by which contains items a single item comes in list many times.i have to find the item one by one.i have make this statement for seraching items

Declare
typ varchar2(200);
L_NAME VARCHAR2(50) := :BLOCK3.SEARCH_PART1;
begin
go_block('BLOCK3');
first_record;
loop
if :BLOCK3.SEND_BY = L_NAME then
[code]....

bt the problem is that if a single items comes more than one time then it search only one time and next time it exit.

View 3 Replies View Related

SQL & PL/SQL :: UTF8 - Unable To Remove Hidden Character From Field

Mar 20, 2012

My database is in UTF8 character set..

And it is not supporting chr(194)||chr(160)

what character set you were using then ?

And.. is there a way to handle non breaking spaces in UTF8..

View 16 Replies View Related







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