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, its partner should have relationship Prerequisite-for (it is how it is shown from Spiras 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 en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/2492.aspxthreadId=2492Ilia Poliakov (ilya.polyakov@edetek.com)associations 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, its partner should have relationship Prerequisite-for (it is how it is shown from Spiras 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 Wed, 08 Sep 2021 20:01:34 -04002021-09-09T02:09:28-04:00/Support/Forum/spirateam/reports/2492.aspxmessageId=4118David J (adam.sandman+support@inflectra.com) 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. Wed, 08 Sep 2021 21:47:40 -04002021-09-08T21:47:40-04:00/Support/Forum/spirateam/reports/2492.aspx#reply4118messageId=4120Ilia Poliakov (ilya.polyakov@edetek.com) so, in the future versions api should be changed too to by synched with UI. Thu, 09 Sep 2021 02:09:28 -04002021-09-09T02:09:28-04:00/Support/Forum/spirateam/reports/2492.aspx#reply4120