Hi Jan,
Did you try advanced filter in picker field? I think that basic filter from the filed above works correctly when there is only one value because it shows 1:1 relation (products category matches values with product groups. Every product group has one product category).
Imo, try to change filter to advanced and write filter like "IN" formula in dictionary values collection from database. I think it would be easier than change every value in dictionaries.
Anyone has better solution? :)
Adding to Cezary's answer:
I also would opt for the advanced filter
It would be something along the lines to get the groups matching the categories
and PRODUCT_GROUP_ID /* which should be the same ID column in the dictionary column as well as in the workflow instance */
in (select item from dbo.SplitToTable('FORM_FIELD_VALUE_PRodct_Group_ID_Values',';') /* I'm not sure whether the the delimiter will be , or ; */
In case you want to return all categories the condition could be something like
and ((FORM_FIELD_VALUE_PRODUCT_GROUP_ID_AND_VALUE like '%;%') or /* check whether it's a multi value string */
('FORM_FIELD_VALUE_PRODUCT_GROUP_ID_AND_VALUE' not like '%;%' and PRODUCT_GROUP_ID = 'FORM_FIELD_VALUE_ID')) /* if it's not a multi value string, filter the group field */
In case there's some syntax error with the query:
a) Enable diagnostic mode to get the full query and search for "SplitToTable" to find the condition in the long query.
b) Start SQL Server tracing
Best regards,
Daniel