How can I make a field unique in RTC?
2 answers
One Idea that comes to mind is, you could create an advisor (extension work item save), that runs e.g. a query and checks if there is a work item with the same value in the attribute and prevents saving if so. However, there are performance implications.
What would be the use of this?
Comments
This is a alphanumeric field which should not be duplicated.
I want to make one field unique in a workitem so that if a second workitem is created with the same value in that field it should not allow to save the workitem.
Example, ,I have a field called Title in a workitem of type, say, Story. I want to make sure that the user should not be allowed to create more than one Story with the same Title
<o:p>
</o:p>
<o:p> </o:p>
As already mentioned above you could create a work item advisor. As an example see https://rsjazz.wordpress.com/2014/05/26/only-owner-can-close-workitem-advisor/ . This would check (e.g. using a query) to look if the value is already used.
However, please be aware that this will be a considerable drain on the performance of the system, as it will have to run a query each time a work item is saved.