help_outline FAQ chevron_right FAQ chevron_right Detail

What SQL query is used to populate the TaskList1 grid list?

grid list populate query sql tasklist1

SELECT X_TASK.UserTableID, XPODA_CLIENT_USERS.UserFullName AS Person, X_TASK.Task, X_TASK.TaskGroup, X_TASK.Description, X_TASK.Deadline, X_TASK.Status FROM dbo.X_TASK WITH (NOLOCK) LEFT OUTER JOIN dbo.XPODA_CLIENT_USERS WITH (NOLOCK) ON X_TASK.Person = XPODA_CLIENT_USERS.UserID