Challenges with automating Data Explorer results

Feature
,
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 Likes
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 Likes
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 Likes