is there any way of querying just the interactions...

is there any way of querying just the interactions of an account in the fediverse? "show me all the messages where they have liked mine or I have liked their and all the messages that either I am tagged in their message or they are tagged in mine"

and if there isn't already such a tool can you imagine how one might go about that? I guess you would need to pull in all their posts and all your posts thru an api, then run it thru grep or something and then spit out all the uris

Like 2 Aug 2022 at 22:34 | Open on social.wake.st

4 comments

42GB

@liaizon not sure if you need all their posts. If you are tagged.. or liked: You should find that in your notification or mentions. If you liked their posts: in your favs. If you tagged them: your toots. Sounds like a cool idea 💡

2 Aug 2022 at 22:43 | Open on climatejustice.social

wakest ⁂

@42GB I don't think mastodon keeps notifications around very long. lets say I want to find the oldest post someone tagged me in. I don't think you can get that from the api but I would love to be wrong here

2 Aug 2022 at 22:46 | Open on social.wake.st

42GB

@liaizon Sadly I cannot confirm. I was just thinking out loud… sorry.

2 Aug 2022 at 23:09 | Open on climatejustice.social

Tim

@liaizon I'm pretty new to the feddi, but if you can access your instances database I have some queries for you!

```
select *
from statuses
left join accounts a on statuses.account_id = a.id
where text ilike '%https://wants.coffee/@tim%'
and a.username = 'georift'
and a.domain = 'qoto.org';
```

3 Aug 2022 at 15:29 | Open on wants.coffee