-
Suggestion
-
Resolution: Unresolved
-
None
-
None
The Slack integration in Jira does not display how many and which users currently have personal notifications configured with their Jira account. This could be important to figure the owner of the subscription.
Workaround
You can get the related users using a SQL query along the lines of:
select cwd_user.lower_user_name, cwd_user.lower_display_name, cwd_user.lower_email_address from propertyentry, app_user, cwd_user where property_key like '%slack%' and propertyentry.entity_id = app_user.id and app_user.id = cwd_user.id;
Keep in mind that the
'%slack%'
portion results in a really broad search and that you should narrow this to exactly the property that represents the connections / users you want.
- mentioned in
-
Page Failed to load
[API-431] Display how many and which users currently have the personal notifications configured within their Jira Account.
| Remote Link | New: This issue links to "Page (Confluence)" [ 627423 ] |
| Description |
Original:
The Slack integration in Jira does not display how many and which users currently have personal notifications configured with their Jira account. This could be important to figure the owner of the subscription.
h3. Workaround You can get the related users using a SQL query Activity All Comments Work Log History Activity Ascending order - Click to sort in descending order Permalink Edit Delete feedback1534286591 Boris Berenberg - Atlas Authority added a comment - 30/Jun/2021 8:31 PM Workaround here is to query this via SQL. You can get the related users using a query along the lines of: select cwd_user.lower_user_name, cwd_user.lower_display_name, cwd_user.lower_email_address from propertyentry, app_user, cwd_user where property_key like '%slack%' and propertyentry.entity_id = app_user.id and app_user.id = cwd_user.id; Keep in mind that the '%slack%' portion results in a really broad search and that you should narrow this to exactly the property that represents the connections / users you want. |
New:
The Slack integration in Jira does not display how many and which users currently have personal notifications configured with their Jira account. This could be important to figure the owner of the subscription.
h3. Workaround You can get the related users using a SQL query along the lines of: {code:java} select cwd_user.lower_user_name, cwd_user.lower_display_name, cwd_user.lower_email_address from propertyentry, app_user, cwd_user where property_key like '%slack%' and propertyentry.entity_id = app_user.id and app_user.id = cwd_user.id; {code} Keep in mind that the {code:java} '%slack%'{code} portion results in a really broad search and that you should narrow this to exactly the property that represents the connections / users you want. |
| Description |
Original:
The Slack integration in Jira does not display how many and which users currently have personal notifications configured with their Jira account. This could be important to figure the owner of the subscription.
h3. Workaround You can get the related users using a SQL query |
New:
The Slack integration in Jira does not display how many and which users currently have personal notifications configured with their Jira account. This could be important to figure the owner of the subscription.
h3. Workaround You can get the related users using a SQL query Activity All Comments Work Log History Activity Ascending order - Click to sort in descending order Permalink Edit Delete feedback1534286591 Boris Berenberg - Atlas Authority added a comment - 30/Jun/2021 8:31 PM Workaround here is to query this via SQL. You can get the related users using a query along the lines of: select cwd_user.lower_user_name, cwd_user.lower_display_name, cwd_user.lower_email_address from propertyentry, app_user, cwd_user where property_key like '%slack%' and propertyentry.entity_id = app_user.id and app_user.id = cwd_user.id; Keep in mind that the '%slack%' portion results in a really broad search and that you should narrow this to exactly the property that represents the connections / users you want. |
| Description | Original: The Slack integration in Jira does not display how many and which users currently have personal notifications configured with their Jira account. This could be important to figure the owner of the subscription. |
New:
The Slack integration in Jira does not display how many and which users currently have personal notifications configured with their Jira account. This could be important to figure the owner of the subscription.
h3. Workaround You can get the related users using a SQL query |