Search This Blog

Friday, February 8, 2008

Hidden Methods to Query Oracle Apps Forms -- Very Useful

Here I discuss how can we query a form by giving certain query condition like
- Display only records where a particular column is null
- Display only records where column is greater than or less than a certain value
- Display only records where data is in certain range of value etc etc....

Press Function Key F11 to enter into query mode and Ctrl+F11 to run the query.
Hash(#) is the magic key here
Below are few examples with screenshots. As an example I have taken the FND_MESSAGE form which is available in the Application Developer responsibility. Navigation Application Developer-->Application-->Message
Condition1: Display all records where Number is NULL
Query

Result


Condition2: Display all records where Number is not null
Query

Result
Condition3: Display all records where Number is greater than 1905
Query
Result
Condition4: Display all records where Number is between 1905 and 1911
Query
Result
Condition5: Display all records where Number in 1905,1911
Query
Result

Do not forget to put your comments for the post.
Thanks.

7 Comments:

Raghavendra said...

It is good and very useful. Thanks.

Anonymous said...

Great to see how to do this, I have been asked in the past. LIKE works as well.

Suresh Vaishya said...

Thanks for your feedback.

Venky said...

Thats a nice tip to know Suresh, thanks.

Nira said...

Suresh,
Thanks for sharing this information.
I find it very usefull.
Nira.

Rama Krishna Mateti said...

Hi Suresh,

Let me appreciate the zeal which you share your knowledge with others.
I have learnt quite new things from your blog.
Keep going ahead.

morla satish said...
This comment has been removed by the author.

Copyright (c) All rights reserved. Presented by Suresh Vaishya