Filter custom condition

Support
#1

Hi
I need to add a custom condition on filter component, my case is the same of this sample:
https://demo.cuba-platform.com/sampler/#main/17/sample?id=custom-filter

I want add a filter of products from master order browser window. My problems are three:

  1. my product table ha 50.000 rows, so I need to use a suggestion field, else is too slow loading window. Is possible define type of compoent suggestfield instead lookup ?

  2. for few conditions the where clause of suggest component change. Can I manage query of a suggestfield thta is part of filter component from code ?

  3. For few conditions, I need to hide suggestfield component filter, how can I do this from code ?

#3

As for item 1, it is possible to use PickerField instead of LookupField. The component (lookupField or pickerField) is automatically selected based on entity statistics. Take a look at the lookupScreenTreshhold parameter in the Entity Statitistics section of the documentation.
As for other requirements, you can create always create a custom filter in addition to the generic filter.

#5

ok, but how can I choose kind of component (PickerField instead LookupField) on generic filter component ?

#6

From the documentation of the lookupScreenTreshhold parameter:

The Filter component takes this parameter into account when choosing filter parameters. Until the threshold is reached, the system uses the LookupField component, and once the threshold is exceeded, the PickerField component is used. Hence, if lookup screens should be used for a specific entity in a filter parameter, it is possible to set the value of lookupScreenThreshold to a value lower than instanceCount .

So, just set some value to the lookupScreenTreshhold