Skip to Content

The purpose of this document to explain the creation of advanced search options/filters for custom solution.

Advance filters are used to filter the data based on the value entered in the filter fields, here we are replication the standard functionality in our custom solution.

Thanks to my colleagues Deepak Singhal, bhupinder sharma,Vaibhav Kwatra, Atul Malhotra as they have helped and contributed in preparation of this document.


Firstly create a custom BO with required fields and screens.


1. Open the OWL screen in the UI designer and create a new SADL query from the controller tab.

/wp-content/uploads/2016/08/1_1006128.jpg

2. All the elements of the BO will be displayed here, select the desired elements from the element list. Only selected elements can be added to our advance filter.

2.JPG

3. Open DataModel tab, the selected elements in the previous step will start appearing in the data model under SearchParamaters2 data structure.

3.JPG

4. Go to designer tab and click on Advanced button to create the find forms for the owl screen.

4.JPG

Click on yes

5.JPG

5. A find form pane will appear, here the the filter fields will be added.


6.JPG

6. Drag and drop the fields from data structure SearchParameters2 to the find from pane.

7.JPG

final.JPG

7. From properties of OWL screen select FindForms and then select SearchTextBinding and bind it with SearchText data field of SearchParameters2 data structure.


1.JPG


2.JPG


8. From properties of OWL screen select the Default DefaultSet option and set it’s value to the defaultset of the SADL query, here “DefaultSet1” is the defaultset of our SADL query.


4.JPG


3.JPG


9. Save and activate the screen. The preview of the advance form will be like:

last.JPG

Here you can enter the desired data on whose basis the records will be filtered.

To report this post you need to login first.

8 Comments

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

  1. Deepika Agrawal

    HI Jayant,

    I am following the same to create advanced search filter in custom OVS. 7th step is not clear to me. while activation it it show the below error

     

    Thanks,

    Deepika

    (0) 
    1. Jayant Saini Post author

      Hi Deepika,

      As I can see from your screenshot that you have selected AdvancedListPane in the properties drop-down. What you can do is select AdvancedListPane : ObjectWorkList from the properties drop-down & click on “FindForms” from the properties and then follow the 7th step.

      If you are still unclear feel free to ask.

      Thanks,

      Jayant

      (0) 
  2. Deepika Agrawal

    Hi Jayant,

    I was trying to add advanced filter option in custom OVS as well. It is showing the filter options but my OVS values are not coming. Without adding the advanced filter the OVS was working fine.

    Please let me know if there is any solution to this.

    Thanks,

    Deepika

    (0) 
  3. priyanka gayen

    Hi Jayant,

     

    I am trying to use the advanced search in advanced list pane in an embedded component. I am able to use the advanced search parameter but my basic search is not working. In EC I am not getting the option to add SADL Query so the  search text is not available in the query. Please let me know how do I use the basic query.

    (0) 

Leave a Reply