Slate Instance | tuh |
Requestor/Reporter | Elizabeth Storrs |
TTS Staff | Elizabeth Storrs |
Date | 11/15/2023 |
Status | IN REVIEW |
Bug Description | The Research Activity Entity data is not available in configurable joins. The data exists in the table, and can be queried from a CJ base Research Activity, but that query cannot be successfully linked to any other table. The fields are available for joins from person-scoped queries, but return no data. |
Jira link | SLAT-134 - Getting issue details... STATUS |
Troubleshooting/Research
ROOT CAUSE: Research Activity is a Person-scoped entity, but the widget is embedded on an application-scoped form.
In SSMS, we can see that the dbo.entity table has rows for each row in every entity:
In TUH, there are four entities, so there are 4 different entity GUIDS in this table:
Resolution Steps:
Add Comment