alfresco Data storage

lmanoh — Wed, 12 Nov 2008 10:17:26 GMT

Hi, im new to alfresco,I installed alfresco Lab 3 and configured with Oracle 10g. now i created a new user with first name, Last name and email id.Now my question is where this data has been stored? whether in DB or file system?because i searched in DB, i could not found any data like username and

Re: alfresco Data storage

jm_pascal — Wed, 12 Nov 2008 12:04:57 GMT

Hello!

Everything is node! So users are also nodes ! So they are stored in DB.

You can find all properties of this node in TABLE : alf_node_properties

Look at this query :

SELECT node_id FROM alfresco.alf_node_properties a
where qname="{http://www.alfresco.org/model/user/1.0}username"
and string_value="admin"‍‍‍

And with this node_id you can find everything about this node!

SELECT * FROM alfresco_formation.alf_node_properties a
where node_id = <your_node_id>;‍‍

An advice : Don't use SQL query to change anything!! It's clearly forbidden!!! Instead use Alfresco Foundation Services.

And of course, if you want to see your "user" nodes, use NodeBrower!
Choose user://alfrescoUserStore
and go to /{http://www.alfresco.org/model/system/1.0}system/{http://www.alfresco.org/model/system/1.0}people/{http://www.alfresco.org/model/user/1.0}user

Regards,

topic Re: alfresco Data storage in Alfresco Archive

alfresco Data storage

Re: alfresco Data storage