Forum Discussion

angela's avatar
angela
Catalyst II
1 year ago
Solved

How can I use wildcard filters for dropdowns in grid and for predefined Default Searches?

Hi community, the ItemType definition allows us to specify "Default Searches" for certain properties. I want to specify a "Default Search" that excludes a certain dropdown value when user search in...
Filtering
  • angela's avatar
    angela
    1 year ago

    I think I finally found a solution to this one. Back than I did a couple of tests with the multi value list, but it didn´t work perfect. MV lists are designed to allow multiple selects, while regular drop downs just work with one selection at a time. This would have been confusing for the end user. User think they can select multiple values, but end up getting no results at all. 

    But I found the perfect solution. We can overwrite the search condition used for these kind of list properties. This actually allows pretty flexible usage of multi value lists. We can keep the default behavior for most list properties (=result needs to exactly match the selection) and at the same time use all kind of different conditions for other lists.

    I wouldn´t overuse the concept, cause it can be confusing if every multi-value list works different. But it works well if the logical context of the property it self is more or less self-explaining. 

alaxala's avatar
alaxala
Creator III
1 year ago

I think it will be very difficult to do. The search string constructs its controls by requesting the corresponding ItemType property type. So if property data type is list it constructs the dropdown. You can try to change at runtime search type for this column to text or multi value list, but where should you put your code? You don't have a OnLoad event for search grid.

I can only think of one option - custom search mode.But I don’t know how to bind this mode to only one or some ItemType. And how does this search mode know which list properties to change search type and which ones not to.

If you decide to go this route, this line change the type of the search control to multi value list (or you can change it to "text").

grid._grid._head.set('propertyName_D', 'multiValueList', 'searchType')

where "grid" is the reference to grid container, propertyName is the name of your property ("_D" at the end is mandatory). This must be called after the grid is created but before search mode initialization. So the only place where you can put it is the SearchMode.OnStartSearchMode.

Or you can change the data type of your property to multi value list and validate the user input to select only one value on the form. I think it's much easier.

  • angela's avatar
    angela
    Catalyst II
    1 year ago

    Hi Alaxala,

    thanks for ideas and recommendations! I will test a few things a let you know when I make some progress!

    • angela's avatar
      angela
      Catalyst II
      1 year ago

      I think I finally found a solution to this one. Back than I did a couple of tests with the multi value list, but it didn´t work perfect. MV lists are designed to allow multiple selects, while regular drop downs just work with one selection at a time. This would have been confusing for the end user. User think they can select multiple values, but end up getting no results at all. 

      But I found the perfect solution. We can overwrite the search condition used for these kind of list properties. This actually allows pretty flexible usage of multi value lists. We can keep the default behavior for most list properties (=result needs to exactly match the selection) and at the same time use all kind of different conditions for other lists.

      I wouldn´t overuse the concept, cause it can be confusing if every multi-value list works different. But it works well if the logical context of the property it self is more or less self-explaining.