Is it possible to search within a user's activity?

[cybertrapped]

Hello,

Can I search within a user's activity?

If yes, how to?

If yes, and this is documented, where could I find it?

Thanx

[Brittany Joiner · Accepted solution]

@cybertrapped probably not the answer you want, but as far as I know this is not possible. 😭 what kind of thing are you looking for within the activity? you might be able to create automation that creates "logs" of cards on a board somewhere when that activity takes place and then you can search through that board.

[Brittany Joiner]

@cybertrapped i'm actually writing about how I would do this in my newsletter this week, so I thought I'd share a screenshot showing the rules I'd set up: 

Feel free to accept this answer so others who are looking for the same thing know there is a potential solution in here if they set up the automation!

[cybertrapped]

@Brittany Joiner  I like your idea, but the drawback is the limitation on the data I'd be able to log (i.e., search)... only activity after I implement your idea... :(

What are your thoughts about exporting all data from a workspace, perhaps csv, and then creating a quasi-database and search within it?

I understand that "The JSON and CSV exports include the 1000 most recent actions on a board, which includes comments. To export all comments, use the Export all boards within a Workspace option below." https://support.atlassian.com/trello/docs/exporting-data-from-trello/

Thanx

[Brittany Joiner]

@cybertrapped ah yeah, like backups, they also won't work retroactively, so that's a good point 😂 The export is a good idea! You could do that as JSON export and then use a tool to convert JSON to CSV (like this one, but there are a million others if you google: https://data.page/json/csv )  and dump it into a spreadsheet and search in there.

I haven't looked at what the exact format/schema of activity would look like, but if you know a keyword of what you're trying to search for (like a username) you might even be able to just view the JSON in your browser and search in there. (There are chrome extensions to make reading JSON more easily, like this: https://chromewebstore.google.com/detail/json-formatter/bcjindcccaagfpapjjmafapmmgkkhgoa)

[Brittany Joiner]

@cybertrapped if this was helpful, would you mind clicking the Accept Answer button so folks who are looking for the same know there's an answer in here? 

Also, you might be interested in joining the Trello Trailblazers Atlassian Community Events chapter! We have events each month talking about how to do cool things in Trello: https://ace.atlassian.com/trello-trailblazers/

[Vronik]

Hi

Look at this

https://community.atlassian.com/t5/Trello-questions/How-to-search-activity-by-user/qaq-p/2082248

If my answer helped you,
please mark it as accepted so that other people looking for similar problems can find it more easily.
Thanks

[cybertrapped]

Thank you Vronik, but your answer did not help me.

I want to search WITHIN the activity of a given user.

Right now, I can view the activity feed of a user. To load things on the past, I have to click a load more button, but I want to search for a given term within the activity of the user without having to load ALL OF the activity (which I don't know can be done). 

Do you have any other ideas?

Thanx