At some point, the obj_type field in the tasks table stopped being populated (need to research what version this phenomena appeared in--not clear if this is a bug, or an intentional change). This breaks the logic used to populate Item Owner information for the Subscriptions task type.
A workaround would be to pass the workbook_id value for workbook-based subscriptions and the owner_id for any subscription in the "sub" subquery, then modify the join to workbooks so it uses that OR the original logic, and that's probably what we'll have to do.
mcoles
commented
3 years ago
At some point, the obj_type field in the tasks table stopped being populated (need to research what version this phenomena appeared in--not clear if this is a bug, or an intentional change). This breaks the logic used to populate Item Owner information for the Subscriptions task type.
A workaround would be to pass the workbook_id value for workbook-based subscriptions and the owner_id for any subscription in the "sub" subquery, then modify the join to workbooks so it uses that OR the original logic, and that's probably what we'll have to do.