Home › Discussions › Questions & Answers › How to run a query on report names using Forms functionality

How to run a query on report names using Forms functionality

Avatar photoCustomer Questions & Answers 7 replies

I’m accustomed to using standard Oracle Forms functionality. Can I use the query function keys (F11/Ctrl+F11) to search for reports, or must I use the text search box?

7 replies

  • Support Enginatics

    Yes, you can run a query on the report name or description fields. This uses the standard Forms functionality.

  • Avatar photoCustomer

    What are the specific keystrokes required to execute a pattern search, like finding all reports starting with ‘GL%’?

  • Support Enginatics

    First, press F11 to enter query mode, then enter your pattern (like ‘GL%’) in the relevant field, and finally press Ctrl+F11 to execute the query and retrieve the matching reports.

  • Avatar photoCustomer

    Does this query function search the underlying SQL or just the front-end fields like report name?

  • Support Enginatics

    The F11/Ctrl+F11 functionality typically operates on the fields visible in the form, such as the report name or description. The ‘text search’ by typing directly into the field is the one that executes a full text search across the SQL, parameters, and templates.

  • Avatar photoCustomer

    So I have two distinct methods: the quick text search and the traditional Forms query?

  • Support Enginatics

    That is correct. You have the `text search` by typing into the report name field and the `query` method using F11 and Ctrl+F11 for finding reports.

  • You must be logged in to reply to this post.