Hi

I have seen many people are asking how to configure query on OVS UI, this document is an effort to provide help. Currently I have used complex query may be in my next blog I will share thought with SADL based query.

This Document will help you to create, custom OVS based on custom BO which will provide you value help for standard ID field or extended field in standard UI.

Pre-requisite: Custom BO has created at least with two field ID and Description

/wp-content/uploads/2016/05/image1_947790.jpg

and Extend a standard BO with field for which you want to use value help. UI with this field has been extended (QC with ID field)

image2.JPG

Steps:

Details Steps Images

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”

/wp-content/uploads/2016/05/image3_947795.jpg

Image4.jpg

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
/wp-content/uploads/2016/05/image5_947797.jpg

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.

/wp-content/uploads/2016/05/image6_947801.jpg

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)

/wp-content/uploads/2016/05/image7_947802.jpg
Adding new query will add new “EventHandler” which will be execute on select of newly created ‘DefualtSet’, now set this EventHandler as shown in  image /wp-content/uploads/2016/05/image8_947803.jpg
Now goto Designer tab and select AdvanceListPane , and in Property ->click on Default set mapping, select both query , this will be appears as dropdown in OVS. /wp-content/uploads/2016/05/image9_947807.jpg
Now we going to use this OVS as value help for extended ID in Opportunity QC

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.

/wp-content/uploads/2016/05/image10_947808.jpg
Now we are done, Let test it, login into tenant and open Opportunity click on New /wp-content/uploads/2016/05/image11_947809.jpg

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”

/wp-content/uploads/2016/05/image12_947810.jpg

/wp-content/uploads/2016/05/image13_947812.jpg

image14.JPG

Regards

Sunil

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply