Staff member didn't get notification when task assigned

The data explorer plugin offers both a way to do queries like that and an interface that lets you see all of the tables. If you’re on the Business plan you have it; if you’re self-hosted you can add it.