topic Re: Storing autoincrementing property in database. in Alfresco Archive

Storing autoincrementing property in database.

pawelu — Mon, 04 Sep 2006 10:52:03 GMT

HI Gurus, Could anyone help me with the following problem. I would be very greatful if someone wrote a bit of code. I have created a custom mode. One of the properties has to behave exactly like an autoincrement column in a database. Can anyone tell me with what steps I could implement it. I woul

Re: Storing autoincrementing property in database.

derek — Tue, 05 Sep 2006 12:13:27 GMT

Hi,

I assume that your algorithm can withstand holes in the sequence. Did you know that every new node has its unique database row ID recorded in the metadata?

Regards

Re: Storing autoincrementing property in database.

kevinr — Tue, 05 Sep 2006 12:15:19 GMT

The property is called "sys:node-dbid"

Thanks,

Kevin

Re: Storing autoincrementing property in database.

pawelu — Tue, 05 Sep 2006 12:27:06 GMT

Hello I need to have ordered list of numbers. Every content/document must have its own number like a record of primary key in a database. These have to be integers numbering documents/content. Greetings, Pawel.

The property is called "sys:node-dbid"

Thanks,

Kevin

Re: Storing autoincrementing property in database.

binduwavell — Mon, 23 Jan 2012 16:13:03 GMT

The property is called "sys:node-dbid"

I don't believe this solution is portable across export/import is it?

Any other suggestions that would be portable?

Re: Storing autoincrementing property in database.

emperor333 — Tue, 14 Feb 2012 07:18:56 GMT

Dear binduwavell,

Please specify your requirement correctly. I assume you are trying to create a custom metadata which you wants to increment upon every new content creation/update. If this is what you intend - you can create your own behaviours, rules to update the custom field upon any content manipulations. Let me know is this something you expect!?

Regards,

Re: Storing autoincrementing property in database.

mrogers — Tue, 14 Feb 2012 09:57:27 GMT

Correct "sys:node-dbid" is not suitable for import/export.

However how would you merge your different sequences on your target system? The solution is either as simple as copying the value of sys:node-dbid to another property. Or its far more complicated.