How can I keep the Summary Attribute value unique for a given Work Item?
We have instructed our Users to enter the value of the Summary attribute in a certain format (xxxx-xx-xx) for a Planning Work Item.
Once a User attempts to save the Planning Work Item, RTC should compare all existing Summary attribute values to all other previously saved Planning Work Items to ensure that the newly entered Summary attribute value does NOT currently exist in a previously saved Planning Work Item.
If it already exists, then RTC will present an error message and will NOT allow the User to save the Work Item.
What would be the best way to accomplish this?
Thank you.
Once a User attempts to save the Planning Work Item, RTC should compare all existing Summary attribute values to all other previously saved Planning Work Items to ensure that the newly entered Summary attribute value does NOT currently exist in a previously saved Planning Work Item.
If it already exists, then RTC will present an error message and will NOT allow the User to save the Work Item.
What would be the best way to accomplish this?
Thank you.
One answer
I have no idea.. it would certainly be a server side plugin.. need advisor to stop it from being saved.
but I don't know what the search performance impact will be on the system, as you will run it for every save!..
see the workshop for creating a plugin
https://jazz.net/library/article/1000
and see Ralph's blog for how to implement a query (search)
https://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/
the performance will degrade as the number of workitems searched increases..
so plan ahead
but I don't know what the search performance impact will be on the system, as you will run it for every save!..
see the workshop for creating a plugin
https://jazz.net/library/article/1000
and see Ralph's blog for how to implement a query (search)
https://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/
the performance will degrade as the number of workitems searched increases..
so plan ahead