Hi Community,
When on server you could run a DB query to obtain stuff like when a space was last modified or who the owner was etc.
Basically what is the best way of running something like this command on cloud.
SELECT spaces.spacename, MAX(content.lastmoddate)
FROM content, spaces
WHERE content.spaceid = spaces.spaceid
GROUP BY spaces.spacename;
The closest I have come is the answer on this article - https://community.atlassian.com/t5/Confluence-questions/How-to-check-Cloud-Confluence-space-last-modified/qaq-p/673391
jQuery.ajax({dataType: 'json',
contentType: 'application/json',
type: 'POST',
url: contextPath + '/rpc/json-rpc/confluenceservice-v2/getSpaces',
success: function(spaces) {
jQuery(spaces).each(function() {
var space = this;
if (space.type === "global") {
jQuery.ajax({
url: contextPath + '/rest/api/content/search?cql=space%3D' + space.key + '%20and%20type%3Dpage%20order%20by%20lastmodified%20desc&expand=version&limit=1',
success: function(data) {
console.log(space.name + "(" + space.key + ") - " + data.results[0].version.when);
}
});
}
});
}
});
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.