Home > Forum > General > Dictionary unique items

Dictionary unique items
0

Hello,

Is there a way to ensure uniqueness of items in Webcon's dictionary when importing data from Excel, to avoid duplication?

Thanks.

MVP

Hi Andree,

I would either do it directly in Excel or add a check whenever an instance is saved/the save path is executed.

The validate form action would be something like this:

select
case
when (Select Count(*) from WFElements where WFD_DTYPEID = XYZ and WFD_ID <> CurrentInstanceId and WFD_AttText1 = 'FormValue') = 0 then 1
else 0 end as ValueIsUnique

This would cause an error during the import or whenever the unique value stored in AttText1 would be used by another workflow instance using the same document type.

Best regards,
Daniel

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.