WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Latest posts

latest posts

MVP
In reply to: Cezary Rzucidło

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

MVP
In reply to: Michał

I see that no browser is fully compatible anymore.
I had problems with Firefox and Webcon working properly and now Chrome doesn't work properly.

Check the back version of your browser to see if the problem exists.

Good idea with reverting the chrome version. This will help those who can do this. Ours is managed globally. A new Edge Version has been released 130.0.2849.68 but it didn't fix the issue.

At first I thought it did fix the issue, but the rendering of the data table only works correctly when the workflow instance is displayed from the task panel. As soon as I go to the workflow instance the problem is back again.

This is really strange...

Hi,

I have a process that was checked out before we migrated to new servers. On the new server, I can't log in with the user that checked out the process and the old server has already been decomissioned.
I know I can force check out of the process, but I am afraid I will lose everything that was done on the process since it was checked out.
It was checked out in 2016. It was last saved in 2024.
If I force check out, will I get the last version before the process was checked out or the version that was last saved during the check in? How exactly does this work?

Thanks!