topic Re: Passing Full datetime through JSON in Alfresco Archive

Passing Full datetime through JSON

ashex — Sat, 08 Jun 2013 00:11:50 GMT

I'm passing the created and modified metadata for documents via JSON from the repo to share. I found that I can't pass the raw format through JSON so I formatted it as dd MMM yyyy HH:mm:ss a '('zzz')'The problem I'm seeing is I can process this with xmldate or datetime because I'm including the time

Re: Passing Full datetime through JSON

rjohnson — Sat, 08 Jun 2013 09:14:51 GMT

You need to use ISO8601 format for all dates / datetimes. There are client side javascript functions to convert to / from this in Alfresco.util and server side ones as well. xmldate works with ISO8601.

Bob Johnson

Re: Passing Full datetime through JSON

ashex — Mon, 10 Jun 2013 17:49:38 GMT

To return the full date and time information I'll need to reformat it before presenting it through JSON then? Will xmldate preserve everything and be valid for JSON consumption?

Re: Passing Full datetime through JSON

rjohnson — Tue, 11 Jun 2013 09:35:43 GMT

Basically yes.

There are a couple of ways of doing this.

If you are returning a date from a repository webscript you can either convert the date in the javascript .get.js file or do it in the .json.ftl.

Doing it in javascript you would do something like


   result['issuedOnAt'] = utils.toISO8601(relatedItem.properties["fgitem:issuedOnAt"]);
‍‍‍

and then you don't need to bother with xmldate in the ftl because the date is already formatted correctly.

Alternatively you can simply pass the document properties into the ftl template, optionally define a macro (just for ease of use) and convert the date format there.


<#macro dateFormat date>${xmldate(date)}</#macro>
‍‍‍

Goes at the top of your ftl template and then you can do


"modifiedOn": "<@dateFormat item.properties.modified />",
‍‍‍

To produce a correctly formatted ISO8601 date.

On the client side you have


var myDate = Alfresco.util.fromISO8601(jsonobject.datenode);
‍‍‍

and


var my8601Date = Alfresco.util.toISO8601(javascript_date_object);
‍‍‍

which convert dates either way.

Hope this helps

Bob Johnson

Re: Passing Full datetime through JSON

ashex — Wed, 12 Jun 2013 23:29:33 GMT

Thanks for the info, that will be super useful. I had tried using xmldate with the JSON template but it kept throwing an error. I'll take another look at it with the methods you've recommended.