Data Explorerの結果自動化の課題

特徴
,
1

I’ve crafted a Data Explorer query to find the threads a group participated in publicly and extract any Jira tickets they included in those posts.

I’m quite pleased with the results:

Selection_2268
Selection_22681194×383 54.4 KB

Using the x_id magic, I get the title and link to each thread, and the Jira tickets on the right.

Put that in a PM, tho, and:

Selection_2267
Selection_2267942×631 58.2 KB

Okay, so I’m losing my Jira URLs to the preview function. Fine. I can concatenate backticks into the output. That means it’s ugly in Data Explorer

Selection_2269
Selection_22691078×422 61.2 KB

But pretty in the PM

Selection_2270
Selection_2270793×618 65.5 KB

But then I realized I’ve lost my topic links as well.

Do I have to manually, painfully recreate those URLs in Data Explorer?

Am I just on the bleeding edge here, and the first one to try this stuff?

「いいね！」 4
2

Probably?

I think that one query to view in data explorer and another for an email seems OK. Is your problem just that you need two queries?

3

You can’t email a report to a group that doesn’t have access to the report. So having two reports means exposing the group(s) to two reports. And maintaining two reports. And it’s more than I want to (or should have to IMO) do.

The promise of the automation was emailing a Data Explorer query, so that’s what I expected to happen :woman_shrugging:

ETA: I’m currently scheduling a third (different) report. We have too many reports that I want to send out to maintain duplicates

「いいね！」 3
4

I think there’s a feature request in here. I’ve had the same experience using data explorer queries to moderate this community. I like the idea of having query results PM’ed to me on a weekly basis via automation so I can work through them and then have a record of how I am whittling away at a long todo list, but then the results from the exact same query are more interactive via the data explorer UI.

Why can’t the UI be the same in both places?

「いいね！」 2