Create attribute that can select 'work item' (such as Defect) and automatically fill another attribute with that defect value
I would like to create attribute that can select another defect to show in another defect.
For example,
I have two work item type name Main_Defect & Minor_Defect
Then, I create Minor_Defect and it has it own attribute
ID: 123
Owner: Derm
After that, I want to create Main_Defect that has attribute which can select another defect
Minor_Defect_ID: 123
and it will automatically fill another related attribute
Minor_Defect_Owner: Derm
Similar to SQL that can have multiple table and can related to another by using 'Primary Key'
Regards,
Derm Phongninlaarphon
Accepted answer
All work item types have an ID and usually all have an owner attribute.
Work items are not SQL tables and you should stop thinking of them that way immediately.
It is possible to create a custom work item attribute of attribute type 'work item'. You can add a editor presentation for that and then you would be able to search for work items, select one and it would store the value. I do not know what this would do in terms of benefits. There might or might not be possible automations. I will not waste time trying to explain possible approaches, as there is no description of the use case and business value or desired outcome.
EWM is made for linking. You should consider creating a parent/child link between the minor defect and the major defect, if needed at all. There is a reference presentation that could show the parent or children as an attribute. In addition reporting can follow linking easily.
Note that creation of multiple work item types needs to be considered carefully. Fewer is better for the users to understand.
Comments
In general I would suggest you describe what the desired business case, outcome and saving you try to achieve, and not present implementation descriptions. If there are desired outcomes, we might be able to hint how they could be achieved.
Hi Ralph,
I'm really appreciate your answer, I will tell my team about your suggestion so they can understand that I can't do what they want and we will find a workaround to achieve what they need.
I will come to ask you when we know what exactly my team need to do.
Regards,
Derm Phongninlaarphon
IF you can come up with a use case or business problem, that needs to be addressed, you can post that in a new question and we can try to have a look. But, again, posting implementation ideas is not a viable approach.
So the question is what they want to achieve - and why - that caused this demand.