Skip to Content
Author's profile photo Meghna Sharma

How to create an Advanced Filter in Custom OWL screen

Here I want to give a quick overview on Advanced Filter option on custom OWL screen with a small example.

Following are the steps:


1. Create a custom BO with required fields and screens

For example I am taking a BO with only one field which looks like the below.

CustomBO.png

Create the screens for the custom BO by right clicking the BO.

2. Configure the Advanced Filter in OWL screen

  • Create the Advanced Findform:

First of all open the OWL in UI designer and click on the “Advanced” option on upper right corner of the screen

AdvancedFilter_Yes.png

On clicking the option a pop-up will be shown which asks whether you want to create an Advanced Findform. Click on “Yes”.

  • Select the query parameters:

You can only add the Query parameters to the advanced section. To do that go to the “Controller tab” of the UI Designer and open the “Query” from the “Queries” folder. Select the elements from the query which you want in the advanced filter and click on the “Add parameter” button as shown below:

QueryParams.png

  • Bind the Query parameters:

Now create a DataField in a structure in the data model tab and click on the 3 dots in the “Value” column and select the newly created DataField.

SelectDataField.png

  • Change the Structure binding status:

Select the Structure in the data model and in the Properties window change the Binding Status to “OK”.

Structure Status.png

  • Add Query parameters to FindForm Pane:

Now go to the Designer tab and drag and drop the query parameters in the advanced Findform Pane.

DragthequeryParams.png

Finally save and activate the UI and the advanced filter is ready to work

  • Example:

BO Data.pngAdvancedFilter_Working.png

Thanks & Regards,

Meghna

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Great document for filtering....

      Thanks for sharing this information.................... 

      Author's profile photo Lewis Peters
      Lewis Peters

      Hi Meghna,

      Thanks --- this worked a treat. One question: I've added a customer name field to the advanced search pane. It doesn't take the fuzzy search, though --- searching for '*ABC*' won't yield any results, for example, but searching for the full company name (e.g. 'ABC Services Ltd.') does. Any advice on how to add fuzzy search?

      Lewis

      Author's profile photo Md Quddus
      Md Quddus

      Hi Lewis,


      In your case you need to create custom query in that there is option like "search text".

      For your reference:How custom queries work on OWL


      Thanks,

      Quddus.

      Author's profile photo Jayant Saini
      Jayant Saini

      Hi Meghna,

      You are doing this on object based screens but in my solution I need to use thing based screens. Is there any way for it?

      Thanks,

      Jayant Saini

      Author's profile photo Mohammad iqbal Siddiqui
      Mohammad iqbal Siddiqui

      Hi Friends  Meghna Sharma , Jayant Saini , Former Member .

      I copy  all the above step  in my tenant(my303032) but this document is not working.  i can not able to perform Advance Search in custom owl screen. please let me inform if other steps are in that.

      Author's profile photo Myo Myo
      Myo Myo

      Hi Meghna,

      Thank you for your sharing.

      It is very useful for "Advanced Search" filter.

      Hope your other documents.

      Regards,

      MyoMyo

      Author's profile photo Sunil Kumar Sahoo
      Sunil Kumar Sahoo

      Hi Meghna,

      This blog is good but I am unable to change that Binding status : ToBind to OK ..and not getting option for dropdown. Now I am using cloud application 2108 version. Please help me to achieve this otherwise share any other way for this. it will help for me.

      Thanks,

      Sunil