Posted on Slack:
...
(select [value] from [config] where ([key] = 'https')) + '/register/?id=' + dbo.toGuidString(isnull(f_569c.[internal], fp_569c.[internal])) + '&person=' + dbo.toGuidString(fr__JID_.[record]) + '&h='+ dbo.toGuidString(dbo.md5(convert(varbinary(max), dbo.salt() + dbo.toGuidString(isnull(f_569c.[internal], fp_569c.[internal])) + dbo.toGuidString(fr__JID_.[record]))))
...
https://vet.admissions.tufts.edu/manage/query/query?id=14d30b4a-0e4c-4433-aed6-62698b85168f
From <https://app.slack.com/client/TFTG51QAW/threads/thread/CFUUKHULW-1677269823.903069>
Conversation with consultants
This was working fine to get the link starting from the Interview Template, but I was having issues building from a person or applications base. Tristan Devaney said: It looks like the issue is the generic base join to Form Responses. Try using the specific option for the IMM template:
...
Your custom SQL export should work using that approach if you were to update the aliases. That said, while there's not a direct export to recreate the link, all the components are available with the right joins, so you should also be able to build this with a regular formula (without having to display SQL and hunt for the aliases). I mocked up a quick example here: https://gradhlthsci.admissions.tufts.edu/manage/query/build?id=790f3f0e-4720-45b4-b909-ca3eeb42c705 (there's a join to the Report Form associated with the scheduler event, a system export for your database URL, and the form response already gives you the record GUID for the salted hash).
