As a roomowner I want to replace the current pinned query message with a new one

[rschrieken]

When the event is done I:

• run the command completed tags so I can update the SEDE query to remove the tags that are completed by the users.
• I run the query to get the toptag
• I leave a message in the room I've updated the query and the tag [tag:toptag] is now on top
• I pin that message
• I unpin and cancel stars on the previous message about the query

The new command update query should perform above steps, except step 1.

[gunr2171]

Should the bot be responsible for pinning the message? Just keep in mind that account will need to be a room owner.

[gunr2171]

Alternative message idea:

The query has been updated. Tags on top are now: [tag 1], [tag 2], [tag 3].

[gunr2171]

Another possibility: use the existing Current Tag command, just improve the output to have more stuff in it.

Though this is mostly a work-around.

[Unihedro]

@rschrieken: Why not step 1 as well? SEDE queries has an API that allows retrieving results as JSON via POSTing with correct parameters as you specify.

[rschrieken]

@Vincentyification but does SEDE have an api to update the query? I have the code from SEDE here and I don;t see any code path that would accomplish that....