we have a hard table for all 'tasks' in the EHR. the update link of this table will open a specific page designed to edit that task.

we also have a query that takes this hard table and joins it to studydata to find 'Tasks By Participant' (aka all distinct combinations of TaskId/participantId). This table displays 1 row for each of the latter. Each of these queries provides a different way to do the same thing. A user would want to find their task by name/type (the hard table) or find it by participant (the query). In both cases, they want to find a record, click on it, then get taken to the same edit UI.

for continuity, it would be nice if I could coax the query to show an update column. this would make the hard table and query look similar to the end user and similar to everywhere else in labkey. any chance that's possible? i realize I can make one of the columns into a URL, but that doesnt keep consistency.

thanks.