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.
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
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:
- 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.
- Change the Structure binding status:
Select the Structure in the data model and in the Properties window change the Binding Status to “OK”.
- Add Query parameters to FindForm Pane:
Now go to the Designer tab and drag and drop the query parameters in the advanced Findform Pane.
Finally save and activate the UI and the advanced filter is ready to work
- Example:
Thanks & Regards,
Meghna
Great document for filtering....
Thanks for sharing this information....................
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
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.
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
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.
Hi Meghna,
Thank you for your sharing.
It is very useful for "Advanced Search" filter.
Hope your other documents.
Regards,
MyoMyo
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