Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > ArtifactAssociations Name...
I am running:
select value R from SpiraTestEntities.R_ArtifactAssociations as R where R.SOURCE_ARTIFACT_ID=23741
Where that enity with ID=23741 has a relationship "Depends on". So, it's partner should have relationship "Prerequisite-for" (it is how it is shown from Spira's interface, but not in reports) but I can not get text "Prerequisite-for" from Spira reports.
Probably, you should have ARTIFACT_LINK_TYPE_NAME_forward and ARTIFACT_LINK_TYPE_NAME_backward instead of one "ARTIFACT_LINK_TYPE_NAME"
The relationship is a one-way relationship
We adjust the UI to change the verb to be the inverse for the reverse view, but in the database it is only shown as 'depends on'.
so, in the future versions api should be changed too to by synched with UI.
And if you have any questions, please email or call us at +1 (202) 558-6885
