Skip to Content
avatar image
Former Member

Can we enable "Search On Database" as Default Option for prompts?

seachondatabase.jpg

Hello All,

We have a requirement to validate prompts and run queries based on values from database instead of searching defined LOVs from universe/reports. Please let me know if we can make "Search on Datasbe" option as default for searching values.

PFA screenshot.

Regards,

Lokesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 14, 2017 at 11:25 AM

    This functionality is not enabled yet.You can not change.

    is your prompt optional?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14, 2017 at 03:29 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 22, 2017 at 07:57 AM

    Sorry for delay.

    @Kuldeep: Thanks. But our requirement is different. Functionality is already enabled but we needed Search on Database option as primary which I think not possible.

    @Amit: That prompt is not optional. I think this is not possible as this functionality is part of UI code however let me know if there will be anything possible to achieve it.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2017 at 07:09 AM

    Hi Lokesh,

    Yes it is possible,

    Select the object in Business Layer and click on Advanced tab, In list of values section tick the check box "Allow users to search values in the database, so that user can search values from database and also Partial result error doesn't show when run the query for selecting the input parameters.

    Regards,

    Ravi Shankar

    Add comment
    10|10000 characters needed characters exceeded