HI, below is a quick SQL tutorial on extracting a user's registration information without using Dynamic User Directory. Just plain transact SQL statements.

The two SQL tables you want to look at are: (DynamicRegistration_Question, DynamicRegistration_QuestionResponse).

The columns you're interested from table DynamicRegistration_Question are: DynamicQuestionID, Question,PortalID,ModuleID,ShortfieldName).

NOTE:

DynamicQuestionID: is the primary key (ID) that is the reference key to all the other tables

Question: that’s the question label on your Dynamic Registration page

PortalID: the portalID of your DR page

ModuleID: the moduleID of your DR page (so you can have multiple DR modules on the same page or other pages)

ShortfieldName: that’s the shortname you’ve specified on each field

All the answers are stored in the DynamicRegistration_QuestionResponse table. Columns you are interested in are:

DynamicQuestionID:  this matches up with the “DynamicQuestionID” in the DynamicRegistration_Question column field

Response: This is the answer to the question

UserID: This is the UserID of the user who the answer belongs to

Sow now you have the relationship to retrieve the questions / answers to your Dynamic Registration page on a portalid / moduleid / userid basis.

For example, if your DR form is on Portal 0, have a moduleID = 20, and you want to obtain all the information that userid = 10 filled out, then use an inner join on the tables like this:

Select DRQ.question, DRQ.moduleID, DRQ.shortfieldname,DRQR.Response,DRQR.UserID from

DynamicRegistration_Question DRQ inner join DynamicRegistration_QuestionResponse DRQR on

DRQ.DynamicQuestionID = DRQR.DynamicQuestionID where DRQ.portalID = 0 and DRQ.moduleID = 20

And DRQR.UserID = 10

-- David