16 February 2009, 5:01

Hi....i have a problem..i wanna know  the name of the tablein which the information of profile fields are stored in the database..( artefacts/internal)

can u help me..

thanx in advance

16 February 2009, 10:04

Hello,

 think that the tables you are looking for are:

•  internal_profile_email 
• internal_profile_icon
• artefact_resume_personal_information

And the table artefact also contains information about users' profile.

 Regards

16 February 2009, 16:02

Also.. the usr table stores some profile fields that are cached copies of data in the artefact table.

Mostly, look in the artefact table where owner = [userid] and artefacttype IN (list of artefact types provided by internal artefact plugin, see artefact/internal/lib.php for this info).

17 February 2009, 11:38

Hi 

thanks for the reply we got the data we are looking for 

Actually we are implementing this Mahara for JNTU University for student e- portfolios

The problem is that the management want to use this for Placement and student job Recruitment activities.

for that we have changes the profile feild of the users in artifacts/internal to reflect there acemadic and educational Details :

now in the database there details are stored in tp_artifacts in not so good manner to quirres
like for example : they want to search for all students with GPA = 3.5
it looks like existing table is storing the values in rows for all feilds
but we want a table were feils are coloms and users are rows

how can we do that
hope u have understood our problem.