nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I get the lastModified date to be returned in the JSON response?

ian.kleinfeld

I'm trying to get the actual DATE for the last modification, not just results that fit in that constraint, i.e.,

rest/api/content/search?cql=lastModified>=2022-01-02&expand=body.storage,history,history.lastModified

Doesn't seem to make a difference if I quote the date or not "2022-01-02" or 2022-01-02.

Results are not including lastModified, and I'm unable to find where to get it in the documentation. There is no detail about it in https://developer.atlassian.com/server/confluence/cql-field-reference/#lastmodified

Is it even a history.property? I can't find that either.

Thanks!

@Shannon S I saw you've answered questions like this before.

Accepted answers

All comments

Dominic Lagger

Hi @ian.kleinfeld

Do I understand you correctly when I say, the REST call returns the correct pages, but you are unable to get the lastModification date in the anwser?

Try with "expand=version".

Then you will get

"version":{
"by":{
...
},
"displayName":"...",
"_links":{
...

},
"_expandable":{
"status":""
}
},
"when":"2022-06-02T08:07:06.000+02:00",
"number":1,
"minorEdit":false,
"hidden":false,

In the "when", this is the last modification date.

Regards, Dominic

ian.kleinfeld

Thank you. I'm VERY new to CQL.

expand=version works by itself:

cql=space.type=global&text=care&expand=version

"version": {
"by": {
"type": "known",
"username": "mieak",
"userKey": "5617289345jggfajf89a3",
"profilePicture": {
"path": "/images/icons/profilepics/default.svg",
"width": 48,
"height": 48,
"isDefault": true
    },
"displayName": "Michales, Miek (MM)",
"_links": {
"self": "https://wiki.mysite.com/rest/api/user?key=asdafebq34905"
    },
"_expandable": {
"status": ""
    }
  },
"when": "2011-11-19T22:18:38.000-06:00",
"message": "This version of the page was created by the system as a result of upgrading to Confluence 5.8 on Fri Apr 1 18:39:39 CDT 2016 The contents of the page have not changed.",
"number": 1,
"minorEdit": false,
"hidden": false,
"_links": {
"self": "https://wiki.mysite.com/rest/experimental/content/6585414791/version/1"
  },
"_expandable": {
"content": "/rest/api/content/6585414791"
  }
},

but not when added to, for example

cql=space.type=global&type=attachment&text=care&expand=body.view,history,history.lastUpdated,version

Gives me this, which has, I think lastUpdated.when, which I think should suffice, am I right? But I'm not getting the version expanded.

{
"id": "1085643280",
"type": "comment",
"status": "current",
"title": "Title to a great article",
"history": {
"lastUpdated": {
"by": {
"type": "anonymous",
"profilePicture": {
"path": "/s/-d9vrmd/0504/1rcy8jf/_/images/icons/profilepics/anonymous.svg",
"width": 48,
"height": 48,
"isDefault": true
        },
"displayName": "Anonymous"
      },
"when": "2012-07-10T18:51:53.000-05:00",
"message": "This version of the page was created by the system as a result of upgrading to Confluence 5.8 on Fri Apr 1 18:39:39 CDT 2016 The contents of the page have not changed.",
"number": 1,
"minorEdit": false,
"hidden": false,
"_links": {
"self": "https://wiki.mysite.com/rest/experimental/content/1078003280/version/1"
      },
"_expandable": {
"content": "/rest/api/content/1085643280"
      }
    },
"latest": true,
"createdBy": {
"type": "anonymous",
"profilePicture": {
"path": "/s/-d9vrmd/8703/1scy8jf/_/images/icons/profilepics/anonymous.svg",
"width": 48,
"height": 48,
"isDefault": true
      },
"displayName": "Anonymous"
    },
"createdDate": "2012-07-10T18:51:52.000-05:00",
"_links": {
"self": "https://wiki.mysite.com/rest/api/content/1085643280/history"
    },
"_expandable": {
"previousVersion": "",
"contributors": "",
"nextVersion": ""
    }
  },
"body": {
"storage": {
"value": "<p>this window is too far to the right i cannot view the whole page , and there seems to be no way to scroll to the right hand edge of this window. I have seen this problem with ALL of the Learning videos so far</p>\n\n<p>Bob</p>",
"representation": "storage",
"_expandable": {
"content": "/rest/api/content/1085643280"
      }
    },
"_expandable": {
"editor": "",
"view": "",
"export_view": "",
"styled_view": "",
"anonymous_export_view": ""
    }
  },
"extensions": {
"location": "footer",
"_expandable": {
"resolution": ""
    }
  },
"_links": {
"webui": "/display/AHAUTX/Uncharting+in+I-View+QuickDemo?focusedCommentId=1078003280#comment-1078003280",
"self": "https://wiki.mysite.com/rest/api/content/1085643280"
  },
"_expandable": {
"container": "/rest/api/content/1085643280",
"metadata": "",
"operations": "",
"children": "/rest/api/content/1085643280/child",
"restrictions": "/rest/api/content/1085643280/restriction/byOperation",
"ancestors": "",
"version": "",
"descendants": "/rest/api/content/1085643280/descendant",
"space": "/rest/api/space/ABCD"
  }
},

Dominic Lagger

In this case, I would suggest to you:

Just getting the content ID and make another call for every ID to get the details of this page.

Regards, Dominic

ian.kleinfeld

Thanks, Dominic. Would you show me how that would look? I literally am BRAND NEW to cql and am unsure how to do that yet.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

update

date

cql