ReportSQL - Human-friendly User Name when there is only an ID

There isn't always a Person subtable.

Add the Completed By, Updated By, etc. column (which displays the ID) to get the correct field name. Add the text formula field from the same table.

User Who Completed a Task

• Text field on the top level Todo table, but should work on todo/tasks subtables

( SELECT person.last || ', ' || person.first || COALESCE(' ' || person.middle, '') FROM person LEFT JOIN users ON person.id = users.person_id WHERE users.id = %tableAlias%.completed_by_id )

User Who Updated a Credit

• Text field on Case Data > Matter Case Credits

( SELECT person.last || ', ' || person.first || COALESCE(' ' || person.middle, '') FROM person LEFT JOIN users ON person.id = users.person_id WHERE users.id = %tableAlias%.updated_by )