This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



Aug 19, 2015, 1:23 PM
8 Posts

OneUI SearchBar - Enable Partial Match

  • Category: Extension Library
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer
  • Tags:
  • Replies: 1

Hi

Does anyone know if you can have the searchbar in the application layout perform a "partial match" when searching?

For example: if the input is 123 it'll return documents with values 123, 1234, 12345. Currently it only returns documents with 123 (ie exact match)

Thanks

Steven

Aug 19, 2015, 4:23 PM
453 Posts
Some Thoughts ....

I have not used the search bar because I needed to customize the search much finer than what I could with the search bar. What I ended up doing is that I created an Action Button that called a search dialog. This gives the end user the option to customize the search in any way. In the Go button I create a query against a view in the target database (did that because there are several different types of documents in the database) the view selects only the documents that I want from the target db. In the view add any number of columns and set them to sortable. I get the columns from the view and populate a combo list for the sort columns. Then in the Go button I search the view

 

var n:Integer = vw.FTSearchSorted(query, maxReturn , column, sortOrder, exactCase, variants, fuzzy);

 

I then loop through the view and collect the UNID's of each document and store that list in a viewScope variable and make the viewScope the dataSource for a repeat control. Now I have complete control over the process and how the returned result is formated and presented to the user. I created the dialog in a custom control that I use in lots of different spots. You could create several different views in your database and have the query work against different views depending on a users selection or ?????

In any case this works well for me, and is pretty quick even when maxReturn is large, but then the user probably needs to refine their search.

 

Search Dialog


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal