How do I find all the latest editors e.g. for previous 7 days?

Anja Airasvirta

Filtering items and limiting them for updates for e.g. 7 days will provide you a bunch of items. From that list you can then filter by Author to see all those item authors but it is the original creator of that item.

Then you can add the column to show Modified by but that would give you only the latest modifier name, not all the users who have edited that item during the past 7 days.

Question: How do I get list of those users who have made any updates in my projects during e.g. 7 last days?

Andrew MacCormack

You can get this with the REST API to extract the history, and maybe in Velocity?

Martha Fiske

I've been working on a script to do that. You can create a list of project, iterate through the list and for each project use the activities api to get all UPDATE activities for the last 7 days. The call will look something like this:GET "https://lucid.jamacloud.com/rest/v1/activities?project=<project id>&eventType=UPDATE&objectType=ITEM&date=2025-01-22T11%3A40%3A41.000%2B0000&date=2025-01-29T11%3A40%3A41.000%2B0000"

The results should look something like this:"data": [ {"id": 20434537, "item": 14540707, "date": "2025-01-27T11:40:45.000+0000", "user": 3125, "userName": "Users Name", "action": "Modified", "eventType":"UPDATE", "details": "\"Steps\" changed", "objectType": "ITEM", "itemType": 61 },…] From that you can use the data to see who updated what in the last week.

Good Luck