Search form with single parameter to contain a multi-value "IN" condition

Full question:

Is it possible to have create a search form where a single search parameter could contain a multi-value "IN" condition?

For example to have a search parameter called Products, and set the filter value to 'product1','product2','product3', can this this filter value then be used in SemQL search in the search form as 
Product IN ( :ATTR_PRODUCTS ) and be translated as
Product IN ( 'product1','product2','product3' ) and return results for all 3 products?

Answer

Yes! 

Product in SEM_F_SPLIT(:SEARCH_PARAMETER_CSV_LIST_OF_VALUES, ',')

This function is automatically created in all Semarchy Hub schemas.

NOTE: While correct, this will cause a parsing warning in the SemQL editor which can be ignored. To avoid the warning add it to the PL-SQL functions in the workbench which will add this function to the SemQL vocabulary.