Adding null values to queue with unique reference

Help Orchestrator
,
1

Hi Everyone,

I have a queue that has a column (lets say column “test”) marked as unique reference. It is working by not adding any duplicates.

But I have a scenario where if the column has null value, it can be added to the queue. But if there are multiple null values its not getting added as it has null value. What can be done.

For ex: Lets assume the column has values 123,456,789,456. 123,456,789 are added but the null values are not added as they are duplicate. How do I add null values too. Is it possible to combine a value from another column(always unique) to it and refer to the result as a unique reference?

2

decide what you need from business / solution perspective
then:

  • reconfigure the queue on the unique references setting
    OR
  • build the reference by an alternate composite key