topic Re: Templates and MySQL in Alfresco Archive

Templates and MySQL

tiofelix — Wed, 30 Aug 2006 09:30:49 GMT

Hi, In the Alfresco database there is a table called node where all new documents created are stored. In this table there is a column called "id" and another one called "uuid". If i try to show the "id" of a document from a template (editing doc_info.ftl: ${document.id}) only appears the "uuid" an

Re: Templates and MySQL

kevinr — Wed, 30 Aug 2006 10:34:11 GMT

the property is called 'dbid'

Thanks,

Kevin

Re: Templates and MySQL

tiofelix — Wed, 30 Aug 2006 10:49:44 GMT

Sorry, but i 've just do it and doesn`t work.

I've put exactly in 'doc_info.ftl' :

 <b>id:</b> ${document.dbid}<br>‍

The error is:

'Expression document.dbid is undefined on line 7, column 17 in workspace://SpacesStore/4a4c9334-1ca7-11db-a32d-111a2d374a80.'

Re: Templates and MySQL

kevinr — Wed, 30 Aug 2006 11:15:25 GMT

Sorry you need to access it from the properties Map, and it's part of the sys namespace:

<b>id:</b> ${document.properties["sys:node-dbid"]}<br>‍

Thanks,

Kevin

Re: Templates and MySQL

tiofelix — Wed, 30 Aug 2006 11:36:16 GMT

Thanks Kevin, now it works.

Re: Templates and MySQL

tiofelix — Thu, 31 Aug 2006 08:27:46 GMT

Hi,

     I thought about the 'dbid' as a sequential code number(1,2,3,…) for each new document but i've just realized that 'dbid' increments too when a new space is created, is there any other field(id, dbid,..) that can i use for my requirements??

     Thanks.

Re: Templates and MySQL

kevinr — Thu, 31 Aug 2006 09:19:51 GMT

The dbid field is the row index into the node table, so yes it will increment when any new node is added by any user. It is useful as it is guaranteed to be unique within a single store (but of course only the GUID is unique across all stores and repositories).

I'm not sure if there is a value like you need…

Thanks,

Kevin