alfresco Data storage

[lmanoh]

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 first name , email id.. but i can able to access this information by using $ {person.properties.emailid}. it ll print email id. can anyone tell me where the information has been stored?

help would highly appriciated..

-Lenin

[jm_pascal]

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,