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

Anja Airasvirta · October 24

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?

Alessandro Valli · October 24

In case being self-hosted you can connect to the database and submit a simple SQL query. There are several ways to do so (via evententry table, e.g.)

Iwan Kutter · October 25

Hello

One other possibility is to use the activity stream on the dashboard: Project activity stream. You can also filter by date, activity type and item type:

Or you could use a context-sensitive velocity report to extract the data to HTML or excel (in this example, you get only the changes where a new version of an item was created):

<html>

<head>

  <title>Example Report To get All Users</title>

  	<style>

	body {

		font-family: Arial, Helvetica, sans-serif;

	}

	table {

		box-shadow: 0 0 20px rgba(0, 0, 0, 0.15);

		border-spacing: 0;

	}

	th {

		padding: 10px;

		font-weight: bold;

		border-bottom: 1px solid #999999;

		background-color: #F9F8F8;

		text-align: left;

	}

	td {

		padding: 10px;

		border-bottom: 1px solid #dddddd;

	}

  </style>

</head>

#set($docus = $documentSource)

#set ($users = $userSource)

#set( $jamaProjectURL = $baseUrl + "/perspective.req#/items/")


<table>

	<thead><tr>

		<th>Key</th>

		<th>Name</th>

		<th>Version</th>

		<th>Created Date</th>

		<th>Created By</th>

	</tr></thead>

#foreach ($vDoc in $documentList)

	#set( $doc = $vDoc.document )

	#set( $url = $jamaProjectURL + $doc.id.toString() + '?projectid=' + $project.id.toString() )

	#set( $versions = [])

	#set( $versions = $docus.getAllVersionsByDocumentId($doc.id))

	<tbody>

	#foreach($ver in $versions)

		<tr>

		<td><a href="$url" target="_blank">$doc.documentKey</a></td>

		<td>$doc.name</td>

		<td>$ver.getVersionNumber()</td>

		<td>$dateTool.format("intl_tz", $ver.getCreatedDate())</td>

		<td>$users.getUser($ver.getCreatedBy()).getDisplayName()</td>

		</tr>

	#end

	</tbody>

#end

</table>

</body>

</html>

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

Comments

Categories