I am creating an Appian Application that has Data Model based on CDTs (SQL Server Tables and Views).
For the Record List Page, I have created Record Type from the CDTs which is sourced from a SQL Server View. The main ID on the list page is hyperlinked to navigate user to the Record View Page of the record in the same Appian Application.
However, I have a second column in the Record List Page, which contains the ID of a Record List View Item from another Application. I want this ID Hyperlinked as well, which navigates the user to Record View Page of another Appian Application through this Hyperlinked ID.
On the backend, I have simply created a Database View in SQL Server which contains ID of of both record item i.e. the individual record in the new application and the existing record in the old application. But on the front-end, I am not able to discover a way through which I can hyperlink the ID in the second column which navigates user to the Record View of the other application.
Is there anyway through which I can handle this? Thank you in advance.
Discussion posts and replies are publicly visible
yes you can handle it by using records security
Yes, I have the access to the second application. I am not aware how I can access the RecordType of another application into the current application.
Or otherwise, what function would return the hyperlink to Record View of another application if I pass only just the Primary Key of the Record List Item?