On SEDE, we currently have the magic syntax site://
, which expands to the domain name of the site on which the query is currently being run. So, for example, in queries run from https://data.stackexchange.com/stackoverflow/, site://questions/
will autoexpand to https://stackoverflow.com/questions/.
I would like to request a similar magic syntax for linking to other queries on SEDE. I propose that we use sede://
for this. The idea is that a query run on the Stack Overflow database (i.e. https://data.stackexchange.com/stackoverflow/) would autoexpand sede://query/259634?UserId=1
to https://data.stackexchange.com/stackoverflow/query/259634?UserId=1, and similarly for other databases on SEDE.
The immediate use-case that prompted this was as follows: I wrote a query that provided summary information about the top commenters for a given site. I then wanted to "drill-down" and examine individual comments by some of those top commenters. What would be ideal is if I could include an extra column in the results like 'sede://query/1234567?UserId=' + CAST(UserId AS nvarchar)
that would automatically be converted to a link to query 1234567 (which would do the drill-down) with the UserId parameter automatically filled in. This way, there would be no need to hardcode https://data.stackexchange.com/<sitename>/
in the column, and the query would be usable on all sites without changes.