How to : OVS Query Search and uses for standard/extended field

Create a complex query on BO

1. Right click on BO and create query ->give details ->next-> select ID and Description field->next-> select all check box for Selection, Basic Find and Result, when you add basic find, query will create search parameter which can use to enter search key.
2. Save Query -> Activate the BO, it will create new node for BO, here the name is “Overview01”

Now right click on BO and create screen->select OVS -> select field to use in OVS, here select both ID and Description. We will create a find form for search text and configure query to load data in OVS

Open OVS in UI designer and click tab Data Model

1. Unbind the root
2. Bind Root with query node and bind data source with query node

Now goto Controller tab expand Query-> Select ValueHelpQuery

Unbind it. And bind this query with QueryByElements in Overview01 node

Select each parameter from query and select drop button. Under the ‘Value’ click on button (…) and select SearchParameter structure and right click on structure and add data field as per the parameters, now for each parameter select  data field under SearchParameters structure.

In case, you want to set another query for specific search, then add new Query, rename it as ‘MyQuery’, and follow same steps as previous steps for parameter binding

To configure specific query select DefualtSet and click on + and under ‘Low Value’ enter specific search key ( it could be user)

put this OVS as value help for an extension field in standard screen.

For example I have extended Opportunity QuickCreate UI with ID field

And have assigned this OVS to ID field.

Save and activation your standard UI.

1. It will show record for selected default query(DefaultSet)

2. Type some search key for example “alto”, it will search all records and returns only those records which contain ‘alto’ in description

3. Now test with specific Query, from the dropdown select “MyOVSQuery”