When a column has a foreign key to SoftadminApi.User.UserId, then the grid guide will automatically generate a left join and replace the id value with UsernameFull. The query will use the following alias:
| Column name in guided table | Will be selected as |
|---|---|
| UserIdInsert | UsernameInsert |
| InsertUserId | UsernameInsert |
| UserIdUpdate | UsernameUpdate |
| UpdateUserId | UsernameUpdate |
| UserIdDelete | UsernameDelete |
| DeleteUserId | UsernameDelete |
| any other name | Username |
For example:
ALTER PROCEDURE dbo.MyTable_Search
AS
BEGIN
SET NOCOUNT, XACT_ABORT ON;
SELECT
MT.SomeColumn,
MT.DatetimeInsert,
U.UsernameFull AS UsernameInsert
FROM
dbo.MyTable MT
LEFT JOIN SoftadminApi.[User] U ON MT.UserIdInsert = U.UserId;
END;